Manual "pegging" of sales orders to forecast

K2022.2.14

I know that there is no pegging details stored to show what sales orders have consumed which forecast and based on changes between MRP runs this information can change over time.

However, my understanding is that you can look at open and closed sales order releases, that have not been voided, to do a manual exercise to see what which sales order releases are pegged, so to speak, to which forecast entry and back into the consumed numbers.

If we have monthly forecast entries and a 0 Days Before and 30 Days After window, it is pretty easy to work it out.

However, if we have the same monthly forecast entries and a 0 Days Before and 180 Days After windows we are finding it difficult to back into the consumption numbers.

I understand that we have overlapping forecast windows but the math seems to fall apart when we have a sales order release that is partially consuming one forecast and should continue consuming on the next forecast for the remaining amount but with that in mind, we can’t make the numbers work out. By that I mean, a forecast entry will show a net remaining in Time Phase but I can’t back into that number.

I’m going to read the MRP technical reference tomorrow to see if I can figure it out but I was wondering if anyone has some input on what I might be missing in this scenario.

@joerojas Are you running multi level pegging? We do not use forecasts, but according to this Forecasts are considered.
https://epiccare.epicor.com/epiccare?id=epiccare_kb_article&sys_id=1379932a1b227c908205ce4a5a4bcbd3

I run mlp three times a day to peg sales orders to their supply.from jobs or stock.

I added a forecast for a part and it was in PegDmdMst as a DemandType of F and looked like this in the Pegging Display.

image
image