Skip to main content

Notifications

Community site session details

Community site session details

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

Round to nearest 1 on planning Worksheet

(0) ShareShare
ReportReport
Posted on by 244

I have items used in production and the rounding precision on the items is set to 0.00001 since the client works with decimals. When I create a plan in the planning worksheet, it shows the qty needed as for example 10.567787. I am trying to get it to show as 11 in this case. Can anyone advise what setup I need to do to ensure full qty values and not decimals?

  • Suggested answer
    Valentin Castravet Profile Picture
    28,272 Super User 2025 Season 1 on at
    RE: Round to nearest 1 on planning Worksheet

    On the Item/SKU card in the Planning FastTab have you tried changing the Order Modifiers field? For example, if you change this field to 1 the planning engine should suggest orders rounded to 1. You should be able to do this as long as the Reordering Policy is not Order. If its Order you can change it to Lot-for-Lot.

  • Suggested answer
    AbhinavMehra Profile Picture
    364 on at
    RE: Round to nearest 1 on planning Worksheet

    Hi DebbieG,

    Unfortunately Business central has only rounding precision which should be setup initially once and you should not change it in middle of process. There is no other way you can do planning without decimal quantity.

    You may figure out to do it through code but that is not recommendable.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

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

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Featured topics

Product updates

Dynamics 365 release plans