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***

Cause

There are three possible causes:

1. The first message listed above is the result of a 2001 bug in the Intuit Software Development Kit (SDK) that Intuit will probably never fix. And only occurs when Financial Summary Analytics - or Financial Summary by Class Analytics 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.

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 Analytics after correcting this item

Cause 2. There is only one way to fix this, and that is to reload the QQube Database from scratch: https://clearify.com/wiki/view/397/maintaining-data-integrity

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. https://clearify.com/wiki/view/257/synch-logs

NOTE: if it is something we have not seen before, we may make arrangements to get a copy of your file, including the signing of any requested NDA, and upload instructions.