Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
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.
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?
First of all appreciating your time.
By default, AX have a report "Inventory aging" in which you can define parameters
- As on date
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
Business Applications communities