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...
Suggested answer

Business Central: Make-to-Order not respecting order modifiers

(4) ShareShare
ReportReport
Posted on by 28
Short question:  Is there a way to keep a manufacturing policy of "make-to-order", a reordering policy of "lot-for-lot", and still have BC respect the Order Modifiers?  For example, consider the following:
 
1) Quantity on hand is 10.
2) Quantity on sales order is 100.
3) Safety stock is 200.
4) Order minimum is 150.
 
To meet this demand, I need produce 290.  If the system respected the order multiple, MRP would recommend two production orders for 150 each (total 300), or depending on accumulation period, 1 production order for 300.
 
But instead, what the planning engine says to is to create two production orders:  1 for 150, and 1 for 140.  Each production run cannot be less than 150 and manually updating quantities in the planning worksheet is untenable.
 
Changing the policy to "make-to-stock" would respect the order modifiers, but when a production is created from the planning worksheet, we need all the sub-assemblies that get consumed to the parent item to be nested as additional component lines on the production order.  That does not work with "make-to-stock".  If it did, changing to "make-to-stock" would solve our problem.  
 
Am I missing something?  Two additional variables:  SKU's are required and Lot-For-Lot is required.
  • BS-15042132-0 Profile Picture
    28 on at
    Business Central: Make-to-Order not respecting order modifiers
    Ben, you think it used to work the way we want it to work, but it no longer works that way?
  • Ben Baxter Profile Picture
    5,651 Super User 2025 Season 1 on at
    Business Central: Make-to-Order not respecting order modifiers
    Wow, I stand corrected, and I have updated my response based on the latest testing.  I don't agree with the change, but I guess we have to live with it at this point.
     
    Ben
  • BS-15042132-0 Profile Picture
    28 on at
    Business Central: Make-to-Order not respecting order modifiers
    Ben, always appreciate your jumping in on these forums.  And thanks to everyone else who responded as well. 
     
    Your response insinuates that MRP should respect those order modifiers, even with "make-to-order".  I am not seeing that.  There are no customizations and respect planning toggle is on.  Am I misreading your response? 
     
    I agree that the planning engine appears to respect the order modifiers for safety stock, but not the sales order demand.
     
    Using my same example above, let's say that I instead switch the order minimum to an order multiple and have different sales order lines with different ship dates.
     
    1) Quantity on hand is 10.
    2) Quantity on sales order line 1 is 100, ship date 4/30.  Quantity on line 2 is 75, ship date 5/30.
    3) Safety stock is 200.
    4) Order Multiple is 150.
     
    My demand is now 365.  For the sales order demand, the planning engine will not respect the order multiple.
     
    What I am expecting to see here is:
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    14,928 Super User 2025 Season 1 on at
    Business Central: Make-to-Order not respecting order modifiers
    I agree with Ben — the system doesn’t respect order modifiers like Minimum or Multiple when using Make-to-Order with Lot-for-Lot. It’s designed to match demand exactly, so even if modifiers are set, they’re ignored unless you switch to Make-to-Stock. Unfortunately, that breaks subassembly nesting on the parent production order, which is a dealbreaker for us too. Would love to see this handled better natively without customizations.
     
     
  • Suggested answer
    Ben Baxter Profile Picture
    5,651 Super User 2025 Season 1 on at
    Business Central: Make-to-Order not respecting order modifiers
    No information below is provided from AI, it is from implementing Manufacturing for the last 15+ years.
     
    It appears the MRP calculation has been updated to consider the Manufacturing Policy as an extension to the Reordering Policy.  I ran some tests and "Make-to-Order" did impact the planning results as if it was an "Order" Reordering Policy, regardless of the "Lot-for-Lot" setting.
     
    Normally, when running your plan, there is a toggle for "Respect Planning Parameters...", which needs to be turned on.  Since you are 190 units below "0" (200 in your case), the system is creating an exception to replenish your Safety Stock first.
     
    Since you didn't mention an Order Multiple or Max. Order Quantity, but gave results as if you have values set, I figured it would be helpful to add some information there as well.
     
    Order Multiple is what the suggestion has to be divisible by.  For example, yours could be set to 10, since both 150 and 140 are divisible by 10.  If you set the Order Multiple to 150, you would have suggestions of 150 or 300.
     
    The Max. Order Quantity is used to split the suggestion into batch sizes.  In your example of 290, assuming you don't want to run all at the same time, you could set a Max. Order Quantity of 150.  In which case it will limit each Production Order to 150 BUT allows for producing an amount lower than 150 (except for your Min. Order setting).
     
    Finally, if your Order Multiple is equal to or greater than your Min. Order Quantity, there is no need for a Min. Order Quantity.  At that point you may want to use a Max. Order Quantity to limit how many you produce in a single Production Order.
     
    Hopefully this information is helpful.  If so, please mark it as a Verified Answer to help other forum users.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    Jainam M. Kothari Profile Picture
    6,567 on at
  • Martin Dráb Profile Picture
    233,017 Most Valuable Professional on at
    Business Central: Make-to-Order not respecting order modifiers
    Moved from Supply chain | Supply Chain Management, Commerce forum to Small and medium business | Business Central, NAV, RMS forum.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans