SAP Business One OITM AvgPrice

[former_member1012530]

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.

[Abdul]

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

[former_member599925]

Hello,

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

Hope this will solve your query.

[former_member1012530]

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

[azizelmir]

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

[azizelmir]

Hi Daniel,

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

Thank you,

Aziz El Mir