component value vs finished item from Inventory AX 2012

This question is not answered

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.

All Replies
  • I am also interested to know this!

    Mansoor Adeel

    AX 2012 Techno Consultant

  • 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.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • 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.

    Steve Weaver | Dynamics AX Solution Architect - UK | My Blog

    This forum post is my own opinion and does not necessarily reflect the opinion or view of my employer, Microsoft, its employees, or other MVPs.

  • 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