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 appre…

I have a SQL view that I use… Not sure if this will be helpful to you. WITH pm AS (SELECT x.Company, x.PartNum, x.RevisionNum, x.QtyPer, x.FixedQty, x.MtlPartNum AS ChildPartNum, x.ViewAsAsm FROM Erp.PartMtl AS x INNER JOIN Erp.PartRev AS pr ON pr.Company = x.Company AND pr.Part…

Are you trying to do it via SQL or as a BAQ?

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)

Take a look at this thread. [image] Looking for SQL SP or Code to list full BOM for a part Epicor ERP 9 Here is a new base query we use. It has held up for about a year now. You may need to adjust the query a bit for your environment. with [BOMReviewParent] as (sel…

Thanks All, I will get to work to test each suggestion out and let you know the results.

I tried the baq called BOM Explode and it timed out.

Yea, you probably need to filter it to only one parent part number.

It seemed to prompt for a parent part number. [image001.png]

@tthayer did you eventually find a happy place where the BAQ would complete in a reasonable amount of time? I really wanted to find the parent where the Effective Date was not greater than the getdate(), and I was able to speed up the query by taking the PartPlant and Part tables and criteria out o…

I did get it to run faster but it was not by taking out tables. Even though the query was running in a specific company I found if I put a filter in on each table for company = ???. That made a huge difference. What I am thinking is by putting in the filters that criteria is then passed on to sql. W…

Build BOM in Query

Epicor ERP 10

knash (Ken Nash) April 26, 2021, 2:17pm 5

Take a look at this thread.

Topic		Replies	Views
BAQ indented BoM returning 100 repeating levels Epicor ERP 10 e10 , customization , baq	42	12781	May 27, 2020
Exploded bom baq for jobs completed the previous day Epicor ERP 10 e10 , epicor , baq	26	2915	April 5, 2023
Help with building a BAQ that shows indented BOM for all open sales line item Epicor ERP 10 baq	38	11120	January 22, 2019
Parent part, Sub Parts/Assemblies, material parts Epicor ERP 10 e10 , baq	8	5659	January 29, 2021
~If you want to recursively traverse the BOM you may need a CTE query?~ Kinetic ERP baq	43	13364	November 1, 2021

Build BOM in Query

Related topics