Quickbooks export errors
Follow
Heather
Updated : Created :
Review failed exports to Quickbooks
Common Quickbooks integration errors
If completed Unleashed transactions are failing to export to Quickbooks, or if there has been any syncing issues for your Supplier and Customer records, use the Connection Log and Export Data pages to identify and fix common errors that can occur.
Review failed exports to Quickbooks
There are two ways to review the errors that can occur when data fails to sync successfully between Quickbooks and Unleashed:
- Review the Quickbooks integration's Connection Log.
- Review Failed Exports in the Export Data tab.
Re-export failed Quickbooks transactions
When you've identified a transaction or record that's outstanding or failed to export to Quickbooks you can re-attempt exporting it either as an individual export or as a bulk action. You must resolve the cause of the error before attempting to re-export a failed export, see Common Quickbooks integration errors,
To manually export individual transactions, hover over the end of the transaction's row in the Export Data tab and select Re-export.
To export transactions in bulk, use the checkboxes available in the Export Data tab to select the transactions due to be exported. A Batch Actions dropdown menu will be displayed above the Export Data's grid, select Re-export.
Common Quickbooks integration errors
If you experience any persistent errors or issues with Quickbooks exports, after completing the suggested fixes and actions, contact the Unleashed Support team.
| Quickbooks error message | Cause | Fix |
|---|---|---|
| Error code: 1, Message: Failed to export entity to QuickBooks | The export failed because on an issue in Quickbooks such as a validation or time out error. | Often it is either a minor validation error, or a time out error due to the volume of transactions being exported at the same time, and the failed transactions are the ones caught within the integration time out. You can try to re-export this. |
| Error code: 2500, Element: Reference Id, Detail: Invalid Reference Id : Accounts element id *** not found | The account, customer or supplier named is inactive in Quickbooks. |
Reactivate the account, customer or supplier in Quickbooks and re-export. |
| Error code: 6000, Detail: Business validation error: Transactions can only have one foreign currency at a time. | The Customer or Supplier's currency in Unleashed didn't initially match the Customer or Supplier currency in Quickbooks. | Check that the Customer or Supplier is set up with the correct currency in Quickbooks then re-export them. |
| Error code: 6000, Detail: Business validation error: The transaction needs to be in the same currency as the A/R and A/P accounts you use. | The Customer or Supplier's currency in Unleashed didn't initially match the Customer or Supplier currency in Quickbooks. | Check that the Customer or Supplier is set up with the correct currency in Quickbooks then re-export them. |
| Error code: 999, Message: Purchase account must be set for never diminishing product. | A Purchase account has not been selected in the Never Diminishing product's record. | Go to the ordered Never Diminishing product's record and allocate a Purchase Account using the dropdown filed in the Details tab, then re-export. |
| Error code: 6240, Detail: The name supplied already exists. | The Supplier or Customer Name already exists as a contact in Quickbooks with a different email address. |
Make sure there is only one contact with this name and edit any duplicates in Unleashed to make them unique, then re-export. It’s important to note that suppliers and customers cannot share the same name. |
| Error code: 6250, Detail: The customer you have specified has been deleted. | This customer has been made inactive in Quickbooks. |
Reactivate the customer in Quickbooks. To see your inactive customers, use the action cog in Quickbooks to tick the Include inactive. |
| Error code: 2500, Detail: Supplier assigned to this transaction has been deleted | This supplier has been made inactive in Quickbooks. |
Reactivate the supplier in Quickbooks. To see your inactive suppliers, use the action cog in Quickbooks to tick the Include inactive. |
| Error code: 6140, Detail: Duplicate Document Number | This transaction number already exists on Quickbooks. | Edit the existing transaction in Quickbooks to make it unique, then re-export the failed export. |
| Error code: 4000, Detail: QueryParserError: Invalid content | An invalid character's been used in the transaction's reference. |
Make sure that the customer or supplier name and code does not have any invalid characters such as “:” or “/”, click here to see accepted characters. |