FIFO - MRF1 no difference with MAP

[anibal_mourelle2]

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.

[JL23 · Accepted solution]

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

[anibal_mourelle2 · Accepted solution]

Thanks a lot Jurgen.

I forgot OMWEB, that was the key.

[Former Member · Accepted solution]

This message was moderated.

[S0024827305 · Accepted solution]

Hello Juergen,

Im too facing same problem.

Would you mind sharing the OMWEB solution with screenshot & how you solved the problem?

Is my OMWEB wrong ?

Regards

Monir

[S0024827305]

Hello Anibal,

Im too facing same problem.

Would you mind sharing the OMWEB solution with screenshot & how you solved the problem?

What's wrong here in my OMWEB?

Regards

Moni