Skip to Content

SAP Business One OITM AvgPrice

Hello Community,

I hope somebody can help me. I need the moving average price of all materials retroactively to a certain date.

Is there a default report for this, or is there a way to do this using the Query generator?

Thank you very much for your support.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Jan 17 at 08:58 AM

    Hi Daniel,

    Please check this link https://archive.sap.com/discussions/thread/1203708

    Thank you,

    Aziz El Mir

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 17 at 10:00 AM

    Hi Aziz,

    Thank you very much!

    I created the Query, but there are two problems with that.

    1. I can not select a certain date in the past.

    2. The moving average price output of the report is on all items 0,000

    Add comment
    10|10000 characters needed characters exceeded

    • For Point 2: Are you using moving average as valuation method ?

      Please check the 'Inventory Audit Report' on SAP, which provides an audit trail for the posted stock transactions as per the Inventory Valuation in the chart of accounts.

      Thank you,

      Aziz

  • Jan 18 at 08:10 AM

    Hello,

    Please check Inventory Audit report which is SAP standard report in Inventory Report Module.

    Hope this will solve your query.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23 at 06:58 PM

    Use inventory audit report and click collapse on lower right corner of report it will give avg price of each item in one line along with quantity

    Add comment
    10|10000 characters needed characters exceeded