Error: Keys for Inquiry... are not unique

Symptom

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

Velixo error message stating the keys for the inquiry are not unique with more than one row sharing the same key values

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:

Velixo Generic Inquiry Options showing only the TYPE field as the key which is insufficient to uniquely identify each Invoice or Memo

(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:

Velixo Generic Inquiry Options updated with both ReferenceNbr and Type as key fields to uniquely identify each Invoice or Memo

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

Acumatica Generic Inquiry result showing rows uniquely identified by the ReferenceNbr and Type field combination