Skip to Content
0
Jun 24, 2020 at 06:44 PM

MRKO settlement based on the GR date of the material

191 Views

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.