Multi-level BOM BAQ

Epicor ERP 10
,
1

Hi,

Has anyone managed to create a multi-level BOM BAQ? I’m basically trying to create a report which lists all materials against their parent part code. I was then going to add in a criteria of a particular sales price list so I can see all parts, either sellable parts or materials of sellable parts, on that pricelist.

Jonathan

2

Yes, there are a few discussions/examples - using CTEs.
Here is a link to one Indented BOM SQL Query
I think you should be able to find a few others by searching for INDENTED or CTE