Multi Level Pegging a Multi Level BOM

[dgreenEA (Dylan Green)]

I’m attempting to understand the Multi-Level Pegging tables: PegLink, PegDmdMst, and PegSupMst.

Having followed both these threads:

Linking the Sale Order form to Job Entry through Dashboard or BPM

Hello, I am a new user to Epicor 10, and I’m looking for a bit of direction on how to go about creating a form that will add Co-parts, and another one for Jobs, to the Sales Order, without having to open multiple screens. We currently create our Jobs as a new line on the Sales Order and then go to the Job Entry Form and create a Make to Order Demand. For Co-parts, it is similar but we create a Make to Stock Demand. I am trying to create a “shortcut” form that allows us to open one window to do t…

Multi Level Pegging - SQL table

Hello all, Can somebody tell the name of the tables that hold multi level pegging results ?

I get how they interact with one another from a top-level aspect job “ties” to sales order. @bordway made a really good dashboard in the second post that nearly gets me where I want to be.

What I’m looking for is Multi Level Pegging but for the entirety of an exploded BOM. Some of our parts go 4 levels deep and I want to get those preceding jobs linked in on this somehow. I thought by building a recursive CTE BOM and then linking in the Pegsummary table I would be close. But now I’m stumped on how to tie up the demand and supply links, job to job, to the top-level demand, sales order.

Anyone got any pointers on what my next step is?

[anna.zellar-bernal]

Hello following up on this post as I’m working to create a similar report for my business. Were you ever able to create something that iterated through every level?

[Paras_Sood]

It is truly disheartening that there is such a lack of resources available for multi level pegging. I believe that this can be a great tool if we understand how it works. Does anyone have any resources where they go through the UI in Epicor with an example and explain how it works? If you could create it man that’ll be super awesome!

[anna.zellar-bernal]

I will keep you updated! I am currently testing out a CTE query within epicor on a small scale with hopes of running a daily job in SSMS if I can get the logic.

[Paras_Sood]

Any update?

[Paras_Sood]

Been 6 months but still struggling with this. Did create a very clunky version of BAQs which does link the multi level BoM but it’s very hard to read, hoping for a better solution.
We have a use case where we need to be able to see all the job links that MRP has created for a top level part on an order so that we can analyse where we might run into a shortage. Hoping to get some sort of feedback.

[rppmorris (ROBERTO MORRIS)]

I have used multi level pegging at a number of sites and might be able to offer some assistance.
Let me know if you would like me to assist.

[Paras_Sood]

Hey Roberto,

Yes dying for help at the moment. I have managed to make a dashboard that is quite clunky to look at but gives a breakdown of all the job links that MRP has planned. Need to make this a bit more refined and add more information if possible.

[rppmorris (ROBERTO MORRIS)]

My BAQ starts with:

Criteria: SupplyType = ‘J’
This is Type CTE
Next:

Criteria: SupplyType = ‘J’ on both
This is Type UNION ALL
Next:

Criteria: SupplyType = ‘J’
This is Type TopLevel

This is my building block for all Pegging cte Dashboards.

Is this similar to what you have?

[Paras_Sood]

Nah we’ve created a very clunky External BAQ with an Epicor consultant with joins on the same table that’s a bit hard for me to follow. Is it possible for you to export your BAQ so that I can import it in my environment?