Orders

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

Your customer's default currency and the order deposit account currency must match. Usually, your deposit account uses a different currency than the order.

Problem

You fail to sync sales and get this error:

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

Description

In QuickBooks, each customer has a default currency. Here is an example:

If you add an order whose deposit account uses CAD, then the sync will fail:

 

Solutions(s)

Rename and recreate customer

The QuickBooks customer currency code is read only. If you must use that customer, you need to create a new customer with the same name. Here are the steps:

  1. In QuickBooks, open the customer record.
  2. In the QuickBooks customer name field, enter old- before the customer name.
  3. Click OK.
  4. Create a new customer and assign the proper currency.
  5. Resync your sale.

If you sync sales receipts, map the deposit account:

1. Login to Connex, click Rules Engine > My Rules. 

2. Add New Rule 

3. Action: Map Order Deposit Account

4. Conditions, choose the following:

Screen Shot 2021-10-06 at 2.25.32 PM

4. Map To: Choose CAD Order Deposit Account 

If you sync invoices, map the A/R account:

1. Action: Map Order A/R Account

2. Conditions, choose the following:

Screen Shot 2021-10-06 at 2.25.32 PM

2. Map To: Choose CAD Accounts Receivable Account