Skip to Content
avatar image
Former Member

One GR reversal used Moving Average price(all others reversed with actual price)

Hi Experts,

Please help me on this issue!

Attached is the Purchase Order history pricing calculation for Goods Receipts /Reversals and Issues.

As per the process and standard SAP, all Goods Issues used MAP and reversals used the actual price when GR was posted.

But for one of the reversals, system used Moving Average price. Please refer to Qty 3758 for reversals. It used MAP to post reversal.

The movement type used is 102 which is reversal and not 909 (909 is usually populated when we do GI) . 102 is correct but used Moving Average Price.

Due to this, a difference of $94K is generated in Accounting which is becoming an issue.

If it is real Moving Average Price, then it should not be an issue. But, in this case, a specific transaction which should actually use actual price used MAP price which raised a big question and concern in Ops and Accounting Reporting.

Request your kind input on this one. I did read the Notes and other posts on this but did not match my issues with any of them.

NOTE: There is also another issue in this PO transactions: The second goods receipt consumed all of the components -75015 which is again system generated and not user input . This has been reversed gradually without issues. Attached MAP calculation in .jpg

I am not posting a request for this one as it might confuse with my above one and will post in another discussion.

I looked at table CKMI1 and MAP Report S_P00_07000139 and understood that MAP Report doesn't use time of transaction and just date while CKMI1 uses time. Attached is the screenshot of the CKMI1 extract. I prepared the map-1 using it showing the Moving Average Price calculation.

Thank You!

map-1.jpg (191.4 kB)
ckmi1-1.jpg (492.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers