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

10 Comments 10
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

MBOpsGuyatBAW
Level 1

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 1

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 1

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 2

Change amount of decimal places

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

makingsigns
Level 2

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.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us