Bluesheets has in-built validation checks to ensure the data is correct in Bluesheets before exporting to Xero. However, there are occasions when the Export fails and Bluesheets displays the reason for the error.
Some of the most common errors that Bluesheets receives:
Xero Error 1: Invoice # must be unique
This export error is sent by Xero and indicates that invoice with a number that should be exported 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.
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;
- Subscribe to foreign currency within Xero, then select that specific currency for use in Xero
- 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.
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