Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
joneill1186
Level 4

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

Solved
Best answer December 11, 2018

Best Answers
Rustler
Level 15

Change amount of decimal places

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 solution in original post

14 Comments 14
Rustler
Level 15

Change amount of decimal places

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
Level 3

Change amount of decimal places

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
QuickBooks Team

Change amount of decimal places

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. 2.PNG

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

MBOpsGuyatBAW
Level 3

Change amount of decimal places

So I'm guessing this is not an option in the Online advanced verison.

Catherine_B
QuickBooks Team

Change amount of decimal places

Hi there, MBOpsGuyatBAW.

 

In the online version of QuickBooks, you have the option to enter more than two decimal points in the quantity and rate field. The total amount will rounded off only until 2 decimals. 

 

To help you manage your transactions, you can use these articles: 

 

Let me know if you have other questions in handling your transactions. Take care!

MBOpsGuyatBAW
Level 3

Change amount of decimal places

Thanks for the links, I'm going through them now. 

 

Question:

Are the quantities stored in two decimal places in the back end db?

What happens to the dollars that are rounded up or down?

 

Marc

 

AlexV
QuickBooks Team

Change amount of decimal places

Hello MBOpsGuyatBAW!

 

Allow me to step in and share some details about decimal points and rounded amounts.

 

Yes, the transaction will be saved in two decimal places. When you create a transaction less than the whole unit, the system will automatically deduct it from the total quantity on hand. 

 

When it comes to rounding amounts, the calculation, like income, etc., will be based on the final rate. QuickBooks automatically converts the amounts to the nearest hundredths (two decimal places).

 

Please visit our Help page if you need more references in managing your business with QuickBooks Online. Click this link: QBO Articles.

 

Leave a comment again here if you need anything else. Take care!

makingsigns
Level 3

Change amount of decimal places

Can you please tell me how to do this on QBOnline?

makingsigns
Level 3

Change amount of decimal places

I need to change the rate to 3 decimal places in QBO, can you please tell me how?  Thanks!

 

SarahannC
Moderator

Change amount of decimal places

Hello there, makingsigns.

Looks like you've posted twice in this forum. My colleague already shared the information about your concern about changing the rate to the third decimal point. Please view the complete details in this article: https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/re-how-do-i-turn-off-roundin....

 

The Community is always here to assist you 24/7. With that, you can go back here and post additional concerns, and we'll help you figure them out anytime. Take care and stay safe.

Tonya T
Level 1

Change amount of decimal places

So far I am not seeing how to use 3 decimal places in the rate category of an invoice. QB Online automatically rounds the number two digits, which makes the calculations off. I need this for calculating commissions, so rounding does not work. I need 3 digits and/or the rounding turned off but neither is available in QB Online. If you find an answer, I'd love to know how! Please share! 

CharleneMaeF
QuickBooks Team

Change amount of decimal places

I recognize that rounding the invoice rate to three decimals places would be a great functionality, Tonya T. I'm here to share some insights.

 

Since the option is unavailable, I'd recommend sending a feature request directly to our Product Development team. This helps us improve your experience and the feature of the program. 

 

Here's how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.

 

Also, you can track feature requests through the Customer Feedback for QuickBooks Online website.

 

Additionally, I've included these articles that'll help you in managing your sales transactions. This way, you're able to keep your book accurate:

 

 

I'm only a post away if you need more help in completing your other tasks in QuickBooks, Tonya T. It's always my pleasure to help you out again.

Visual Projects
Level 1

Change amount of decimal places

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.

TrixieD
QuickBooks Team

Change amount of decimal places

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us