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.
You can try to run the "Inventory by item group" report or the "Inventory value" report.
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.