web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Unit of Measure Conver...
Small and medium business | Business Central, N...
Answered

Unit of Measure Conversion Precision Issue in Business Central

(7) ShareShare
ReportReport
Posted on by EM-04090939-0 26

Hello everyone,

 

I'm facing an issue in Business Central related to unit of measure conversion precision.

 

I have an item (a metal sheet) that is purchased in kilograms (KG), but its base unit of measure is pieces (PZ). To produce 1 PZ of this item, 480 KG of material are required.

 

In the "Item Units of Measure" table, I defined the conversion as:

1 PZ = 480 KG, which implies that 1 KG = 1 / 480 = 0.00208.

However, Business Central rounds this value to 5 decimal places, so the system stores 0.00208.

 

The problem is that when I multiply:

480 × 0.00208 = 0.9984,

which is not equal to 1, and this causes discrepancies in inventory and costing.

 

Unfortunately, the customer does not want to reverse the units of measure (i.e., set KG as the base and PZ as the alternate), which would solve the issue more easily.

 

Has anyone encountered this limitation before? Is there a standard workaround to increase the precision or handle this conversion more accurately without changing the base unit?

 

Thanks in advance for your help!

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Alex A Profile Picture
    Alex A 3,127 Super User 2026 Season 1 on at
    Hello,
     
    If 1 PZ = 480 KG, then your smallest Unit of Measure is KG.
     
    In Business Central, the recommended practice is to use the smallest Unit of Measure as the Base Unit of Measure. Otherwise you get these kinds of decimal issues.
     
    Try creating a Test environment where you can configure the Item Units of Measure so that KG is the Base Unit of Measure. This will coincide with your Purchase Unit of Measure. And if you need to you can set PZ as the Sales Unit of Measure. And test all your transactions this way.
     
     
    If you cannot see doing it the recommended way based on your business practices then find the "Rounding Precision" field on the Item card. It's located on the Inventory FastTab and defines the decimal precision for quantities in the item's base unit of measure (e.g., 0.01 for two decimal places). You can push this out more decimal places and test.
     
    Set the Rounding Precision to have more decimal places. Is it already at 5 decimal places?
     
    1 (0 decimal places)
    0.1 (1 decimal place)
    0.01 (2 decimal places)
    0.001 (3 decimal places)
    0.0001 (4 decimal places)
    0.00001 (5 decimal places) MAX
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 32,666 Super User 2026 Season 1 on at
    You can use the Quantity Rounding Precision field to accommodate this scenario. 
     
     
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 100,214 Super User 2026 Season 1 on at
    Hi, hope the following helps as well.
    Business Central 2021 wave 2 (BC19): Rounding for base unit of measure (Quantity Rounding Precision)
     
    Thanks.
    ZHU
  • Suggested answer
    Nimsara Jayathilaka. Profile Picture
    Nimsara Jayathilaka. 5,003 Super User 2026 Season 1 on at
    Hi
     
    This issue occurs because Business Central limits unit of measure conversion to 5 decimal places, which causes rounding discrepancies when converting between large and small quantities (like 1 PZ = 480 KG).
    In standard BC, there’s no built-in way to increase the UoM precision beyond 5 decimals.
     
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 5,510 Super User 2026 Season 1 on at
     
    You need to set Quantitiy Rounding Precision . This will help you to get the results .
     
     
    Example Explained 
    Specifies how to round quantities when converting the base unit of measure, such as from Box to Each, on an order. For example, Each is the base unit of measure but you also sell the item in a Box of 6. If you only have five of the items available and you must sell in boxes, enter 1 to ensure that after conversion you will get 5 each and not 4.99998.
     
     
    IF this helped , Please mark as "Verified"
     
    Regards
    Pallavi Phade
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    Rishabh Kanaskar 6,225 Super User 2026 Season 1 on at
    Hi,
     
    Business Central limits unit of measure conversion to 5 decimal places, so 1 ÷ 480 becomes 0.00208, causing rounding differences. There’s no standard setting to increase precision beyond 5 decimals.
     
    Thanks
    Rishabh

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,948 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 936 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 616 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans