Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Open and pending sales...
Small and medium business | Business Central, N...
Unanswered

Open and pending sales orders in MRP run

(1) ShareShare
ReportReport
Posted on by Felicity 38
Hello
 
Is there any way to exclude open and pending approval sales orders from the MRP run. 
 
The challenge we have is that until a sales order has been approved the business has not committed to it and I cannot see a way of being able to (i) see the sales order document status against a proposed production on the planning worksheet (ii) filter the planning worksheet to run using only released sales orders. We do not want to be triggering purchase orders and creating production orders where we have not committed to the sales order demand. 
 
I hope I’m not just the only one and there is a solution to combat this. 
 
Any thoughts / suggestions appreciated. 
 
Flick 
  • Jun Wang Profile Picture
    Jun Wang 7,604 Super User 2025 Season 1 on at
    Open and pending sales orders in MRP run
    maybe you could try to create a virtual location for the orders that haven't been approved. Then exclude that location when running the planning worksheet. The thing I'm not sure if whether changing the location of a SO after approval would retrigger the approval process. 
  • Valentin Castravet Profile Picture
    Valentin Castravet 26,349 Super User 2025 Season 1 on at
    Open and pending sales orders in MRP run
    Ben is correct, the demand planning engine doesn't account for the status of a sales order. The easiest solution would be as mentioned to use sales quote or blanket orders. 
     
  • Ben Baxter Profile Picture
    Ben Baxter 5,275 Super User 2025 Season 1 on at
    Open and pending sales orders in MRP run
    Unfortunately, there is no out-of-the-box setting for this.  You either use Sales Quotes and convert to a Sales Order when ready to trigger demand.  Or you write an extension to exclude non-Released Sales Orders from the calculation.
     
    I do wish this was a setting and Microsoft has an ideas site where you can post suggestions like this.
     
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans