back to knowledgebase

Troubleshooting Xero integration with these Error messages

Updated: 27 August 2019 16:09:28 OpenCRM::Xero Integration

The following error codes may be encountered when pushing invoices to Xero, or updating OpenCRM with information from Xero. The most common error-types tend to be:

* When mandatory information is not completed in either OpenCRM or Xero
* When Nominal Codes (aka Chart of Accounts in Xero) do not match
* When Invoice Status and payment statuses do not meet the requirements Xero needs.

These solutions should help you manage any problems but for further clarification or if you encounter any other errors please contact OpenCRM support.

Error Message Reason Solution
Validation Error on Invoice (#Invoice ID): Invoice not of valid status for modification; Invoice has not been sent to Xero. You are trying to send an Invoice to Xero that has previously been deleted or marked as voided in Xero. Don't delete Invoices in Xero. If you do you need to raise a new invoice in OpenCRM and push this to Xero, as the old invoice will now be marked as Void.
Validation Error: Input string was not in a correct format.
Error message may also contain:
- Check that item nominals are numeric and match Xero Account Codes
- Check that Products have buy and sell prices.
The Paid Date value is blank (null) in the database. Set it to be 0000-00-00 (or an exact value if one is available).
Validation Error on Item: (Your Product Name): Account code '301' (or other code) does not exist or cannot be applied to Items. Nominal Codes between OpenCRM and Xero do not match up. Check Settings > Studio > Picklist Settings > Edit Product Picklists > Edit 'Sales Nominal'. Make sure the values match Xero's 'Chart Of Accounts' values.

Then Check the Product has been updated with the correct Nominal Codes.
Validation Error on Item: (Your Product Code): Price List Item Code must not be more than 30 characters long; Item has not been sent to Xero. The Product Code is longer than 30 characters. Reduce the Product Code to below 30 characters.
Similar to the above error message. Product Name is longer than 50 characters. Edit the Product Name to contain less than 50 characters.
Validation Error on Invoice (#Invoice ID): This document cannot be edited as it has a payment or credit note allocated to it.; Invoice has not been sent to Xero.   If you are using the Xero integration, you should manage payments in Xero, and Credit Notes should be raised after the original invoice has been submitted to Xero.
Validation Error on Invoice (#Invoice ID): Account code must be specified; Invoice has not been sent to Xero. A product is missing a Sales Nominal Code. Review the Products linked to the Invoice and find the one (or more) with a missing Sales Nominal Code. Add in the missing Code.
This document cannot be edited as it has a payment or credit note allocated to it; Invoice has not been sent to Xero. The invoice is already in Xero, and is marked as paid. You will need to make the changes to the invoice status in your Xero account.
Validation Error on Invoice (#Invoice ID): The Contact Name already exists. Please enter a different Contact Name; Invoice has not been sent to Xero. Has the Xero Reference been manually added to the company record within OpenCRM? Check with OpenCRM support.
Validation Error on Invoice (#Invoice ID): Email address must be valid.; Invoice has not been sent to Xero. The contact / company do not hold a valid email addres. Make sure the standard email fields in OpenCRM are populated with valid email address that don't have invalid characters.
Validation Error on Invoice  (#Invoice ID): Organisation is not subscribed to currency ; Invoice has not been sent to Xero The Default Currency field is blank. Set the Default Currency.

Other non-error specific scenarios include:

Scenario Reason Solution
"The sync is blanking the email address from my companies/clients in Xero.". The contact/company has a blank email address field. Make sure the standard email fields in OpenCRM are populated as when the Invoices are pushed to Xero, they will also update the linked Contact details.

Rate This Article
  • 1 star
  • 2 star
  • 3 star
  • 4 star
  • 5 star
Feedback and Comments
captcha code  


You may also be interested in: