item on-hand inventory by the end of each month

Finance and Operations/AX User Forum
1

Hi

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.

2

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

3

Hi,

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

regards,

Thomas