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?