Invalid Amount Format while sending deposits in QuickBooks

For users or potential users.
Post Reply
glamorgan
Posts: 41
Joined: Tue Nov 08, 2011 11:25 pm

Invalid Amount Format while sending deposits in QuickBooks

Post by glamorgan » Thu May 03, 2012 5:11 am

Hi everyone

I'm trying to use the QB integrator (OD v12), when trying to send deposits, i get the following error:

Invalid Amount Format, a deposit has not been created in QuickBooks, continue anyway?

I am using a 3 decimal currency,the base currency of my QuickBooks Company file is a 3 Decimal Currency (Multiple currencies enabled under EDIT-Preferences in QB),
my local regional settings is also set to a 3 deciaml currency.

Now, If i change my regional settings to 2 decimals after decimal instead of 3 and re-start OD, the deposit is created.

any ideas how overcome this?

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Invalid Amount Format while sending deposits in QuickBoo

Post by jordansparks » Fri May 04, 2012 11:08 am

We'll look into it.
Jordan Sparks, DMD
http://www.opendental.com

glamorgan
Posts: 41
Joined: Tue Nov 08, 2011 11:25 pm

Re: Invalid Amount Format while sending deposits in QuickBoo

Post by glamorgan » Sun May 06, 2012 3:10 am

Hi there;

As we investigated the matter further, we came to know that QB will not support amounts with 3 decimals! believe OR NOT! and therefore, it's more of a QB issue and not OD!

The best work around to overcome this is to ROUND the amounts before creating the deposit..let us know if you have another suggestion or if you have any other comments.

Thanks;

User avatar
jsalmon
Posts: 1555
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Invalid Amount Format while sending deposits in QuickBoo

Post by jsalmon » Mon May 07, 2012 7:28 am

We started forcing the rounding to two decimal places for the QuickBooks bridge in v12.1.8. Updating to the latest stable version of Open Dental should stop this error from showing up from time to time.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply