Error: Keys for Inquiry... are not unique

Applies to:

• Velixo NX
• Velixo Classic
• Acumatica, Cegid, MYOB

Symptom

When using Generic Inquiry functions, the following error message is displayed:

Text from the Error Message:

The keys for inquiry {inquiry name} are not unique. More than one row encountered with the same keys...

Cause

When the keys were defined in the Velixo Generic Inquiries Options, the specified Key Fields for the specific Generic Inquiry are not sufficient to uniquely-identify each record in the database table:

(in this example, the TYPE field is not able to uniquely identify each Invoice and Credit Memo - multiple records can be of the same type)

Resolution

The Key Fields for the specific Generic Inquiry need to be modified so that they are sufficient to uniquely distinguish each record in the database table:

e.g., using the the combination of the RefernceNbr and Type fields is enough to identify any single Invoice or Memo: