Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

FIFO - MRF1 no difference with MAP

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.

Tags:
replied

What is your setting in OMWEB transaction?

What you described looks like you carry out FIFO valuation with lowest value comparison.

The OSS note 74316 only talks about monthly summarized data, as it is only valid for R/3 3.1 release, and the individual receipt valuation came with 4.0

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question