We are using
Moving Average Price for Raw material valuation and
Standard Price for WIP and FG valuation.
We are carrying out costing run every month (CK40N) and update the price to the material master.
The closing stock of materials are updated on the latest standard price available in the material master.
Our auditors require us to keep / show the break up value of the closing stock at the respective month's standard price.
For example, if we have a total closing stock of 300 out of which 100 has come from June @ 10, another 50 has come from July @ 11, an another 150 has come from August @ 12, then the total closing stock
value should the shown as
June 100 x 10 = 1000
July 50 x 11 = 550
Aug 150 x 12 =1800
Total = 3350
Is this possible in SAP?