Change in material prices- very urgent

[Former Member]

Dear Gurus

We have a very urgent issue to be resolved,

we have a situation where in we are finding a huge difference in the inventories posted in SAP to that of the legacy data for a particular month(JUNE) these inventories where first initially uploaded according to the data given by the client.

But the client has later realised that the price given for the materials was including Excise Duties, thats the reason there is a huge difference in the inventories.

The MM period for June was closed and july was opened, then the client wanted us to change the prices to the original rates that is without ED. so we have run MR21 as on 1st of july. even then the changed prices where not seen in Material

master.

Now the client is insisting on getiing the JUNE inventories exactly matching with legacy.

Note: The july transactions are already running online i.e all PO's have been closed for JULY but the PRoduction orders are still in pending.

In this kind of situation how can we get those inventories back correctly(for JUNE month).

Solution will definately be rewarded.

Thank you in advance

kavitha

[Former Member · Accepted solution]

If GRs have been done for POs already in July, you should not change the prices for June.

In such a scenario, one option is to have stock accounts with Credit balances (a purely FI entry) which will bring the value of the inventory down in the books.

Another option is to calculate the value manually for each material - i.e. the correct value (uploaded) and the PO Prices and do an MR21 to correct the stock value. This is the ideal solution but may not be practical to implement.

Hope this helps,

Lakshman