Skip to Content
avatar image
Former Member

Inventory list with moving average price

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 20, 2009 at 03:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2009 at 06:04 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • avatar image
    Former Member
    Mar 02, 2009 at 01:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded