Hello,
I have a requirement where the price to be picked for the material during MRKO is to be based on the GR date and not on the consumption/GI/transfer posting date (from consignment to own).
Ex, I receive (101-K) 10 units on 1st May (price in PIR-10 EUR/EA) , 10 units on 1st June (price in PIR - 20 EUR/EA) , I post 201-K for 20 units.
During settlement I want the price to be, (10*10) + (20*10) = 200 EUR.
Currently, the system considers the price valid for the GR date & not GI date.
I set up the following:
1. batch management,
2. auto batch creation during each GR.
3. Auto batch determination based on fifo (based on batch creation date)
4. Enabled Valuation category = X in accounting 1 view.
Please help me with the missing concepts & steps.
Best regards,
G.