OVERVIEW

  • This article contains Sync Errors that you may encounter when syncing to Xero with Detail Sync. This does not apply to Summary Sync.
  • Please find the error in this article that matches the sync error. There may be a way to get past the error without opening a support ticket. 


CUSTOMER ERRORS

  • 'The contact name <NAME> is already assigned to another contact. The contact name must be unique across all active contacts.'
    • "contact" refers to a Customer record.
    • There may be extra spaces in the customer name in CoreBridge. Remove any extra spaces from the name.

PAYMENT ERRORS

  • The UnitAmount value "0.0000" is invalid. UnitAmount must not be equal to zero...
    • Open a CoreBridge Support ticket and include a screenshot of the error so that a support agent can stop the payment from syncing.
    • Manually write off the Bad Debt in Xero.
    • The end result should be the invoice amount being reduced by the amount of the Bad Debt payment with a hit to your Bad Debt expense account. Once the write off has been completed in Xero be sure to confirm that the invoice in question matches between Xero and CoreBridge.

  • CB-xxx

    'The Type field is not valid for an update. This must be either 'SPEND', 'RECEIVE'.

    • The sync is trying to update one or more invoices invoice in Xero but Xero is preventing that. 

    • The typical reason is that a payment already exists on the invoice but Xero doesn't allow the sync to touch the invoice due to the payment. 

    • There are two options. 

      • (A) Remove the payment in Xero then sync again to allow the sync to update the invoice.

      • (B) Have support stop the payment from syncing then make any updates manually in Xero as needed. Please keep in mind that this may cause the sync to fail in the future if this invoice ever needs to be updated by the sync.



INVOICE ERRORS

  • 'Invoice not of valid status for modification. This document cannot be edited as it has a payment or credit note allocated to it.'
  • 'This document cannot be edited as it has a payment or credit note allocated to it.'
    • One cause is that a payment has been allocated/applied to the invoice in Xero. The payment needs to be removed/un-allocated manually in Xero for the sync to be successful.
      • If payment was applied in Xero manually, please be sure that there is a matching payment in CoreBridge. The sync should be able to move payments from a voided order to the new order as long as the sync applied the payment. If a payment was manually applied in Xero the CoreBridge payment may not have been entered.
      • How to remove an Overpayment: Remove an allocated overpayment from an invoice or bill
      • How to void a Prepayment: Void a prepayment
    • A second cause is that the invoice was manually voided in Xero. Invoices that sync from CoreBridge should not be voided. If the invoice was manually voided you will need to manually fix Xero and open a ticket to request that we stop the invoice from trying to sync.

    • There are two options. 

      • (A) Remove the payment in Xero then sync again to allow the sync to update the invoice.

      • (B) Have support stop the invoice from syncing then make any updates manually in Xero as needed. Please keep in mind that this may cause the sync to fail in the future if this invoice ever needs to be updated by the sync.




OAUTH ERRORS

  • 'Error in connecting to Xero: oauth_problem.....'

    • The sync must be authorized and performed using the CoreBridge assigned URL. (e.g. xxx.corebridge.net)
    • Custom domains are not supported.


  • 'oauth_problem=rate%20limit%20exceeded&oauth_problem_advice=please%20wait%20before%20retrying%20the%20xero%20api' 
    • This means that one of the limits imposed by Xero has been reached. 
      • 60 records per each 60 seconds
      • 5000 records per each 24 hours
    • The 60 record limit should not be reached because the system controls how many records can sync. If you have not hit the 5000 record limit and instead hit the 60 record limit, please wait one minute, re-authorize, then run the sync again. If you continue to hit the 60 record limit, please wait 5 minutes, re-authorize, then run the sync again.

    • Typically. the 5000 record limit should not be reached if you are syncing on a daily basis as recommended. If your system has a large number of transactions to sync and you are not syncing on a regular basis, it is possible to hit the 5000 record limit. This may happen during your first sync if you have many records to sync. If you hit the 5000 record limit, please wait 24 hours until you run the sync again.