SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

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.
Pallavi-sharma
Level 1

decimal values change when syncing with erp—e.g., 15.12 becomes 15.13 in quickbooks. tested sandbox sends correct values. any ideas on fixing this?

we've noticed an issue where decimal values sometimes change when syncing with the erp. for example, entering a credit card fee of 15.12 in the erp shows up as 15.13 in quickbooks. we've tested this in the sandbox, and the correct values are being sent. any guidance on this?

3 Comments 3
Ivan_G
QuickBooks Team

decimal values change when syncing with erp—e.g., 15.12 becomes 15.13 in quickbooks. tested sandbox sends correct values. any ideas on fixing this?

QuickBooks rounds any transaction amounts into two decimal points, including data from integrated apps like ERP, Pallavi.

 

It means that if you have an entry from ERP amounting to 15.125, once synced, QuickBooks will automatically round the value to 15.13. Please know that SandBox's system does not directly follow this guideline.

 

To handle this situation, you can manually change the Credit Card (CC) fee Amount directly in QuickBooks:

 

Take note that the interface varies by transaction type, and the image I've provided is a sample from a regular QuickBooks expense entry.

 

Need help managing your books? Our QuickBooks Live Expert Assisted team has your back. We have dedicated bookkeepers that can assist you with streamlining your accounting processes.

 

You can also access this article: Run a report. It can guide you through pulling up financial data and reviewing your company's stability.

 

Feel free to revisit this thread for further inquiries about your data's synchronization in the platform.

Pallavi-sharma
Level 1

decimal values change when syncing with erp—e.g., 15.12 becomes 15.13 in quickbooks. tested sandbox sends correct values. any ideas on fixing this?

We are sending 2 decimal from the database.

JamesDuanT
Moderator

decimal values change when syncing with erp—e.g., 15.12 becomes 15.13 in quickbooks. tested sandbox sends correct values. any ideas on fixing this?

Thank you for keeping us updated about this, Pallavi-sharma.

 

Since the data from Sandbox ERP is already in 2 decimal and still not sync properly with QuickBooks Online, I'd recommend reposting this query in the Intuit Developer's Community. This is where API integration issues are addressed by engineers or personnel with expertise in third-party applications, particularly if you are developing an app for QuickBooks Online.

 

  1. Go to this link: https://help.developer.intuit.com/s/.
  2. Choose the QuickBooks Online tile.
  3. Click Ask as Question on the right.
  4. Log in to your Intuit account and enter your query.

 

After settling the differences and syncing concerns, you can go back to QuickBooks Online and review the amounts. Make sure the data on your reports are accurate for you to reconcile the accounts in the future. 

 

We'll get back to you if you require additional assistance.

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

Need to get in touch?

Contact us