Is there anywhere where I can see the details of what happens when I submit the MRP process? I'm wondering why the 'Building PartList Level: 7' Activity is so long in the Generate Suggestions

[JasonMcD (Jason McDermott)]

If it’s because of SQL, you can try this.

Intro:

Process MRP Failing

No kidding, I had a huge issue with TFOrdDtl 11 months ago and now I see what you mean - I am not alone there! So, I have a whole write-up on the site here about this… BUT - I can’t get to it since I am not a “Regular” at the moment. But the solution is to get into SSMS and “force a good plan” from the query store. That was gibberish to me until a walkthrough from a great Epicor consultant (they do exist).

Guide:

Process MRP Failing

Here you go. Pick a flavor: Why is this step of MRP taking so long.pptx (690.4 KB) Why is this step of MRP taking so long.pdf (651.8 KB)