The purpose of this help article is to provide you with a glossary of the most common QuickBooks Online sync errors you might encounter when reviewing your error logs. Along with the error messages, we also provide a human-readable translation and instructions for how to solve the errors.
That being said, sometimes the error messages are a little confusing and hard to figure out what to do to fix them. We're here to help if you get stuck. Please submit a support request if you need assistance.
Before You Start
If your account currently syncs with QuickBooks Online or QuickBooks Desktop, we will soon be making it easier for you to see any sync errors and to resolve them yourself, without having to submit a support request each time you need assistance. If you're interested in being a part of this pilot program, please send an email to support@servicecore.com with the subject line "QuickBooks Error Log Access Request" and we'll get you started. |
Here are some things to know about troubleshooting and fixing your sync errors:
- If your ServiceCore account is not enabled to sync with QuickBooks Online, this article doesn't apply to you
- If your account syncs with QuickBooks Desktop, go here: QuickBooks Desktop Glossary of Error Messages
- Please read over this article to understand how the sync works: About QuickBooks Online Sync
- The most common way to re-sync a failed item is to edit and re-save the item in ServiceCore
- You don't need to edit anything on the page
- Simply click Edit for the item and then click Save
- That's all it takes to trigger the item to re-sync
- If you have an item that is linked to multiple transactions in your account, for example, an invoice that is linked to 5 payments, to get everything to re-sync you will need to:
- Edit and re-save that invoice
- Then you will need to edit and re-save all the linked payments
How Items are Linked in ServiceCore
For visual explanation of how items are linked together and sync to Quickbooks, below is a decision tree flow diagram to explain why when, for example, a payment doesn't sync, you must check the invoices, service line items, account names and more to find the root cause of the sync failure. A good way to think about this is that it's creates a "cascade" effect, like a waterfall, dominos or chain reaction. A failure in one thing far down the chain will cause the next link to fail, and then the next, and so on.
Click on the image to open it full size:
Glossary of Error Messages
Error Message / Translation | Steps to Solve | |
---|---|---|
Import IPPayment:186636 failed 'payment must relate to a linked transaction' QBO allows ‘unapplied’ payments in certain cases. Unapplied payments are not linked to any invoices, and function similar to credit memos. ServiceCore won’t sync such payments. |
|
|
Import IPPPayment:186589 failed 'related invoice 186588 was not imported' Our sync has a domino effect, this payment did not sync because the Invoice did not sync. The related Invoice will need to be looked into as to why it did not sync. |
|
|
Export Invoice:2085307 invalid 'service soft deleted' This error means that one of the Services, that are listed as a line item on the invoice, has been Deactivated within ServiceCore. |
|
|
Export CreditMemo:2085308 invalid 'service soft deleted' “Service soft deleted” means that the Service related to this transaction was marked as Deactivated. |
|
|
Export Invoice:2004354 failed 'Expected to find matching ID in QuickBooks' This invoice was synced into ServiceCore and was bound to an invoice in the customer’s QuickBooks account. The invoice in QuickBooks was deleted, so we are unable to sync this invoice back into their QuickBooks account.
|
Depending on where the invoice originated, there are a few options. In QuickBooks Online, a Deleted invoice CANNOT be restored. Once an invoice is deleted, you can view it under the Audit Log in QuickBooks, but cannot bring it back as an active invoice. QB Help page: Use the audit log to re-enter deleted transactions
|
|
Export Invoice:2076234 failed 'QuickBooks\Online\Mapping\ This means that there is an issue with the binding between the Customer record in QB and SC. Most likely this was caused by a name change that did not sync properly. |
|
|
Export Invoice: 'Could not find service identifier by value 19' This means that there is a service line item on that invoice that is not recognized. |
|
|
Export Invoice:2098562 failed 'Operation Create/Update with Deposit turned off from Sales Deposit preference is not supported.' Intuit’s API does not allow deposits on an Invoice if a “Deposit” flag is not checked under Preferences. |
|
|
ERROR:(3165) - Object "[id]" specified in the request cannot be found. [optional:] QuickBooks error message: This feature is not enabled or not available in this version of QuickBooks. The portion marked "[optional:]" may or may not appear, and does not change the error or its possible resolutions. |
This error may occur either due to a missing invoice or due to an invoice paid in QuickBooks with a payment not in ServiceCore. If the invoice exists in QuickBooks:
If the invoice does not exist in QuickBooks:
|
|
ERROR:(3220) - There was an error adding, modifying or deleting [id] because it is already in use. Quick Books error message: The transaction could not be locked This error means that the file record is opened by a user. |
Have all users close QuickBooks before starting a sync. |
|
ERROR:(3255) - The "AppliedToTxnAdd payment amount" field has an invalid value "[value]". QuickBooks error message: You cannot pay more than the amount due This message is reporting that the payment amount from ServiceCore would overpay the target invoice in QBD. |
This error may occur due either to a partial payment in your QBD that does not exist in ServiceCore, or due to slight differences in invoice total calculation between QBD and ServiceCore. To determine which:
If there are extra payments in QBD, that is likely causing the problem. To resolve the issue,
If there are not extra payments in QBD, the issue is likely a slight calculation difference between the two systems. In this case:
|
|
Other errors not on the list above |
If you encounter an error that isn't listed above, please submit a support request to ServiceCore to assist you. |