Skip to main content
joneill86
Dec 11, 2018 4:06 PM UTC
Solved

Change amount of decimal places

Hi all! 

 

I am looking to change the number of decimals for our quantities in BOMs and costs. We create a bill of material that have multiple parts. We can only enter qty with 2 decimals, sometimes we need to go out to (and see) 4. The BOM cost only goes out 2 decimal places, but with a lot of our parts also need to go out to (and see) 4. Any help would be greatly appreciated.

 

Thanks! 

 

PS I think this may be a double post. Sorry :(

    Rustler
    RustlerAnswer
    Dec 11, 2018 4:33 PM UTC

    you can not change the number of decimals in the qty block of a BOM

    and keep in mind that if you do use decimals they must add up to one, QB does not do partial qty very well, 0.25, 0.125 works fine. 0.33 does not.

     

    the cost you see in the BOM is a reference only, it comes from the cost block on the item screen, it is NOT used to determine assembly item cost when you build it.  Assembly item cost comes from the average cost of the items listed in the BOM, those average costs are added together to get the build cost, at the time of the build

    View in thread

    14 replies

    Rustler
    RustlerAnswer
    Dec 11, 2018 4:33 PM UTC

    you can not change the number of decimals in the qty block of a BOM

    and keep in mind that if you do use decimals they must add up to one, QB does not do partial qty very well, 0.25, 0.125 works fine. 0.33 does not.

     

    the cost you see in the BOM is a reference only, it comes from the cost block on the item screen, it is NOT used to determine assembly item cost when you build it.  Assembly item cost comes from the average cost of the items listed in the BOM, those average costs are added together to get the build cost, at the time of the build

      MBOpsGuyatBAW
      MBOpsGuyatBAW
      May 18, 2021 8:13 PM UTC

      So how do people handle inventory items that are purchased, consumed or sold in less than whole units? Two decimal places just don't cut it. Do any of the add-ons extend this to 4 decimal places? (or don't we talk about those)

       

      TrixieD
      May 6, 2025 2:23 PM UTC

      Hi There

       

      I need to remove the decimal point completely from the QTY block in a Quotation.

      How do I do that? I want hole units as 1 and 300 and 299 wihout the desimal place.

       

      Hope you can help.


      Removing decimal point places will depend on the product you purchased in QuickBooks (QBO), Visual. I'll explain more detailed information about this.

      You can enter the specific quantity you want directly into the software. But when it comes to amounts, decimal places are set by default. As you enter the quantity, the corresponding amount will automatically be calculated and displayed with these decimals.

       

      In QuickBooks Online, there's no option to turn it off. However, in QuickBooks Desktop (QBDT), here's how:

       

      1. Go to the Edit menu in your QuickBooks Desktop (QBDT) software.
      2. Click Preferences and then My Preferences tab.
      3. Untick the box Automatically place decimal point.
      4. Then click OK.



       

      If you encounter an error in editing the quantity, you can perform some basic troubleshooting steps to see if it's a browser-related issue. Let's start by opening your account in an incognito or private window and completing the activity again.

       

      Here are the keyboard shortcuts:

       

      • Google Chrome: Ctrl + Shift + N
      • Microsoft Edge: Ctrl + Shift + N
      • Safari: Command + Shift + N
      • Mozilla Firefox: Ctrl + Shift + P

       

       If the tab functions correctly in incognito mode, you can return to your regular browser and clear its cache. It helps resolve issues like page loading errors or formatting problems. After clearing the cache, please restart your browser to apply the changes. Alternatively, please consider using a different supported browser.

       

      Additionally, the software offers options to tailor your invoices, estimates, and sales receipts to meet your business needs.

       

      Moreover, you can use this article to learn how to split an estimate into multiple invoices and have the option to bill your customers for partial payments: Set up and send progress invoices.

       

      If you have more questions about adding quantities, revisit this thread any time. We're always here to provide you with the support you need.

      Terms & ConditionsAccessibility statement