A Validation Exception Occurred - The Account Number Already Exists

A Validation Exception Occurred - The Account Number Already Exists

Question/Problem 

Invoices will not sync with Xero and the following error is displayed: A validation exception occurred The Account Number already exists, please enter a different Account Number.

Cause

This error commonly occurs due to a mismatch in company names between KCC and Xero, so the integration tries to create a new company record based on the KCC value which also fails as it is in already use within Xero. Common causes of this are manually creating contacts and companies in Xero that do not use the same details as KCC.

Resolution/Solution 

To fix this error you must do one of the following and then sync:
  1. Manually adjust the record in Xero to match KCC.
  2. Manually adjust the record in KCC to match Xero.