Index for Table xyz Not Unique

Overview

You have an error in the QQube Synch log:

***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 most likely 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. Reload your QuickBooks data afterwards.

Then reload your QuickBooks data afterwards using the run all / clear all options.

It is only necessary to reload the Financial Summary Reports

Cause 2. There is only one way to fix this, and that is to reload the QQube Database from scratch as shown in the picture above using the Run All / Clear All options.

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.

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.