Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

MRP Planning Worksheet - Max Quantity of production order

(0) ShareShare
ReportReport
Posted on by 20

Dear experts

I have a requirement in MS Dynamics BC 365 that each production order has maximum quantity e.g. 5

If there is sales order demand 12 quantity, need to split to 3 production orders with Qty 5, 5, 2

I would ask if there is any way to generate the these 3 production orders automatically by mrp planning worksheet.

I have setup order modifier max order qty in item master but not work. only 1 production order with 12 quantity generated in planning worksheet.

Appreciate if any expert can give hints if this is possible in MS Dynamics BC 365

Many thanks

Best regards,

Marco

  • Marco2022 Profile Picture
    Marco2022 20 on at
    RE: MRP Planning Worksheet - Max Quantity of production order

    Thanks for you hints, Ben

    I have tested that if I don't setup stockeepting unit, only input max order qty of iterm master, it's not work in planning worksheet. and if I setup stockkeeping unit, the production order is splitted by max order qty.

    It seems stockkeeping unit master is a must for using order multiple if I have multiple location.

    Best regards,

    Marco

  • Verified answer
    Ben Baxter Profile Picture
    Ben Baxter 4,959 Super User 2024 Season 2 on at
    RE: MRP Planning Worksheet - Max Quantity of production order

    Absolutely, as long as you are using a Reordering Policy other than Order, on the Planning tab of the Item/SKU is a section for Order Modifiers.  Set the Maximum Order Quantity to 5.  The system will then limit its suggestions to a max of 5 per row (i.e. Production Order in this case).  Be sure to check your Stockkeeping Unit for whatever Location you are expecting the suggestions.

    If your policy was set to Order, I would suggest using Lot-for-Lot instead.  Similar in nature but with more flexibility.

    One other thing, be sure the "Respect Planning Parameters" field is checked when running the plan in the Planning Worksheet.  If the order was in the past it would be treated as an emergency order and might not honor the parameters you have set.

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans