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... / I want to update the q...
Small and medium business | Business Central, N...
Suggested Answer

I want to update the qty in decimal in sales order

(6) ShareShare
ReportReport
Posted on by SL-15041028-0 250
Hi,
 
Im getting below error while updating the qty in decimals.
 
Error Text Field Caption Table ID Record ID The value 0.5 in field Quantity is of lower precision than expected. Note: Default rounding precision of 0.00001 is used if a rounding precision is not defined. Pieces 37 Sales Line: Order,SO510272,10000
 
 
Please provide me a solution so i can fix it.
 
thanks,
Categories:
Microsoft Dynamics NAV
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Teagen Boll Profile Picture
    Teagen Boll 1,409 Super User 2026 Season 1 on at
    You will want to change the Rounding Precision field for that item. If you go to your Items page and open the item that is on that SO then you can look at the Units of Measure for that item.:
    You need to change the "Quantity Rounding Precision" field to either 0 or the appropriate amount of decimal places (0.1, 0.01, 0.001 etc.).
     
    Note you may have to delete that line on the Sales Order first and then change the Quantity Rounding Precision.
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 5,420 Super User 2026 Season 1 on at
     
    Can you please Qty per unit of measure in Item card 
     
     
    Delete the lines from sales order , set rounding precision and add the item in sales order 
     
    Warm Regards
    Pallavi Phade
  • Suggested answer
    Sumit Singh Profile Picture
    Sumit Singh 11,757 Super User 2026 Season 1 on at
    Hi, 
     
    As per my knowledge, please check the unit of measure of that particular item and mention the rounding precision as 0.01 so that you can try to enter 0.5 in the quantity field. Similar to what was mentioned by Teagen. 
     
    Please test this in sandbox environment first. 
     
     
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 12,808 Super User 2026 Season 1 on at
    Hello,
     
    Your item’s Unit of Measure doesn’t allow decimals, so BC blocks 0.5.
    Fix it by updating the Qty. Rounding Precision on the Item’s Unit of Measure (or the UoM itself) to something like 0.00001.
     
    After that, decimal quantities will work.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,055 Super User 2026 Season 1 on at
    Hi, hope the following can give you some hints.
    Business Central 2021 wave 2 (BC19) new features: Rounding for base unit of measure (Quantity Rounding Precision)
     
    Thanks.
    ZHU

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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,926 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,158 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans