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.