I wonder if there is a clean way to isolate components and finished items net inventory for a given period when using costing other than standard AX 2012 CU2. we have production orders in stages - some started, others ended as well as some reported as finished. Matl auto consumed at Start. Inventory reports doesn't break this down as easily as they show total physical, financial values - For raw materials total, we try to arrive at this value by looking at the inventory transactions of what is "Sold" + "deducted" - "Received" from Production transactions. And take what's received and purchased from PO. One other thing that complicates the matter is when the item is physically received or deducted vs when they are sold/purchased (if one of them fall outside the given period).
thanks for your insights.
I am also interested to know this!
Have you looked at the new Inventory Report in AX2012? You can setup how to view or reconcile your inventory. E.g. you can choose if you want to have the physical and financial value shown seperately or summed up.
Hi Andre, we can see the physical and financial separately - that's no problem but not able to get the break-down of the how much value is in the raw materials inventory and FGI?
You should be able to filter by the resource group, which can reference the item group, and if you have segregated your items you can run it twice on this basis to get the split.
thanks for the feedback. thats one of the problem where the item group wasn't set up to distinguish raw vs finished item - that's we are doing now. But in the meanwhile, it is bit difficult to isolate these two