QuickBooks Online Sync Error Messages

Your QuickBooks Sync Log (Navigate to Account Settings > Integrations) contains a lot of useful information - and sometimes some error messages. Learning how to read those error messages will help you manage your Aero-QuickBooks Online sync. 

The anatomy of an error message

The first part of each error message is from Aero. Since the only two things that sync from Aero to QuickBooks Online are Time and Customers, each message will start with either AeroTime or Company, followed by an ID number and then a short sentence telling you what went wrong on the Aero side. After the "." there will be the message we got from QuickBooks Online, that's what you need to read to fix what went wrong. Below, we've listed some common errors and what you need to do to resolve them.

AeroTime: 141194 failed to add to QuickBooks. The time entity is not set for this user. Aero could not sync the time to QuickBooks Online because the Aero user is not linked to their QuickBooks Online entity. To fix this error, navigate to Setup > Team Members, find the user in question, and choose their QuickBooks Online Entity from the dropdown list on the Edit Team Member screen.

Company: 7 failed to update to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Delete Customer Has Unbilled Expenses ErrorCannot delete Customer. : This customer cannot be deleted because there are unbilled charges for this customer. You tried to make a customer inactive in Aero who had unbilled charges in QuickBooks Online. You'll need to resolve the unbilled charges in QuickBooks Online before you can make the customer inactive. (Use the Aero Library template for Clearing unused billable charges)

Company: 21 failed to update to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Stale Object ErrorStale Object Error: You and Robert were working on this at the same time. Robert finished before you did, so your work was not saved. The version control between Aero and QuickBooks Online is out of sync so QuickBooks Online wouldn't update the customer. You will need to perform a manual sync in Aero to resolve it.

AeroTime: 2679 failed to add to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Customer required if billable Customer needs to be provided if billable. An Aero was marked as billable, but there was no Company in the Company field. Go to Manage > Time, click the For QuickBooks Sync toggle view, find the time entry that didn't sync, click the Time button to edit the time entry, and choose a Company (or uncheck the Billable box).

AeroTime: 178 failed to add/update to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Invalid Reference IdInvalid Reference Id: Something you're trying to use has been made inactive. Check the fields with accounts, customers, items, vendors or employees. One of the fields that are used as a reference for the time sync points to something that has been made inactive in QuickBooks Online. The most likely culprit is the customer, but also look at the Service Item, then the Employee/Vendor, and the Class. 

Company: 106 failed to update to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Delete List Has Balance Error The entity you are trying to delete has an open balance. : This customer cannot be deleted because it has a non-zero balance. You tried to make a company inactive in Aero (which would also make it inactive in QuickBooks), but QuickBooks wouldn't allow that because there is an open balance in QuickBooks.

AeroTime: 15 failed to add/update to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Employee or Vendor error Employee or Vendor need to be provided. Both cannot be present. : Employee: null Employee or Vendor error Employee or Vendor need to be provided. Both cannot be present. : Vendor: null Aero could not sync the time to QuickBooks Online because the Aero user is not linked to their QuickBooks Online entity. To fix this error, navigate to Setup > Team Members, find the user in question, and choose their QuickBooks Online Entity from the dropdown list on the Edit Team Member screen.

AeroTime: 6224 failed to add/update to QuickBooks. An error occurred while sending the request. The QuickBooks Online API is down. You will continue to experience problems until it's back up. You can check the status of the API here: https://status.developer.intuit.com/ Once the API is back up, you can sync the failed times using the Batch Update Times screen.

AeroTime: 9745 failed to update to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Stale Object ErrorStale Object Error: You and XXX were working on this at the same time. XXX finished before you did, so your work was not saved. This time entry has already been synced to QuickBooks Online and then edited in QuickBooks Online. Once a time entry is edited in QuickBooks Online it is locked and Aero is no longer allowed to update it. 

AeroTime: 16222 failed to add to QuickBooks. Data at the root level is invalid. Line 1, position 1. Error code: BadRequest Invalid Reference Id: XXX assigned to this transaction has been deleted. Before you can modify this transaction, you must restore XXX (deleted). The entity attached to this time entry had been deactivated (deleted) in QuickBooks Online. To send this time entry, you must first reactivate that entity in QuickBooks Online or attach a different entity to the time entry in Aero.

AeroTime: 143955 failed to add to QuickBooks.
Data at the root level is invalid. Line 1, position 1. Error code: BadRequestA business validation error has occurred while processing your request Business Validation Error: Something this action required is no longer available. Another user may have deleted it. Please refresh your screen to see the current information.