Index for table xyz not unique | CLEARIFY

Index for Table XYZ would not be unique

You see an error in the log similar to this:

***OR***

***OR***

***OR***

Cause

There are four possible causes:

1. The first message listed above is the result of a 2001 bug in the Intuit Software Development Kit (SDK) which Intuit will probably never fix. And only occurs when Financial Summary Data Models - or Financial Summary by Class Data Models are chosen.
2. The second message listed above is the result of a limitation in the Intuit SDK, and is the result of merging items.  If the message above said mvd_Account, it would be the result of merging accounts.  Ditto for Customers, Vendors, Classes - or any list in QuickBooks.
3. The third message (it could be credit card charge/credit, bill, et.) listed most likely refers to cases where somebody has changed the name type, e.g. other name to vendor, or vendor to other name.  The Intuit SDK doesn't tell us when this occurs, so we end up with two records using the same Unique Identifier - and we don't know which is the correct one.
4. The fourth message is generally caused by an incorrect inventory/COGS entry within a Vendor Credit, if there is negative inventory or positive inventory.  

Resolution

Cause 1. Make sure that the Accounting Preferences setting "Show lowest subaccount only" is UNchecked, and that you Reload your QuickBooks data afterwards.

It is only necessary to re-load Financial Summary Data Models after correcting this item

Cause 2. There is only one way to fix this, and that is to reload the QQube Database from scratch as shown in the pictures at the bottom of this guide: Maintaining QuickBooks Data Integrity in QQube | CLEARIFY

Cause 3. Reload the QQube Database from scratch as indicated in Cause 2.  If you get the same error after rebuilding your QuickBooks file and reloading from scratch, please highlight the specific error log, and use the Send to CLEARIFY Support button to create a ticket, and get further instructions. QQube Synch Logs Are The Key to Success | CLEARIFY

Cause 4. Create a ticket following the information outlined here: QQube™ Support Options | CLEARIFY Submitting the log is the quickest way to create a ticket.  Our engineers will give you instructions on getting the QQube database from you, and in most cases get a copy of the QuickBooks file.  They will be able to tell you which offending transaction(s) need to be corrected.

NOTE: if we make arrangements to get a copy of your QB file, we are happy to sign any NDA for your organization.