Stock management report

Finance and Operations/AX User Forum
1

Hi All,

I want to find a report in AX 2012 R3 that would show cost and price changes within a period. Ideally an Cost movement report. Can anybody let me know, if anything exist like that in AX?

Thanks!

2

I haven’t seen such a report. There exists a “Item prices” report, this may not fulfill your requirement.

3

Thanks Kranthi,

I have another question is there any report in AX which can show stock that hasn’t moved for the last 12 months (no inventory transactions), but also show if it has pending transactions in the future and subtract the quantity (like sales orders, production orders)?

4

You can use inventory aging for that, but it not sure if it handles the requirement to subtract the future transactions quantities.

5

You could try using the inventory cube and seeing what you can pull out of it. It has cost amounts and quantities, including opening and closing balances by period. You can access it through Excel and then create a report as needed.

-Jake