Skip to content
English
  • There are no suggestions because the search field is empty.

The currency of the account must be either in home currency or the transaction currency.

Your QuickBooks customer must match the currency on the sale

Problem

You cannot sync sales to QuickBooks. You get this error:

Error 3140 : While trying to Add a(n) Invoice with order number of 3000021810, QB responded There is an invalid reference to QuickBooks AR Account "Accounts Receivable - CAD" in the Invoice. QuickBooks error message: The currency of the account must be either in home currency or the transaction currency.    

Description

Your QuickBooks customer currency code must match the currency code of the sale. Here is a USD customer trying to use a CAD A/R account:

Solution

Change the customer currency code

In this example, we will change the currency code from USD to CAD. Here are the steps:

  1. In QuickBooks, go to customer center.
  2. Open the customer record.
  3. On the top right, change the currency code:

Map the proper A/R account

You must map an A/R account for CAD sales:

  1. Go to the Connex rules engine.
  2. Click add new rule.
  3. As the action, choose map A/R account.
  4. In the conditions, add these values: Currency Code, Equals, CAD.
  5. In the map to field, enter Accounts Receivable - CAD.

Here is the end result in QuickBooks:

Rename the customer

In QuickBooks, double click the customer. Put a 2 before the name. Resync your order. Connex will create a new customer with the correct currency code.