Planning Worksheet Quantity

(1) Share

Report

Posted on by Felicity

Hello

Could someone please advise if it is possible for the quantity on the planning worksheet to round the required quantity by an order multiple.

For example, I have a production order requirement for 2.5 but I have an order multiple for that item as 5. I would want to see a quantity of 5 appear on the planning worksheet.

Thanks in advance.

Flick

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Ben Baxter 7,077 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Yes, as long as the line is being entered using the "Calc. Regenerative Plan" function. There are only three settings needed to perform this calculation.

1) On the Item/SKU Card > Planning tab, set the "Reordering Policy to either "Maximum Qty." or "Lot-for-Lot" (most common).

2) On the Item/SKU Card > Planning tab, ensure the Item you are going to produce has an "Order Multiple" defined.

3) When running your plan in the Planning Worksheet, ensure the "Respect Planning Parameters..." is turned on.

If you do not get a Quantity divisible by 5, then you need to check your demand date, as it is likely prior to your planning start date which can cause issues. The other thing people often forget is updating the SKU for the Location you are planning for.

Give this a shot and see if you get the outcome you're looking for. If this helped resolve your issue, please mark it as a Verified Answer to help other forum Users.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Ben provided a very good answer. The order multiple field is the key to this.

Was this reply helpful? Yes No
Verified answer

Felicity 48 on at

Like (2)

Report
Copy link

Link copied!

Hello

For completeness. Further testing and investigation is that order multiple is only functional when the Manufacturing Policy is set to Make-to-Stock. I had this set to Make-to-Order.

Was this reply helpful? Yes No