I would like to use a Single level BOM report structure to display a full Bill of materials that mimics the the output of information given if doing a BOM In the cad only structure. We currently use a recursive table to give us the sum of all assemblies used in a Vehicle no mater what structure level they are at. We use this as a picking list to give to our stores. The problem is that since we have started to assemble wt items into our assembly structure we now have no way of creating the same table/bom for our wt assemblies. The Single level BOM report does not give the same results if done using the wt structure compared with doing the same report with the cad structure. Has anyone had to do a custom report for this to work? Thanks
Below is a Single level BOM report structure using wt items, In this report it will not sum up the total assemblies needed, instead you would have to times each assembly by the parent assembly to gain a total. This is not ideal when we using hundreds of assemblies.
Below is a Cad only Single level BOM, This is the ideal format that we require for our wt assemblies:
Do want to have quantity auto calculated something like in this thread
Dave -what happens if a lower level item has multiple occurrences? How should your logic calculate (total) quantity and then do you display it for each occurrence? My sense is that there is potential for confusion and/or error. Have a look at the Consolidated Parts List report to see if it meets your needs.