SBX - Search With Button

SBX - Forum Post Title

Get Average Item Cost

Microsoft Dynamics AX Forum

Mohammed Jabir Abdul Hameed asked a question on 12 Jul 2018 4:48 AM

Question Status

Suggested Answer

I need to get the current inventory average cost and stock qty.

My parameters are Date, Itemid and Warehouse [or InventDimId]

Can anyone help me with default methods or way to accomplish this need

Thanks in advance.

Reply
Suggested Answer

Hi,

With a single date value you cannot calculate an average because you need to define the date range for which the average shall be calculated.

Have you already checked the inventory value report that allows displaying an average value for the period the report is run?

Best regards,

Ludwig

Reply
Mohammed Jabir Abdul Hameed responded on 13 Jul 2018 9:15 AM

Hi,

First of all appreciating your time.

By default, AX have a report "Inventory aging" in which you can define parameters

- As on date

- Item

- Warehouse

By running this report, we get average cost price for item by warehouse, along with other values

I need similar solution inside a standalone AX job, where I can pass itemcode, warehouse and date (if date range, i will pass starting date of ax implementation and desired date.  Thats ok ?)

Thanks in advance

Reply
Suggested Answer

Hi,

With a single date value you cannot calculate an average because you need to define the date range for which the average shall be calculated.

Have you already checked the inventory value report that allows displaying an average value for the period the report is run?

Best regards,

Ludwig

Reply

SBX - Two Col Forum

SBX - Migrated JS