Supplier Price List BAQ to display ALL material parts

[arizonaplr (Patti H)]

I’m looking to create a BAQ from supplier price list that will display all material parts, all levels of BOM.

Anyone have any ideas?

[aosemwengie1 (Alisa Osemwengie)]

There are lots of threads about how to retrieve the bom in a baq like this one:

Build BOM in Query

Does anyone know what the links are to build a full BOM report. I have tried Part and PartMtl and linking the PartMtl again to go 10 levels deep but when there are multiple Revs it gets muddy. I have tried for years to build a query to recreate an exploded BOM but never successful. Any help appreciated.

There are many more if you search.

If you only want parts that are on the supplier price list then you could just join the price list to the anchor.