How to Troubleshoot Xero Error Messages During Export?

fileAI has in-built validation checks to ensure the data is correct in fileAI before exporting to Xero. However, there are occasions when the Export fails and fileAI displays the reason for the error.


Some of the most common errors that fileAI receives:

Xero Error 1: Invoice # must be unique

This export error is sent by Xero and indicates that your Sales Invoice number already exists in Xero. Since Xero does not allow duplicates, it returns an error

How to troubleshoot: 

Check if your document has already been made to Xero. If yes, you can archive the document stuck in RFE.

Important Note:

For Purchase Invoice, you can duplicate the Invoice number in Xero therefore this error is not applicable. 

 

Xero Error 2: Organisation is not subscribed to currency

Xero is sending this error message because your Xero account is not set up to handle foreign currency. 


How to troubleshoot: 

You have 2 options to resolve exporting this invoice and which one you choose is dependent on whether you are likely to use foreign currencies regularly;

  1. Subscribe to foreign currency within Xero, then select that specific currency for use in Xero
  2. Perform currency exchange for your documents in Bluesheets (Note: Exchange Rate is based on daily exchange rate based on Invoice Date)


Screenshot 1: Under Organisation Settings, we can select currency conversation organisation wide or on a rule-based level.

 

Screenshot 2: You will then see currency conversion show up on a per doc level

You will then be able to push the docs in SGD.

 

Xero Error 3: The document date cannot be before the period lock date, currently set at DD-MM-YYYY

This export error indicates that the document date is before the end date of the financial year, Xero forbids creating paid/approved documents for the previous financial year.

How to troubleshoot:

To overcome this export error, the export documents should have e.g. DRAFT status that is specified in the export rule.

Xero Error 4: Authentication error. Please reconnect to integration

This export error indicates that there is a disconnection  detected by the system.

image

How to troubleshoot:

To overcome this export error,  please disconnect 1) bluesheets from Xero and 2) Xero from bluesheets first before reconnecting 3) Xero in bluesheets