Xero Integration – Event Log deciphered

This guide covers any errors that will possibly show up in the Event Log, referring to the accounting software you have integrated with Workshop Software which is found by going to Reports, Business Reports, Log Reports, and printing the Event Log, or on the Workshop Software user screen.

Error: The lockout date for Xero has been set to 5/19/2017, in this case, and no invoices or payments made before this date can sync over to Xero.

Solution: Change the lockout date in Xero. Then push a Xero manual sync, in Workshop Software (Manual sync button is in the top right hand corner of Workshop Software)

Error: The quantity or unit price of a product, in the invoice stated, is of a negative value.

Solution: Copy invoice (or credit) and change negative value to positive. Go into original invoice/credit and void

Guide: Copy Invoice

                Void Invoice

Error: The tax code, for the account code stated in this error, is set incorrectly in Xero.

Solution: Get your accountant or bookkeeper to set the correct tax type for the above account code, in Xero.

Error: Email address is invalid     

Solution: Go into the vendor (supplier)/ customer profile, found in the error where the above red arrow is pointing, and correct email address

Error: Payment has synced over to Xero before the invoice for that payment has             

Solution: In Workshop Software, do the following:

  • 1.       Check your invoice status using this guide: Check Invoice Status
  • 2.       If invoice hasn’t synced over to accounting software, check event log for specific error:
  • 3.       Use this document to decipher the errors that are on the event log
  • 4.       Can’t find your error? Send an email to support@workshopsoftware.com with a screenshot of the error on your event log

Error: Payment has synced over to Xero before the invoice for that payment has OR there is a rounding discrepancy between the invoice in Workshop Software and the invoice in Xero

Solution:

  • 1.       Login to Xero
  • 2.       Look up the invoice numbers, in the event log, and look for:
  • Is there any amount (no matter how infinitesimal) still owing on the invoice?
  • If so - adjust the invoice on the Xero side by the amount owing (to offset the difference)
  • 3.       Push a manual sync in Workshop Software (Manual sync button is in the top right hand corner of Workshop Software)

Error: Customer/Supplier has been created in Workshop Software but hasn’t synced over to Xero yet.

Solution: Push a manual sync in Workshop Software (Manual sync button is in the top right hand corner of Workshop Software)

Error: An invoice, with the same invoice number, has already been created.

Solution: Copy Invoice and Void Invoice (that was bringing back an error). The invoice will now have a new invoice number and will be able to sync over to Xero.

Push a manual sync in Workshop Software (Manual sync button is in the top right hand corner of Workshop Software)

Still need help? Contact Us Contact Us