This article lists sync errors and how to address them.
There was an error when modifying a Customers list, element "8000092E-1554170119". QuickBooks error message: Cannot merge list elements.
The typical cause is that there was a name change but the customer made a change in the accounting software instead of letting CoreBridge update the accounting software.
Check for name change. If that happened, send canned response: Customer - cannot merge list elements - name change
Merge not allowed from object with id ="800004C4-1496439246" to object with id ="800003F0-1486681309". QuickBooks error message: Cannot merge list elements.
- This is the information we need to address the error. Add this to the ticket.
- OLD ACCOUNT ID:
- OLD ACCOUNT NAME:
- NEW ACCOUNT ID:
- NEW NAME:
- This is what the fields are.
- ID: The CBID of the merge table. This is not the CBID of the customer. When a merge happens a record gets added to the database table. The merge table displayed in CB SUPPORT is what were are using to deal with the error.
- OLD ACCOUNT ID: The CBID of the old customer record prior to the merge. Once a merge happens the old customer is deleted so the old CBID is stored.
- OLD ACCOUNT NAME: The name of the old customer before the customer record is deleted. This name is also displayed on the winning customer record in account history
- NEW ACCOUNT ID: The CBID number of the winning customer. Remember that the winning customer doesn't get created. It had to already exist before the merge so it's recorded.
- NEW NAME: The name of the winning customer.
- Open their system
- Go to CB Support > QuickBooks > ACCOUNT MERGE HISTORY INFORMATION:
- Find the merge record in question
- Record the information from the merge table to the ticket next to the field names from step 1.
- You can copy the table to Excel which may make it easier to find the record in question. The table stores every merge that happens so the column names will be at the top and new merge record will probably be at the bottom.
- For NEW NAME, use the NEW ACCOUNT ID to find the customer in CoreBridge so you can add the name to the ticket.At this point all fields noted in step 1 should have values
- Set maps on the following records
ID FROM MERGE TABLE MAP OBJECT TYPE ID MergedCustomer OLD ACCOUNT ID Customer
- Add the appropriate canned response to the ticket based on the sync type.
- Merge Customers - QB Desktop
- Merge Customers - QB Online
- Merge Customers - Xero
- Copy and paste the old name and new name from the notes to the ticket response.
- Reply to customer and close/resolve the ticket
- It's up to the customer to complete the merge. Many ignore our email because the error stops. Then when something else needs to sync to that customer that records fails because the sync is looking for the new customer but it doesn't exist because they didn't manually address the merge as instructed.
- This is the information we need to address the error. Add this to the ticket.
- QuickBooks found an error when parsing the provided XML text stream.
- If the record in question is a Bad Debt payment, that is a sync tool update on the bad debt account. Send canned response.
- If the record in question is a customer or vendor, it's something with the text in one of the fields, not always the name field. There is something that QuickBooks doesn't like. This doesn't happen with Xero as much.
Examples: Space after a name, space before a name, special characters (tilde, grave' accent mark incorporated with the letter).
- Find the offending character, copy it to the ticket, the change it in CoreBridge. Tell the customer what is what changed FROM and TO
- Find the offending space. Tell the customer what the issue was and what the fix was.
- This error can also be related to $0.00 Journal Entries. However, that was fixed in a Sync Tool update so that reason should no longer appear for Journal Entries.
Object "80001AEE-1383411583" specified in the request cannot be found. QuickBooks error message: Invalid argument. The specified record does not exist in the list.
Something is missing in QuickBooks related to the payment. 99% chance it's the related invoice(s)
Search the Object ID to determine the record type that is missing.
If it's a customer
Confirm that the CBID matches the customer
Note the customer name on the ticket
Clear the map
Add system text to ticket
Add canned response: "Invoice Payment - Object specified in the request cannot be found - CUSTOMER"
Note customer and last sync date
Example of note to customer
Reply and close the ticket
If it's a payment, search the payment to view the transaction.
Payment is on a single invoice:
The object ID is probably the invoice. Search the Object ID in CB SUPPORT and it should match the invoice. If not, there is another problem.
If the object ID matches the invoice from the payment, clear the invoice map.
Payment is on multiple invoices and:
Add canned response: "Invoice Payment - Object specified in the request cannot be found - INVOICE"
Add failed payment IDs
Add invoices that maps were cleared on
Reply and close ticket
Message:ValidationException was thrown.Details:Invalid Number : IGNORE, ErrorCode:ErrorCode:2090, Message:Invalid Number, Element:CustomerRef.value, Detail:Invalid Number : IGNORE
(QBO Full only?)
- This is an API validation
- This is the telling part: "Invalid Number, Element:CustomerRef.value"
- Appears that the map in CB can no longer be used to identify the customer in QuickBooks. Something happened with the related customer in QB
- Check the account history to see if there was a name change or a merge.
- Merge: QBO sync does not merge. If the customer does not perform the merge manually in QB correctly, the customer record will be affected. They need to complete the merge in QB where the winning record matches the existing customer in CB
- Send canned response: "Merge Customers - QB Online"
- Close ticket
- Name Change: If they changed the name in QB instead of letting the sync change the name, the customer record will be affected.
- Have customer be sure that the name matches between CB and QB
- May need to clear map on customer to get the customer map to be re-established
Stencil (LDPE) Natural White .090
Message:ValidationException was thrown.Details:Required parameter An inventory cost-of-goods-sold account is required if you are tracking inventory quantities for this product. is missing in the request, ErrorCode:ErrorCode:2020, Message:Required param missing, need to supply the required value for the API, Element:, Detail:Required parameter An inventory cost-of-goods-sold account is required if you are tracking inventory quantities for this product. is missing in the request
(QBO FULL ONLY?)
- The typical cause is that the part or modifier in question is marked inactive but for some reason it's still trying to sync.
- Search the part/modifier in question in CB to see if it is inactive. You need to use the bulk update function to see inactive items.
- Then run a parts detail report to see if the item has any sales
- IF INACTIVE AND NO SALES
- Set the map
- Tell customer it was inactive, there were no sales, so you set it to not sync.
- IF NOT INACTIVE
- This usually happens when an item from CB that is trying to sync already exists in QB
- If the customer didn't match all items during setup the sync will eventually catch these
- Add canned response to ticket: "Parts - an inventory cost-of-goods-sold account is required"
- Note all failed parts
- Reply and set to pending for future followup
20oz. Type 2 Wall Covering - Suede 30% Post Consumer Recycled
There was an error when modifying a ItemInventory list, element "80000206-1505761075". QuickBooks error message: The posting account cannot be changed.
A G/L account was changed in CoreBridge for the part in question but QuickBooks isn't allowing the G/L account in the item in QB to be changed.
The account needs to be changed back to what is was in CoreBridge to match QuickBooks.
Add canned response to the ticket: "BillingItem_Part - the posting account cannot be changed"
Note the records in question
There was an error modifying a ReceivePayment. QuickBooks error message: Transaction not in balance
This can happen with any customer but for AFB, the typical cause is that they are using 2 A/R accounts with causes the sync to choke.
Request customer balance by using the appropriate canned response
If the invoice in question and all related payments/credits exist in their accounting software:
Set map on the invoice
Add canned response: "Invoice - transaction not in balance"
Fill in blanks on canned response
send and close
Unable to sync Invoice RF-12169. Please make sure all windows are closed inside QuickBooks and try the sync again. If the problem continues, you may need to reboot your computer and run Quickbooks with no open windows before running the sync again.
- This has nothing to do with windows open in QuickBooks. The sync couldn't process the refund for some reason.
- Request customer balance by using the appropriate canned response
- (TICKET 110372)
Object "884BF-1554761035" specified in the request cannot be found.
- Could be just a missing invoice or customer but those usually give a different error.
- In-store credit payments on an invoice can cause the sync to choke. It can't apply the payment for some reason. The payments and/or in-store credits will typically exist in their accounting software but the sync can't apply them to the invoice
- Review the payment in question.
- If the payment includes in-store credit:
- Request customer balance
- confirm that all related transactions exist in their accounting software
- set map on the failed payment
- using Excel, find all transactions involved in getting their accounting software to match to CoreBridge and put them together
- confirm that when you add the transactions together that they really match CoreBridge (this is a final check before responding)
- Add canned response: "Invoice Payment - Object specified in the request cannot be found - ISC"
- fill in the blanks
- For the Excel transactions, add a screenshot or copy & paste from Excel