cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here

Reply to message

View discussion in a popup

Replying to:
patdrd
Level 1

How can we ensure QuickBooks Online calculates the ExchangeRate?

Hello,

 

The company I work for deploys Dispatching and Trucking software that exports invoices into QuickBooks Online for our mutual clients. Recently, we've expanded to support multiple currencies, but herein lies the issue. When an invoice is exported from our software into QuickBooks Online, the exchange rate seems to be defaulting to 1. Several of our mutual customers deals with Canadian and American clients and this throws off their profits significantly.

 

 

We've noticed that after we've posted our invoices, we receive a JSON response the indicates the ExchangeRate is 1. We currently do not send ExchangeRate with our posts because we were under the impression that QuickBooks Online would calculate the ExchangeRate on it's own as it does with invoices that are created from within QuickBooks Online, but this is not the case. As such, we are at an impasse.

 

 

When we export invoices (we do not send the ExchangeRate) the invoice defaults to a 1:1 ExchangeRate.

1.png

However when an invoice is created within QuickBooks Online, the ExchangeRate is automatically calculated:

2.png

 

Is there a special value we can send in the ExchangeRate field to ensure that QuickBooks Online calculates the proper ExchangeRate for the currencies used on the invoice without our software explicitly supplying it?