Search our Help.

  1. Unleashed Support
  2. Integrations
  3. Xero Integration Guide

Xero Connection Log & Common Errors

Follow

If your completed Unleashed transactions are failing to export to Xero or if there has been any syncing issues for your Supplier and Customer records, use the Connection Log and Failed Exports pages to identify and fix common errors that can occur.

Review failed exports to Xero

There are two ways to review the errors that can occur when data fails to sync successfully between Xero and Unleashed:

  • Review the Xero integration's Connection Log.
  • Click on the View Failed Exports link at the bottom of your Unleashed page.

Xero's Connection Log

You can review the Connection Log tab in your Xero integration to further investigate and resolve any issues that may have occurred whilst Unleashed attempted to export your transactions or sync your Suppliers and Customers with Xero.

  1. From the main menu, navigate to Integration, Integration Store and select the Xero tile.

  2. Select the Connection Log tab.

  3. All sync updates from the previous 7 days will be listed in date order (newest first) in the grid below.


  4. Filter the connection log's grid using the following filter options:
    • Log Level: Use the drop down menu to filter the grid's log by type: All, Error or Info.
    • Search: A free text field which will filter the log's details by the specific text entered.

View Failed Exports

When a transaction or record fails to export or sync with Xero, it will be highlighted in the blue "Xero Export Queue" banner that displays at the bottom of your Unleashed pages:

  1. Click on the View Failed Exports link, available in the "Xero Export Queue" banner.


  2. You will be re-directed to the Manage Xero Queue page, which will display:
    • Current Xero Queue: A list of exports currently in process of exporting to Xero.
    • Failed Xero Exports: A list of exports that have failed to sync.


  3. Within the Failed Xero Exports grid will display the following information:
    • Failed Export: A description of the type of transaction or record attempting to export.
    • Exported Item: The transaction's, Customer's or Supplier's reference number (e.g. the transaction's order number or the customer's name).
    • Export Error: A description explaining why the transaction or record failed to export successfully.
    • Action Required: A description of the steps needed to resolve the error.
    • Export: A hyperlink that can be selected to re-attempt exporting the failed item.
    • Delete: A hyperlink that will remove the failed export from the queue. 

For more details, see Using Xero with Unleashed.

Resolving common Xero integration errors

If you experience any persistent errors or issues with Xero exports, after completing the suggested fixes and actions, contact the Unleashed Support team.

Error message Cause Fix
The document date cannot be before the period lock date, currently set at XX-XXX-20XX The document date cannot be before the end of year lock date, currently set at XX-XX-20XX The date the transaction's attempting to export is after the End of Year Lock Date set in Xero.

You will need to refer back to your Xero account  and unlock the End of Year Lock Date, then re-export from Unleashed.

This error cannot be resolved in Unleashed directly.
Response status code does not indicate success: 500 (Internal Server Error). The number if transactions and/or records attempting to export and sync with Xero has exceeded its daily rate limit of 5000 requests. 

The daily rate limit is a limitation set by Xero's API and cannot be extended by Unleashed. To resolve, wait 24 hours, until the daily limit has reset and then re-attempt exporting them from Unleashed.

For more details on Xero's integration limits, please see Xero Rate limits.

Account Code XXX is not a valid Code for this document

Account code or ID must be specified

 The account may have been archived or no longer exists in Xero.

Contact the the Unleashed Support team and they will be able to re-map the account code to an existing account. 

Submit a support ticket in the Support Portal
Account must be valid, Tax Rate must be valid The sum total value of the exporting journal transaction is less than 0.005.

There is no fix for this error, as Xero is only able to import journals with a value of 0.01 or greater. As such, for journals with a value of 0.005 or less, they are rounded to a value of 0.00 and therefore negligible to Xero's accounts. We therefore suggest deleting the error from your Failed Exports Queue in these cases.
Export of XXX to Xero Contacts API failed - Details: Xero validation error: The Customer or Supplier's GST/VAT Number is invalid Update the Customer or Supplier's GST/VAT Number in Unleashed and ensure it's in a valid format, matching the country specified in the contact's setting in Xero, then re-export from Unleashed.
The specified contact details matched an archived contact. Archived contacts cannot currently be edited via the API The previously mapped contact in Xero has been deleted, merged or archived in Xero, disrupting it's sync with Unleashed.
  • If the contact was archived in Xero, go to Xero's contact and un-archive it, then re-export from Unleashed to re-establish a successful mapping. For more details, see Archive or restore contacts.
  •  If the contact was merged to another contact in Xero, obtain the merged contact's URL from Xero and request for the contact to be re-mapped with our support team. 
    Submit a support ticket in the Support Portal
API failed - Details: * Email address must be valid. The email address for the Supplier or Customer contact is not given in a valid format in Unleashed.

Update the Supplier or Customer contact in Unleashed to ensure:

  • Only one email address is provided per contact.
  • No comma's, spaces or additional characters are included in the email field, other than the email address.
  • The email address is in a valid format.
Was this article helpful?
0 out of 3 found this helpful