How do I know if I have all the parts in stock to start assembling my job

[gpayne (Greg Payne)]

Here is @timshuwy version. I can’t move it to code sharing.

Build BOM in Query

This CAN be done… but it takes a RECURSIVE (CTE) BAQ. I have demoed this in the past at user group meetings. Note that this is NOT something for the faint of heart… your brain gets twisted while trying to get your head around a CTE query. BOM_Explode.baq (72.8 KB) Recursive BAQs.pdf (983.2 KB)