cancel
Showing results for 
Search instead for 
Did you mean: 
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

12 Comments 12
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.

Need to get in touch?

Contact us