web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Open and pending sales orders in MRP run

(1) ShareShare
ReportReport
Posted on by 48
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 
I have the same question (0)
  • Ben Baxter Profile Picture
    6,575 Super User 2025 Season 2 on at
    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
  • Valentin Castravet Profile Picture
    31,340 Super User 2025 Season 2 on at
    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. 
     
  • Jun Wang Profile Picture
    8,200 Super User 2025 Season 2 on at
    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. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans