item on-hand inventory by the end of each month


Is it possible for me to get the item on-hand inventory at the end of each month before?

traditionally, when we click the on-hand inventory for a item, it display the current on-hand inventory, but right now i want to know the on-hand inventory at the end of last month, and the month before last month, etc.

many thanks.

Inventory mangement\Reports\Status\Inventory value\Inventory value by inventory dimension


You didn’t specify your AX version. In AX 2009, there’s nothing like that, on-hand inventory is given in real-time. I had the same kind of requirement, the solution I developped was a batch job that stores every day on-hand inventory item quantities in a table.

Then I had an history of my inventory

Hope it helps