BAQ Help - Indented BOM Materials Append Operations

Kinetic ERP
1

Working on a project with an end state of passing on increased material costs to a customer. My final calculation will include any material that meet certain criteria as well as any outsourced operations.

I found a BAQ from Doug C that creates an indented BOM. I tweaked it to include some table criteria, additional necessary fields, sorting that handles materials that appear twice in the list, etc.

I have also created a BAQ that lists any outsourced operations for parts on the price list.

I need to essentially “append” the outsourced operations list to the materials list, then resort so that operations are at the top for each material. I’m at a loss on how to union the two queries. Any help would be greatly appreciated!

BOM Materials.baq (70.0 KB)

BOM Operations.baq (84.2 KB)

2

I didn’t open your BAQ’s. But if you want to union them, use the ( ) in the subquery list to group the sections together. One will have the top level, and the other with be a Union or Union All.

Both of the queries will need to have the same number and type of fields for that to work.

image

4 Likes
3

Thanks Brandon!

1 Like