I need to pull an exploded bom for jobs completed the previous day. I know the is a cte recursion in the help files but deleting the partnum parameter yields all boms. I’ve tried modifying but it runs extremely slow (10+mins to pull 400 lines). Any ideas?

I may have overhauled nearly all of the query… Anyway, here it is, and most shockingly to me is that it only takes 7 seconds in SSMS. I tried my best to make sure you could reimplement it as a BAQ and I tried to match the naming but gave up at some points. with [MaxRev] AS ( SELECT [PartRev].[Com…

I think this may be an XY Problem . Do you really need to pull all of the exploded BOMs or do you just need to see what was issued?

Are you trying to pull the Engineering Master BOM (PartMtl table), or the Job BOM (JobMtl)? Job BOM should be fairly simple, and wouldn’t require recursion. SELECT {columns} from erp.JobMtl INNER JOIN erp.JobHead ON JobHead.Company = JobMtl.Company AND JobHead.JobNum = JobMtl.JobNum WHERE JobHead.…

Job bom excludes phantom subassemblies and I need to see these.

Just posted this in another thread. It may work for you too? [image] Phantoms needed on job tracker ERP 10 At my first Vantage implementation, we used phantoms with the configurator like @CSmith . In order to preserve which assembly the part came from, they populated a fie…

Why do you need to see if material originated from a phantom? just curious.

We have a project going to realign production standards and we use them on our phantoms. In order to do this we analyze the kanban receipting each day and do an efficiency metric. Gets convoluted when you don’t clock in and out of jobs as you probably know kanban receipts have instant clock in and o…

I’ve got most of this working. I can pull an exploded bom of the kanban receipts however when I try to pull in production stds for the materials I either lose 90 percent of the bom or I get multiple different STDs caused by various unapproved revs. I’m joining partopr to partmtl.mtlpart and rev to r…

Ok. Got this to work and it runs in 5k ms. However, I can’t get the main part and the material column to union or merge. It times out after 10 mins with no results. Any help is appreciated.

getting the revision thing working if you have multiple approved revisions can be very challenging. you have to find the “latest” revision (or currently active revision if you have future effectivity dates). Also, doing revision searching for each part as an inner sub-query can be very expensive. Yo…

Exploded bom baq for jobs completed the previous day

Epicor ERP 10

Mark_Wonsil (Mark Wonsil) March 31, 2023, 9:05pm 5

Just posted this in another thread. It may work for you too?

Topic		Replies	Views
~If you want to recursively traverse the BOM you may need a CTE query?~ Kinetic ERP baq	43	13324	November 1, 2021
Build BOM in Query Epicor ERP 10 baq	28	13766	August 14, 2024
Parent part, Sub Parts/Assemblies, material parts Epicor ERP 10 e10 , baq	8	5656	January 29, 2021
Indented BOM - CTE Expression Epicor ERP 10 baq	15	1680	February 5, 2024
Recursive CTE BAQ parameters Epicor ERP 10 baq , cte	21	1521	October 1, 2024

Exploded bom baq for jobs completed the previous day

Related topics