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 :
Small and medium business | Business Central, N...
Suggested answer

item unit of measure rounding precision problem

(0) ShareShare
ReportReport
Posted on by 42
Hi all,
 
i've created an item with COIL as base unit of measure. I've choose this unit because i want to see my inventory (and costing infos) in coils.
My vendor sell this item in meters, so i've set the purchase unit of measure in MT (meters). In the item unit of measure i've set 1 COIL = 30 MT, to do that i've set the "qty per" to 1/30 (0,03333). In this way when i insert a purchase line with 30 meters of my item i get 0,99999 coil.
 
I've tried to use the rounding precision in the item unit of measure page, but i cannot figure out how to handle this situations. Is there a way to achieve this by standard?
 
Thanks for the help.
I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    50,233 Super User 2025 Season 2 on at
    item unit of measure rounding precision problem

    The base unit of measure on the Item Card should be the smallest unit of measurement, as this helps avoid dealing with fractional quantities, it sems like you have other way around which will cause the rounding issues, you can have different sales and purchase unit of measure but the base should be smallest.

  • Suggested answer
    Valentin Castravet Profile Picture
    29,543 Super User 2025 Season 2 on at
    item unit of measure rounding precision problem
    Agree with the previous response, best practice is to setup the smallest unit of measure as the base unit of measure. 
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    19,137 Super User 2025 Season 2 on at
  • MB-10021509-0 Profile Picture
    42 on at
    item unit of measure rounding precision problem
    @Khushbu Rajvi. Thanks for the answer but it don't seems thatthe rounding precision can fix my problem...

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

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…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,237

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,425

#3
Sumit Singh Profile Picture

Sumit Singh 2,907

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans