Your QuickBooks Sync Log (Navigate to Admin > Manage QuickBooks) 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 billableCustomer 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 ErrorThe 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.