MR11 execution for previous years: Inventory value impact

[Former Member]

Dear experts,

This is a subject that has already been discussed in different posts but I could not find an answer.

Our Customer has several purchase orders to close from 2010 to 2012. I precise that purchase orders are based on good receipts and that the Material Ledger is activated with Moving average price valuation. (Price control is "V" in MM).

For some scenarios, when executing the MR11, system creates a Material Ledger document to update the inventory value and material price. This eventually has a direct impact on inventory value for the present year.

I understand that it is a normal system behaviour in those cases but in the accounting point of view, customer does not want to affect the inventory value in 2014 with values coming from movements/PO's from 2010.

Is there any possibility to avoid the material ledger update ? Account substitution does not seem to be an option as in does not prevent the Material Ledger document creation and price update.

Has someone experienced solution provided directly by SAP consulting for that type of problem ?

What I see is to execute MR11 and then update the Price using MR21 or equivalent LSMW for mass update: This would reflect in the PnL as a price difference.

Customer would like to clear all this history without having to analyze all the cases one by one, but it cleary seems impossible except if SAP could provide some magic wand.

Best Regards,

Guillaume

[Former Member · Accepted solution]

Guillaume-

As you are aware that, the functionality which you are expecting is not feasible. As per my understanding it is not possible to do the changes to the inventory in the previous period which is already closed.

You have to this adjustments in opened period only.

In order to do rectification to the financial values which are impacted  due to closed period inventory adjustment- I can suggest as below:

1. Do the all inventory adjustments in open period

2. Create Manual inventory GLs

3. Post the difference as adjustment entry with respect to the fiscal year and period.

With this you can satisfy your Balance sheet as per the fiscal year

Regards,

Javed