AX2012 Item Cost / Inventory Value Report (by specify date)

Question Status

Arqxlep asked a question on 26 Apr 2013 6:36 PM


Could anyone please help on advising the AX2012 item cost / inventory value reports as of specific date?

We are using FIFO costing method in AX2012, but as AX would use running average cost to estimate item cost before inventory closing or recalculation, could anyone advise which report(s) could show item cost / inventory value as at specific inventory closing date? We could like to get the FIFO cost (realized cost) on specific inventory closing date when generating the report.

We appreciate your help.



André Arnaud de Calavon responded on 27 Apr 2013 12:09 PM

You can try to run the "Inventory by item group" report or the "Inventory value" report.

Ihab Mahmoud responded on 1 Jan 2015 2:02 PM

I think AX 2012 used exprtion of Realized cost amount for the total cost of picked raw material & any additional costs on production line in case of production order status not ended and in this specific case this amount will not appear in inventory value report as a financial amount.

I hope this may help.