View to see if all materials available?

[gpayne (Greg Payne)]

@Adam @timshuwy posted a baq that does this here. Hopefully it will get you started.

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)