motoguzzzap - Wednesday, November 28, 2012 3:00 AM:
Is there a report to determine the qty's of all items used within Aras with for example the following lay-out:
Part, Description, Revision, Status, Part_BOM, Description, Qty.
Kind regards,
Ap van Gool
Dave_Rollinson - Friday, November 30, 2012 3:40 AM:
HI
You probably need to look at how this report is going to be used; if you're trying to estimate Part usage, then you need to flatten the BOM and work out the component quantities with respect to the top level Parts.
e.g. The quantity of Part C in sub-assembly B is 2, and the quantity of B in top level Part A is 4 so there are 8 Cs in an A. And if there are also 3 Bs in a top level Part X then there are 6 Cs in an X. What are you wanting to report for C; 2, 8, 6 or 14?
You need a recursive query to do this but it could be very slow to run as it will traverse every "Part BOM" relationship Item, sometimes more than once if sub-assemblies are re-used in multiple top level Items.
