Mateial Master Upload Issue during implementation

[pankaj_adhikari]

Hi All

During implementation we uploaded materials with alternate unit of measure. However the user gave the price for alternate unit of measure. Example- A material has base unit of measure as EA & alternate unit of measure as CS. 5 EA=1 CS. Now the user have price as 35 per CS & we though its per EA & uploaded in PRD. Is there a way to correct it as there are around 900 such materials? The price is now greyed out. One way is to marked these for deletion & create new materials but then we have created materials based on there numbering, Second way is through MR21 but then it will hit their G/L's which I don't want at the moment. Any other idea? They are yet to give us actual inventory.

Regards

Pankaj

[Garcia · Accepted solution]

Hi Pankaj,

If you don´t have loaded the initial inventory yet then, most probably, there are no movements yet.

If the only thing you have in is the Material Master data, then there should be no problem in correcting the valuation price via MR21. If, on the other than there was already stock movements you should consult your FI colleagues to discuss how to clean.

Another assumption is that you´re talking about standard priced materials, because moving average price materials is less of a problem.

As best practice, replicate the issue and resolution in development/quality system before any action in prod.

All the best,

[Svetlana73]

Hello,

If the price is wrong it means that the Stock account has a wrong balance ( wrong amount 35 per CS , but must be 5 times lower for an EA) , so the Inventory account has a wrong balance in FI reporting ( in the Balance sheet). hence, it has to be corrected in FI.

I think MR21 will help you to revaluate the materials with the wrong price and correct the Stock accounts in FI.

Discuss also with the FICO team as well to align on the strategy for the correction and test it before doing the correction in the productive system.

[pankaj_adhikari]

Thanks. As mentioned I m aware about MR21 but since this is implementation phase don't want to use it as it will impact G/L.

Regards

Pankaj