All Collections
Webgility Desktop
Advice & troubleshooting
Post to QuickBooks Failed Due to there is an Invalid Reference to QuickBooks AR Account "" in the Invoice. QuickBooks Error Message the Currency of the Account must be either in Home Currency or the Transaction Currency
Post to QuickBooks Failed Due to there is an Invalid Reference to QuickBooks AR Account "" in the Invoice. QuickBooks Error Message the Currency of the Account must be either in Home Currency or the Transaction Currency

Post to QuickBooks Failed Due to there is an Invalid Reference to QuickBooks AR Account "" in the Invoice.

David Pond avatar
Written by David Pond
Updated over a week ago

Post to Quickbooks Failed Due to there is an Invalid Reference to QuickBooks AR Account "" in the Invoice. QuickBooks Error Message the Currency of the Account must be either in Home Currency or the Transaction Currency

Overview:

A failed attempt to post to QuickBooks is attributed to an invalid reference to the QuickBooks Accounts Receivable (AR) Account in the invoice. The specific error message indicates that the currency of the account must be either in the home currency or the transaction currency. The solution involves downloading the latest data from QuickBooks (logged in as an admin) and mapping the currency under customer settings. Here are the detailed steps to resolve the issue.

Details:

Error Message:

  • Post to QuickBooks failed.

  • Invalid reference to QuickBooks AR Account "" in the invoice.

  • QuickBooks error message: The currency of the account must be either in home currency or the transaction currency.

Resolution:

  • Log in to QuickBooks with admin credentials.

  • Enable Multi-Currency Feature

  • Activate the Multi-Currency feature in QuickBooks. (NOTE: After activating the Multi-Currency feature in Quickbooks Desktop, it is not possible to deactivate it.)

  • Enable the needed Currency or Currencies in QuickBooks:


โ€‹

  • Create a Customer with the needed Currency (Each currency will need a separate customer)

  • Create a Bank Account in each Currency needed

  • Establish Accounts Receivable (AR) accounts in QuickBooks for Each Currency needed.

  • In Webgility, download the latest data from QuickBooks to refresh the data to see the newly created information in QuickBooks.

  • Map the Currency under customer settings in Webgility.

  • After completing the currency mapping, try posting the order to QuickBooks again.

By following these resolution steps, the issue related to the invalid reference to the QuickBooks AR Account and currency error in the invoice should be resolved, allowing for successful posting to QuickBooks.

If you still have difficulty, please contact Webgility Support for assistance.

Did this answer your question?