When importing or syncing transactions to QuickBooks, such as invoices, sales receipts, or sales orders, the sync failed with the message:
Error 3100: When trying to add customer "...". QuickBooks Responded: The Name "..." of the list element is already in use.
When Connex is syncing transactions into QuickBooks and it find the Name (i.e. Customer name, Vendor name, Employee name, etc.) does not already exist in QuickBooks, it will attempt to create that Customer at the time of import. However, if the name already exists in another list in QuickBooks, then QuickBooks will not permit Connex to create that record and the related transaction will fail.
This is due to a QuickBooks software limitation, as it does not permit identical names.
- Example: A Customer and a Vendor with the same name, such as ACME Inc.; or a Customer and an Employee with the same name.
Look in QuickBooks within the Vendor Center, Employee users, or QuickBooks Other Names List. Ensure there are no other records with the same name.
The easiest way to remedy this is to edit the existing record in some way, such as adding an asterisk to the Vendor or Employee to differentiate the two records.
- Example: A Customer called ACME Inc. and a Vendor called *ACME Inc.
I fixed the issue record in QuickBooks. How do I re-sync the related sale(s)?
Now that things are fixed on the QuickBooks side, it's time to re-import or re-sync the related transaction. To do so: