web
You’re offline. This is a read only version of the page.
close
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... / Planning worksheet is ...
Small and medium business | Business Central, N...
Suggested Answer

Planning worksheet is not respecting multiple quantities for transfer orders

(3) ShareShare
ReportReport
Posted on by MarisolC 103
We are using Planning worksheet and is working almost fine, except by quantities at transfer orders that doesn't respect minimum and multiple settings:
 
Here is my Manufacturing setup
 
Item Card, as we are using stockkeeping units I have nothing here (is that Ok)
 
Stockkeeping units, I have 6,000 kg at TUL03 already:
 
Stockkeeping unit for purchasing (with no issues)
 
Stockkeeping unit for transfer (with issues):
 
Planning worksheet:
 
 
 
Transfer quantity calculated, it must be 14,000 as minimum is 1,000 and also multiple too.
 
 
 I have several sales orders to ship, in yellow 6,000 kg that I already have at TUL03 location, in blue, the next sale order that must be shipped on 8/7 is the one with 13,500 kg that planning wotksheet is calculating but is not respecting minimum and multiple settings.
 
Is there something Im missing? Something else to set up or take care of? My partner has like 2W trying to figure out how to fix this.. or maybe is there any bug around this?
 
TIA,
 
Marisol
 
Sorry for this long post, but I wanted to put as much info as possible. 
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,136 Super User 2025 Season 2 on at

    Hi Marisol,

     

    Thanks for providing such a detailed explanation of the issue—it really helps narrow things down.

     

    In Business Central, when using Stockkeeping Units (SKUs), the planning parameters like Reorder Point, Minimum Order Quantity, and Order Multiple must be configured on the SKU level—not on the Item Card. From your message, it sounds like this has been done correctly. However, there are a few real-world behaviors and limitations in the Planning Worksheet you should be aware of.

     

    First, the Planning Worksheet can sometimes ignore Minimum and Multiple Order settings for Transfer Orders, especially when the demand is not large enough to trigger them or when dates fall outside the planning horizon or within dampener periods. Another factor could be how demand is being grouped—BC might be only looking at the immediate requirement rather than the full set of upcoming orders, depending on how it's calculated.

     

    One common scenario is when the system sees an order for 13,500 and plans just that quantity, not rounding up to the next multiple (like 14,000). It may also try to reduce existing supply based on the overflow level. This behavior can often be influenced by the Reorder Quantity setting (which will be honored more consistently) rather than Minimum Order Quantity, particularly in transfer scenarios.

     

    To avoid repeated or conflicting suggestions, it's also important that when you override a proposed quantity manually or change due dates, you mark the resulting supply line with Planning Flexibility = None. Otherwise, BC will keep trying to adjust or cancel it based on new demand each time the worksheet is run.

     

    Finally, this doesn’t appear to be a bug as per current Microsoft documentation, but it can certainly feel like inconsistent behavior in real-world use. You might want to consider creating a simple customization or extension that adjusts suggested transfer quantities according to your business rules if this remains a blocker.

     

    You can refer to the official Microsoft Learn documentation on this topic here:

    https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-planning-parameters

     

    If you’ve already tried all of the above and still see this behavior, it might be worth raising it with Microsoft Support through your partner just to confirm if this is intended in your current version.

    Mark below checkbox to make this answer Verified if it helps you.

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 6,575 Super User 2025 Season 2 on at
    This could be a data validation issue.  Have you tried deleting and recreating your SKU record for that Item/Location?  Alternatively, you could go through each of the key fields and re-enter the information, such as Reordering Policy (change, leave field, change back) and Order Modifier (delete, leave field, re-enter).
     
    From what you're describing and what the data looks like it should be working.  I do notice you don't have "Dynamic Low-Level Code" turned on.  I would suggest turning that on and also running the "Calculate Low-Level Code" function.  This is mainly for BOM levels, but it may impact your chain of demand for the transfer as well.
     
    P.S. The Item Card can be ignored since you have a SKU record established.
     
    Hopefully you find the issue and update us to let us know what you found.
     
    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…

Neeraj Kumar – Community Spotlight

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

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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