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-QBO 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 QBO 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 QBO, 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 QBO. The time entity is not set for this user. Aero could not sync the time to QBO, because the Aero user is not linked to their QBO entity. To fix this error, navigate to Setup > Team Members, find the user in question, and choose their QBO Entity from the dropdown list on the Edit Team Member screen.
Company: 7 failed to update to QBO. 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 QBO. You’ll need to resolve the unbilled charges in QBO before you can make the customer inactive. (Use the Aero Library template for Clearing unused billable charges)
Company: 21 failed to update to QBO. 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 QBO is out of sync so QBO wouldn’t update the customer. You will need to perform a manual sync in Aero to resolve it.
AeroTime: 2679 failed to add to QBO. 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).