Do we have an option if we want to revaluate inventory with different material prices? Yes SAP has provided an option to re-valuate inventory at different material prices /LIFO/FIFO etc. However I am not going to explain how system would calculate the LIFO and FIFO price (may be next time). You can calculate lowest cost / LIFO /FIFO price for material and revaluate your inventory with the calculated price. However there are few important things to know when using this process to post to inventory accounts.
I have tested this transaction to re valuate inventory at a price maintained manually ( not calculated) in the commercial price field of the material master. Since MRN9 is to revaluate your inventory at lowest cost price, you will not be able to revaluate inventory at a lesser price than standard cost in the material master. If the price in the commercial/ tax price fields is less than standard price, then inventory account is adjusted according.
Configuration has to be maintained in transaction OBYC – account determination. Maintain g/l accounts for transaction UMD and BSD.
Important facts to know…
Your FI and MM will not reconcile as this transaction is purely FI.
Material Ledger is not updated with the new price. Your standard price continues to be in the material master.
Though transaction BSD shows as “inventory posting” similar to BSX, both these do not act same. BSX posts to FI and MM so in material ledger, but BSD just posts to the FI inventory account. To have better reconciliation in FI, maintain similar inventory accounts for both BSX and BSD for each valuation class. This will help in reconciliation and makes sure the inventory adjustment is posted to the right account.
Be sure run it just “ONCE” as system does not recognize if the transaction was already run for the current period.
Posting keys assigned to these transactions doesn’t facilitate to reverse the postings. So if you are planning to reverse these transactions, change the posting keys in account determination to 40 & 50.
FICO bites 