How to calculate how many of a top level part can be built based on current inventory

[gpayne (Greg Payne)]

I would tell you to review @timshuwy’s bom_explode baq which does this in reverse as in can I build X, maybe it can help you.

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)