Decimal Calculation ERROR

I appreciate the detailed information you've provided about your experience with the decimal calculation, @HelloRose.

Firstly, I'd like to ask what transaction you are trying to pull up. Any additional information would be greatly appreciated.

Let's open a sample company file in your account when making the transaction. This way, you can determine if there are any errors with the decimal calculation.

However, if there are no errors with the decimal calculations, we can verify and rebuild your data. This process resolves errors and other issues in the software.

Furthermore, here's an article you can browse just in case you need a guide on backing up your accounting data in QuickBooks Desktop: Back up your QuickBooks Desktop company file.

You can always count on me if you need a hand managing your calculations in QuickBooks Desktop. I'd be happy to assist you at any given time.

I just tired it, it doesn't fix the calculation error. 

We can troubleshoot your data to resolve issues with your rate decimal calculation, HelloRose. I'm here to provide a detailed process to help keep your amounts accurate.

Damaged data can cause issues when utilizing QuickBooks Desktop (QBDT), including the error you received with the decimal calculation. To get this resolved, ensure to update QBDT to the latest release.

After that, let's run the Verify and Rebuild tool. Verifying your data allows us to identify discrepancies within your company file that need further troubleshooting.

Here's how to verify your company file:

1. Proceed to the Window tab, then select Close All.
2. Click on File and select Utilities.
3. Choose Verify Data, then OK.

Then, follow these steps to rebuild your company data:

1. Head to the File menu, then Utilities.
2. Select OK once asked to create a backup of your company file.
3. Choose where you want to save your backup and click OK.
4. Once you get the message Rebuild has completed, select OK.

You may also refer to this article for the detailed process: Verify and Rebuild Data in QuickBooks Desktop.

If the issue persists, I recommend contacting our customer support team. With their tools and expertise, they can dig deeper into this issue and provide the most relevant resolution or workaround to get you back to business.

On the other hand, you might want to scan these materials to help keep track of your customer and vendor transactions:

• Get started with customer transaction workflows in QuickBooks Desktop
• Accounts Payable workflows in QuickBooks Desktop

I'll get back to you immediately if you require additional assistance fixing the calculation error of your rates in QuickBooks Desktop. I can always provide the help you need in any way.

I've not seen it before.

What type of transaction are you seeing this on?  What type of item are you using where it happens?

This is when I'm doing sales order and invoices. When I do sales order, I type in customer name, so QB auto populate the discount rate. Then the discount rate is multiple by the item pricing. The discount multiply by the item pricing is NOT coming our correctly. There shouldn't even be a rounding issue.

I did a rebuild just now and updated the QB just now. Still WRONG and still doesn't work.

RE: When I do sales order, I type in customer name, so QB auto populate the discount rate.

I don't see a discount rate, but QB does calculate that right rate based on the price level set on the customer record. Is that what you mean?

RE: Then the discount rate is multiple by the item pricing.

I don't know what you mean by that.

RE: Quickbook is telling me $10.30 * 0.60 = $6.19 (supposed to be $6.18). I tried it with $10.28 * 0.60 = $6.174, but QB rounded to $06.18.

Questions:

- What is the regular price for the item?

- What are the price level settings for the level you're using?  Is any rounding applied?

The regular price of the item is $10.30. The discount is $0.60. There's no rounding issue because 

$10.30 * 0.60 comes out to be exactly $6.18. There wasn't a issue before and it just started happening a week ago.

I tired changing the price to$10.28.  Manual calculation, $10.28 * 0.60 = $6.174. QuickBook has it as $6.18. 

I'll make sure you receive the assistance you need with the decimal calculation error, @HelloRose.

Since verifying and rebuilding your data didn't work, I'd recommend getting in touch with our support team to address the problem. They have the right tools and resources to help you with this issue.

Here's how to contact them:

1. Open QuickBooks Desktop (QBDT).
2. Navigate to Help and choose QBDT Help/Contact Us.
3. Select the Contact Us button.
4. Enter a short explanation of your issue, then click Continue.
5. Log in to your Intuit account, select Continue, and then Continue with my account.
6. We'll send you a single-use code via email. Input your code and hit Continue.
7. Choose to Chat with us or Have us call you.

Our support hours are as follows:

• Pro, Premier, Plus: Monday-Friday, 6 AM to 6 PM.
• Enterprise: Any time, any day.

Furthermore, these informative articles can guide you in managing your invoices more effectively:

• Verify that an invoice was emailed and read by recipient
• Remove or unapply a credit from an invoice or bill

I'm always ready to back you up if you have other QBDT-related concerns. I'm just a reply away. Take care!

RE: $10.30 * 0.60 comes out to be exactly $6.18

This suggests the discount is 40%, not 60 cents.

I set up a Price Level with a 40% discount and it worked right for me. For an item that cost 10.30 each, the resulting price for the price level is 6.18.

How is your price level set up? Does it look like this when you edit it? Something different?

RE: I tired changing the price to$10.28. Manual calculation, $10.28 * 0.60 = $6.174.  QuickBook has it as $6.18. 

10.28 * 0.6 is 6.168, not 6.174.  When I tried it in QB, I got 6.168 as the rate, as expected.

It seems like QuickBooks is consistently both rounding and adding a cent in your case.  That could be a product of the rounding setting on the price level, if you've selecting anything but "no rounding" as seen above.

I get your results when I set the price level up like this:

Yes, the customer is getting 40% discount, so it's $10.30 * 0.60 (they are paying for 60% of the product price) = $6.18. QB is telling me it's $6.19. 

Can you show me where I can go double check the price level? But, the weird thing is I have not changed anything, how can the price just change itself?

Also, typo earlier, $10.29 * 0.60 = $6.174 => QB rounded to $6.18.

I don't think it can change itself.

Review the prices levels you have set up on the Price Level list:

• From the QB Menu, pick Lists | Price Level List.
• Then double-click the level in question, the one selected for the customer you're using, to see how it is configured.

I checked the price level. That doesn't seem to be the issue. The STRANGE part is I checked the QB on the sever, there isn't a issue. I did a side by side comparison of the price discount and you'll see that there's an error on some of these calculations are just added an additional 0.01 for NO reason.  Am I not seeing something right?

RE: That doesn't seem to be the issue. 

How did you determine that's not the issue (we still don't know how the price level is set up...)?

I review the Price Level and noticed that the price level on the workstations are the same as the one on the sever computer. No one has access to change price level other than sever computer. Additionally, the sever computer is the only computer that was calculating the discounts correctly. 

I actually called QB and the support actually told me to "repair the QB software and reinstall all updates," which seem to have fixed the calculation error. 

To me, this seems like QB issue, not my price level set-up issue.