web
You’re offline. This is a read only version of the page.
close
Skip to main content
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...
Unanswered

Unit of Measure Conversion Precision Issue in Business Central

(1) ShareShare
ReportReport
Posted on by EM-04090939-0

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 2,614 on at
    Unit of Measure Conversion Precision Issue in Business Central
    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
     
     

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 4,220

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,958

#3
Sumit Singh Profile Picture

Sumit Singh 2,961

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans