Skip to main content
J
joneill86
December 11, 2018
Solved

Change amount of decimal places

  • December 11, 2018
  • 1 reply
  • 0 views

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 :(

    Best answer by Rustler

    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

    1 reply

    Rustler
    RustlerAnswer
    December 11, 2018

    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

      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)

       

      JasroV
      JasroV
      May 18, 2021

      I appreciate you for joining this thread, @MBOpsGuyatBAW.

       

      QuickBooks lets you record your item qty by 4 decimal places. To to do so, you'll need to activate it in your company Preferences. Let me show you how.

       

      1. Go to the Edit menu in your QuickBooks Desktop (QBDT) software.
      2. Select Preferences.
      3. From the My Preferences tab, check the box to Automatically Place Decimal Point.
      4. Then click OK.

       

      Once done, you can now enter 4 decimal in your item qty. 

      However, you'll want to round off the qty for QuickBooks to accurately track it. 

       

      Additionally, I recommend working with your accountant or visit our ProAdvisor page and look for one from there. This way, we can prevent messing up your records.

       

      You might also want to check this link to learn more about theAccounts Payable A/P workflow. 

       

      You can always tag me in your reply if you have other concerns or questions managing your inventory. I'll be around to help you

      Terms & ConditionsAccessibility statement