Skip to main content

Notifications

Community site session details

Community site session details

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

Lot for Lot Order Modifiers

(0) ShareShare
ReportReport
Posted on by 30

Hi all,

I have created a Sales Order, and ran the planning worksheet, however it does not seem to take my order modifiers indicated at my item card into consideration.

My SO details are as follow:

Posting & Order Date 14/5/2021

Planned Delivery & Shipment Date 30/6/2021

My item card order modifier details are as follow:

pastedimage1621453492864v1.png

However, when generating my planning worksheet, it still only tells me to purchase the required quantity of 1.5 rather than the minimum quantity of 3.

pastedimage1621453599819v3.png

I have double checked the purchased UOM is the same as the base UOM. 

I hope you'll be able to help, thank you!

  • Johan Johansson Profile Picture
    on at
    RE: Lot for Lot Order Modifiers

    Hi!

    I got the same thing and realised that the Manufacturing Setup: Component at Location must be filled in which seems logical as all the demand now isn't order tracked.

    Maybe that is the problem for you as well?

  • zj95 Profile Picture
    90 on at
    RE: Lot for Lot Order Modifiers

    Hi Marco,

    Thank you for the great advice :)! 

  • Suggested answer
    Marco Mels Profile Picture
    on at
    RE: Lot for Lot Order Modifiers

    Hello,

    If there are still issues that were not solved via excellents suggestions from the community, feel free to raise it to Microsoft support.

    Thanks.

  • LXT Profile Picture
    30 on at
    RE: Lot for Lot Order Modifiers

    Hi all,

    So the Order Multiple works, however the Minimum Order Quantity still does not :(.

    Required quantity is 0.77.

    5722.Untitled.png

    When I generate my planning worksheet, it's still showing order quantity of 1 rather than the minimum order quantity of 2. 

  • Xiao Tian Profile Picture
    10 on at
    RE: Lot for Lot Order Modifiers

    Hi Ben,

    Yes I have Order Tracking Policy set as I was told by my consultant that they faced issues when this was set to No, and thus to prevent this issue I was told to set all as Order Tracking Policy.

    Sorry you could clarify the purpose of the Lot Accum. Period and Rescheduling Period and their impact?

    Yes, I am using locations and bins, I have them all set up with the SKU for the demand location. 

  • Suggested answer
    Ben Baxter Profile Picture
    5,756 Super User 2025 Season 1 on at
    RE: Lot for Lot Order Modifiers

    I see you have "Order Tracking Policy" set.  Try changing that to None.  Unless you are using "Get Action Messages" you do not want the Order Tracking Policy set.  The system will still give you visibility into the Order Tracking causing the suggestion.

    I also see you do not have a Lot Accum. Period or Rescheduling Period set.  The default value is 1D, but you'll probably want to dial those in once you get the suggestion to match your modifiers.

    Final thought: Are you using Locations?  Does this Item have a SKU for the Location the demand is for?  If you use Locations (which you should, even if you just have 1), then you should also use SKU cards when there are multiple Locations.

  • LXT Profile Picture
    30 on at
    RE: Lot for Lot Order Modifiers

    Yes, my Base UOM and Purchase UOM is the same, both in KG. My Order Multiple was set to 1, I have deleted it and it reset itself to 0. My settings are as follows:

    5707.SS.png

    I have also extended the planning worksheet ending date to the 31/7/2021. 

    S2.png

    However the purchase quantity is still 1.5kg rather than 3kg. 

  • Ben Baxter Profile Picture
    5,756 Super User 2025 Season 1 on at
    RE: Lot for Lot Order Modifiers

    Are your Units of Measure the same on your Base UOM and Purchase UOM?  Also, if your Order Multiple is 1, just leave the field blank.  If you want the system to order in multiples of 3, set your Order Multiple to 3.

    Does this Item have a safety stock value set?  Lastly, push your End Date beyond 30/6/2021 to 1/7/2021 see if the suggestion changes.

  • LXT Profile Picture
    30 on at
    RE: Lot for Lot Order Modifiers

    Hi there,

    Yes, my starting date and ending date set is from the 1/5/2021 .. 30/6/2021. My respect planning parameters for... is also turned on.

  • Suggested answer
    MahGah Profile Picture
    15,443 on at
    RE: Lot for Lot Order Modifiers

    Hi

    When you Calculate Planning worksheet do you have Respect Planning Parameters on? 

    Also, does your Start and end date covers 14/5/2021 .. 30/6/2021? 

    Thanks 

    pastedimage1621546369759v1.png

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,063

#2
YUN ZHU Profile Picture

YUN ZHU 1,002 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 810

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans