Bug 2529

Testing done with the user(Mr Santosh) ,Report was ok from his side.
After fulfilling all the requirements of the user and and verified by the user and he said all the points are covered and you can close the call.

Testing done with the user(Mr Santosh) ,Report was ok from his side.
After fulfilling all the requirements of the user and and verified by the user and he said all the points are covered and you can close the call.

1. Modify column "GRN RATE PER PCS" round in 3 digit 
2. Old bom & New Bom mark "old or new"

if any query call me

Created attachment 1159 [details]
Check attachment

Please see below point 

1. Item code print PM OR RM but print finished goods item
2. Old form bom and new form bom not merge, requried separate

Its Done.
Please check and confirm.

Point for filter 

1. Company Wise
2. Only Active status record
3. New Form and old from bom both data required in report

yet not resolve

  santosh
(9315301151)

Done.
Please check.

Working on it..

REMINDER

PLEASE RESOLVE IT IS VERY URGENT

Please pik BOM from report no. FGIF0700 and FGIF0565

Report is yet to be modified according to the format given by us.

New Report made for costing.
Please Check and verify.
In report Launcher FGIR0710 - Costing of Packing Material.

COMPANY||'-'||GRN_TYPE||'-'||GRN_SERIES||'-'||TO_CHAR(GRN_NO)||'-'||TO_CHAR(GRN_DATE,'DD/MM/YYYY')

PROCEDURE GET_LAST_GRN_RATE
 (P_ITEM_CODE VARCHAR2
 ,P_STOCK_TYPE VARCHAR2
 ,P_GRN_REF	IN OUT VARCHAR2
 ,P_GRN_RATE IN OUT NUMBER
 );


PROCEDURE GET_LAST_GRN_RATE
 (P_ITEM_CODE VARCHAR2
 ,P_STOCK_TYPE VARCHAR2
 ,P_GRN_REF	IN OUT VARCHAR2
 ,P_GRN_RATE IN OUT NUMBER
 )

 IS

 --Create by MS Dt. 15/01/2020
 --Bugzilla Call ID 2529

BEGIN
    BEGIN
        SELECT COMPANY||'-'||GRN_TYPE||'-'||GRN_SERIES||'-'||GRN_NO||'-'||GRN_DATE, GRN_UM_ITEM_RATE 
        INTO P_GRN_REF , P_GRN_RATE FROM GOODS_RECEIVED_NOTE_ITEMS
        WHERE GRNITM_RECID =    (SELECT MAX(GRNITM_RECID) FROM GOODS_RECEIVED_NOTE_ITEMS
                                 WHERE GRN_ITEM_CODE         =     P_ITEM_CODE
                                 AND   GRN_ITEM_STOCK_TYPE  = P_STOCK_TYPE
                                     AND GRN_DATE            = ( SELECT MAX(GRN_DATE) FROM GOODS_RECEIVED_NOTE_ITEMS
WHERE GRN_ITEM_CODE         =      P_ITEM_CODE
AND   GRN_ITEM_STOCK_TYPE  =    P_STOCK_TYPE    ))
        AND  GRN_ITEM_CODE             =      P_ITEM_CODE
        AND  GRN_ITEM_STOCK_TYPE      =    P_STOCK_TYPE;
    EXCEPTION
        WHEN NO_DATA_FOUND THEN NULL;
        WHEN TOO_MANY_ROWS THEN NULL;
    END;
END;

Reminder-2

REMINDER

USE FUNCTION : PKG_IC.GET_LAST_GRN_RATE

ADD NEW COLUMN AS PER ABOVE FUNCTION 

QUERY GET FROM BOM PRINTING REPORT

(In reply to Mahender from comment #1)
> Please give bom format report no

BOM REPORT NO. IS FGIF0565

Please give bom format report no