When you sync ServiceCore with QuickBooks Desktop (QBD), your invoices, payments, and customer data transfer between the two platforms automatically.
If your QuickBooks Desktop (QBD) sync ever fails, ServiceCore logs an error message to help you identify what went wrong. Use this glossary to look up the error, understand what it means, and follow the steps to resolve it.
Please Note: ServiceCore no longer offers new integrations with QuickBooks Desktop (QBD).
If you've integrated QuickBooks Online QBO) with your ServiceCore account, please click here to see the QBO Glossary instead.
Before You Start
Here are a few things to know before you continue:
You must have Owner or Admin permissions in both ServiceCore and QBD to troubleshoot error messages.
- The most common way to re-sync a failed item is to edit and re-save the item in ServiceCore. You don't actually have to edit anything, just click "Edit" and then click "Save".
- If you need to re-sync an item that is linked to multiple transactions in your account, you'll need to edit/re-save the item first and then edit/re-save all the linked transactions.
- For example, an invoice linked to 5 payments means that the invoice and all 5 payments must be edited and re-saved to trigger a re-sync.
How Items are Linked in ServiceCore
The sync between ServiceCore and QBD works as a chain. Each piece of data in ServiceCore links to another piece of data and a failure anywhere in that chain blocks everything downstream from syncing.
The decision tree below walks you through how to trace a sync failure back to its root cause. This is helpful for understanding why you have to check multiple items when something doesn't sync properly.
For example, if a payment doesn't sync to QBD, you must check its related invoices, service line items, account names, and more to find the root cause of the sync failure.
TIP: Click on the image below to enlarge it and zoom in.
Glossary of Error Messages
The table below contains common error messages you might see in ServiceCore, what they mean, and how to resolve them so the items sync properly.
| Error Message / Translation | Steps to Solve |
|---|---|
|
ERROR:(3145) - The name "<customer-name>" of the list element is already in use Sync direction: Bridge → QBD Item Causing Error: Customer. Translation: The customer name is already is use on the QBD file. |
Please double check in QBD file if any of these items could have the same name:
Once you have confirmed there is a record with the same name:
|
|
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:(3175) - There is an invalid reference to a parent "<customer-name>" in the Customers list. QuickBooks error message: Invalid argument. The specified record does not exist in the list. Sync direction: Bridge → QBD Entity: Customer Translation: This Site’s parent customer is not found during the sync. Generally indicating that there was a name change on the customer, which did not cascade. |
|
|
ERROR:(3185) - There is an invalid reference to QuickBooks Customer "<customer-name>" in the ReceivePayment. QuickBooks error message: Invalid argument. The specified record does not exist in the list. Sync direction: Bridge → QBD Item Causing Error: Payment Translation: The customer this payment is for is not found during the sync. |
|
|
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:
|
|
"Income Account <Account Name> could not be found in ServiceCore." Sync direction: Bridge → SC Translation: The Entity being synced (usually a service) is reporting a relationship to an Account whose Full Name does not match any ServiceCore Account’s Full Name. |
This issue can be caused by the “Show lowest subaccount only” setting in QBD.
|
|
"Site Must Have Parent Customer" Sync direction: SC → Bridge Translation: The Site is missing a customer. |
|
If you have any questions, please reach out to our Support team through the chat widget on the bottom of this page or by sending an email to support@servicecore.com!