Inventory list with moving average price

[Former Member]

Hi all,

How do I get the list of inventory stock using the valuation method as MOVING AVERAGE.

Iam able to get the list using last purchase price, But how do I get it using Moving average Price.

Thanks in advance.

[Former Member · Accepted solution]

Moving average price for item might be different by each warehouse. Inventory Valuation Report can be used to get the whole picture for any single item by moving average price.

If you want to get more items, you can try this query to see:

SELECT T0.ItemCode, T1.ItemName, T0.WhsCode, T0.OnHand, T0.AvgPrice, (T0.OnHand * T0.AvgPrice) AS 'Amount'

FROM dbo.OITW T0 INNER JOIN dbo.OITM T1 ON T0.ItemCode = T1.ItemCode WHERE T0.OnHand > 0

Thanks,

Gordo

[Former Member]

Just to confirm that this really is a requirement when you are using perpetual inventory and we really need this to be integrated in standard one day.

Example of why we need this : how do you receive goods outside POs ? Which price ? The one that makes most sense if we have an exceptional transaction can be the average price. But where do you find this ?

Thanks for the query. Will apply it as well.

[Former Member]

You can use the 'Inventory Audit Report', which provides an audit trail for the posted stock transactions as per the Inventory Valuation in the chart of accounts.

[Former Member]

This report dosnt show average price of items. I need Avg price of each item.

[former_member583013]

What all information do you need in this report. I mean the columns in your outout

How will you want to open this report / see the report?

What is your system setup as..Moving Avg / Standard?

[Former Member]

Hi Sampath,

1) I need following fields in my report, ITEM CODE, ITEM NAME, AVERAGE PRICE Of Item. These 3 fields are mandatory.

2) We are using moving average as valuation method.

3) Need a straight Report from SAP which we should be able to generate when ever we need.

Thankyou.