web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... MRP Planning Worksheet...

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

Answered

MRP Planning Worksheet - Max Quantity of production order

(0) Share

Report

Report

Posted on by Marco2022

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Ben Baxter 6,918 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Marco2022 20 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,926 Super User 2026 Season 1

#2

YUN ZHU 1,158 Super User 2026 Season 1

#3

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans