Hi,
We have activated FIFO valuation and all configuration was set. We done MIGO with different rate and Consumption also done.
Month end we have don e the following process
MRF4,MRF3 and MRF1
the result is system is taking the moving average price only instead of FIFO valuation.
Goods Receipts
Qty price value MAP
100 100 10000 100
150 120 18000 120
200 180 36000 180
450 64000 142.22
Issues :
100 142.22 14222.22 142.22
150 142.22 21333.33 142.22
250 35555.55 142.22
200 0 28444.45 142.22
As per FIF the following is the rate system to take and post
200 180 36000 180
But system is takinf 200 * 142.22 = 28444.45
can anyone guide me to solve this issue.
govind.