cancel
Showing results for 
Search instead for 
Did you mean: 

MRF1 report doesn't calculate FIFO amount

Former Member
0 Kudos
1,437

Hello, experts,

I would be happy if someone answer my question.

I have a problem related to FIFO function.

My client has decided to implement FIFO valuation. I completed all of

FIFO configuration. Then, I executed Trcd:MRF1 to get FIFO amount.

However, the FIFO amount is NOT calculated correctly. The report seems

to pick up the Moving Average Price.

e.g. Book Value: 550.69, Net: 550.69, Gross: 550.69

*550.69 is Moving Average Price

<FIFO configuration>

1. OMWE: LIFO valuation active, FIFO valuation active

2. OMWL: Mean Receipt Price at Valuation Area Level

3. OMWZ: No configuration

4. OMW4: No change

5. OMWP: Method(FIFO01) Sample(01) Qty.comparison(CUR)

6. Configure FIFO Valuation Areas: 2009

<FIFO process>

1. MRF4: Set "LIFO/FIFO-relevant"

2. MRF3: Execute it to extract the data

3. MRF1: Execute it to show FIFO amount

*At this time, the report doesn't show FIFO amount.

e.g.

Goods receipt: @$10, Qty3 = $30

Goods receipt: @$12, Qty5 = $60

Goods issue: @$11.25, Qty3 = $33.75

*Moving Average is $11.25. Invendoty balance is $56.25.

FIFO inventory balance should be $60

However, MRF1 show Moving Average ($11.25). It is not $60.

Could you please provide me any idea to solve this issue?

Best regards,

Hidekatsu

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Run TCode OMWP

Check "Single Receipt" for your FIFO method. If you cannot change, should create a new method.

Read more http://help.sap.com/erp2005_ehp_03/helpdata/EN/47/61076e49f011d1894c0000e829fbbd/frameset.htm

There is different result between FIFO Valuation Based on Period Receipts and Single Receipts.

Regards,

Kim Loan

Globalcybersoft, Vietnam

Former Member
0 Kudos

I have a similar issue even though the FIFO Method is set for single receipts. Will appreciate feedback on how this issue was resolved.