Skip to Content
0
Apr 10, 2013 at 04:39 PM

Historical Inventory Valuation

554 Views

Hello, I'm looking to find the value of an item on a specific date and cannot seem to find a built in SAP report to get this information.

For instance, I need to see the quantity in stock for all items that are in stock for a specific date and their avg price.

So, I'd like to see what my inventory valuation on 12-31-2012 was on an item level, i.e

ItemCode
AvgPrice QtyOnHand
12345 33.33 17 45678 39.22 5 8910 25.00 1

Is there an easy way to do this through the UI? If not, any ideas on a query? -- OINM?