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

Notifications

Announcements

No record found.

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,245 Super User 2025 Season 2 on at

    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
    31,481 Super User 2025 Season 2 on at
    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
    20,603 Super User 2025 Season 2 on at
  • MB-10021509-0 Profile Picture
    42 on at
    @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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans