web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 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 
I have the same question (0)
  • Jun Wang Profile Picture
    8,154 Super User 2025 Season 2 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
    28,578 Super User 2025 Season 2 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
    6,238 Super User 2025 Season 2 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

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sumit Singh Profile Picture

Sumit Singh 3,048

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,271 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans