Skip to Content
0
Jul 30, 2015 at 03:39 AM

FIFO - MRF1 no difference with MAP

537 Views

Hello

I customized FIFO valuation.

OMWE - Activate/Deactivate LIFO/FIFO Valuation

OMWL - Define LIFO/FIFO Valuation Levels --> valuation area level

OMW4 - Define LIFO/FIFO Relevant Movement Types

OMWP - Define LIFO/FIFO Methods --> Single receipts - CUR

- Configure FIFO Valuation Areas

I am running MRF3 (extract) and MRF1 (execute) to revaluate my inventory, but the net price calculated is the same that the Moving Average Price.

i.e.

10/06/2015 GR 100 ea x $200 = Total $20.000

20/06/2015 GR 100 ea x $300 = Total $30.000

10/07/2015 GR 100 ea x $400 = Total $40.000

20/07/2015 GR 100 ea x $500 = Total $50.000

Here MAP = $140.000 / 400 ea = $350

22/07/2015 GI 150 ea x $350 = Total $52.500

Now the new inventory = 250 ea x $350 = $87.500 (valuated to MAP price)

But the FIFO revaluation using single-receipts method should be:

10/06/2015 GR 0 ea x $200 = Total $0.00

20/06/2015 GR 50 ea x $300 = Total $15.000

10/07/2015 GR 100 ea x $400 = Total $40.000

20/07/2015 GR 100 ea x $500 = Total $50.000

FIFO price = $105.000 / 250 ea = $420

However, when I run MRF1 I get $350 (MAP price) instead of $420 (FIFO price) --> difference 0.

I found the note 74316 and I made this similar example, using single-receipts method, but FIFO price = MAP price.

There are many discussions too, but all of them unanswered.

Any suggestions?

Thanks in advance.