Hi,
I’m trying to write a BAQ which shows an exploded BOM. Our BOMs are multi-level, so we have top level parts with sub-assemblies which have their BOM and on those subassemblies there maybe further subassemblies.
I am trying to produce a BAQ which shows all the materials as if they are part of the top level BOM. So using a simple example:
BOM structure:
PartNum: TABLE
Mtl10: TABLELEG x 4
Mtl20: TABLETOP x 1
Mtl30: SCREWKIT x 4
Mtl10: SCREW x 4
Mtl20: WASHER x 4
I want a BAQ which displays as follows:
PartNum | MtlPartNum | QtyPer
TABLE | TABLELEG | 4
TABLE | TABLETOP | 1
TABLE | SCREW | 4
TABLE | WASHER | 4
This would then allow me to bring in costs and sum the cost of materials for my top level parts. My company uses standard costing for all materials and assemblies but I wish to recalculate the standard costs of our top level parts by reviewing actual costs. This is not easy to do!
Any help would be much appreciated.
jDJ