This article outlines the process required to resolve common errors encountered when importing or exporting financial data.
Contact Export Failures
The contact number is already linked to another contact. This can occur due to multiple reasons;
- The contact was not exported, instead, the invoice was exported first creating a contact.
- The linked contact in Xero has been archived
- An Organisation has no Payer or Employer assigned, this can cause the first invoice exported to assume they are the Payer for that Organisation even if they’re a Student.
If the contact is not archived and a Payer has been assigned to the Organisation refer to the steps below.
- Using Xero Contacts, Unlink the organisation and/or contact (Skip this step if already unlinked)
- Using Xero Contacts, tick the box "Enable contact revisions" and search
- Select the action "New Revision" of the organisation/contact
- Then using the Import tool, search for the Xero contact & select the matching contact/organisation in the Action dropdown.
No duplicate contacts should be created on either platform.
Contact Validation Error when importing a contact.
This means that the contact in Xero doesn't currently have either a First or Last name. Xero contacts with no names can only be imported as Organisations.
Invoice & Credit Note Failures
Invoice or CN not of valid status for modification
The invoice or CN in Xero isn’t editable. Likely the invoice or CN has been voided or paid in Xero.
Review the status of the invoice or CN in Xero.
The account code or ID must be specified
One or more of the invoice or CN line items has no finance code assigned. Finance codes must be imported from Xero.
Account code ‘XXXX’ is not a valid code for this document
The invoice line item has a finance code that is not recognised by Xero. Create the finance code in Xero and/or import the finance code from Xero.
Item Code is invalid.
Xero Inventory is currently enabled, to resolve this either disable Xero Inventory or add the item code in Xero.
Item codes in aXcelerate are all automated and determined by the line item’s point of origin (Qualification Code, UoC Code, Workshop Type Code, or InHouseInvoices).
Payment & Refund Failures
Payments & Refunds can only be made against Authorised documents
The invoice/CN has an outstanding amount lower than the payment/refund amount to 3 decimal places.
Importing Payments from Xero is marked as Invalid.
Ensure the linked contact in Xero has not been archived, if the contact is not archived refer to the steps below.
This is due to the contacts being incorrectly linked and usually only relating to organisations. The following process of creating a revision should resolve this issue.
- Using Xero Contacts, Unlink the organisation/contact (Skip this step if already unlinked)
- Using Xero Contacts, tick the box "Enable contact revisions" and search
- Select the action "New Revision" of the organisation/contact
- Then using the Import tool, search for the Xero contact & select the matching contact/organisation in the Action dropdown.
Xero Returned an Error Response Code
403 Forbidden & 429 Too many requests.
The Xero API limitation per minute has been met, please wait and try again.
- Minute Limit: 60 calls in a rolling 60 second window
- Daily Limit: 5000 calls in a rolling 24 hour window
When this occurs with a workflow that exports to Xero, it is best to manually export large groups of financial items and only use the workflow to manage smaller more frequent exports, i.e. daily each morning.
400 Bad Request Unable to process the request.
For non-contact related items, this means that the contact is not correctly linked, refer to “Contact Export Failures”.
All other events of this error, the connection to Xero has been revoked.
This is most commonly caused by a deactivation/deletion of the Xero User that originally enabled the integration. Disconnect and re-establish the connection within the integration settings found in Settings Web & Other Integrations.