Use multiple material prices in BW inventory reporting (non-cumulative kf)
We are implementing inventory management reporting in BW. We will use the non cumulative key figure scenario (making use of movements instead of snapshots).
One of the requirements is to report on stock aging (in monthly buckets) at several material prices (e.g. standard price, factory cost price, sales price).
The prices can be changed at any time.
Does anyone have a solid solution how to make thes prices available in reports for calculating QxP?
Current stock level needs to reported at actual prices but is a summation of historic goods receipts. Simply adding the price to the material revaluations is no option.
Who has a bright idea?