FIFO Value is not calculated correctly in MRF1

kapil_mehta · ‎2023 Mar 28

Hi

I have configured FIFO Valuation but after MRF1 FIFO cost is not calculated as expected.

In OMW4, LIFO checkbox is selected for movement type 101 & 201.
In OMWE, LIFO & FIFO Active radiobutton are selected. This was present earlier and I did not change.
In OMWL, FIFO Valuation at Valuation area level & Mean receipt price at Valuation area level are ticked.
In OMWP, Method ZFIFO1 is used. It has Sample 01, Single receipt ticked & CUR.
In 'Configure FIFO Valuation area', plant used for testing is specified.

After doing above config, I created 2 POs for same material with different price, did GR using 101 and then did Goods issue using 201.

Movement type Quantity GL posting amount MAP
101 19.308 1000 51.79
101 48.27 3000 59.19
201 24.135 1428.57 59.19

Above transactions were done on different posting date but same 'created on' date. Now I expect FIFO Inventory value to be 2700 i.e. 3000 * ( 43.443 / 48.27). Accordingly FIFO
price should be 2700 / 43.443 equal to 62.1504.

Executed MRF4, MRF3, MRF1 in sequence. In output of MRF1, Book, Net and Gross value are all same.

In MYMP table, Quantity received is updated by system as 24.135 which is quantity of goods issue. System should display 43.443 here which is net quantity.
In MYMFT table, FIFO Value is 2,571.43 which is incorrect as explained above.

Please let me know how to achieve correct FIFO value. Is my understanding incorrect somewhere ??