Thursday, November 16, 2017

Smartlist Builder misbehaving on Go To

Using Dex in Dynamics GP 2015R2 I created a custom table and have a Smartlist created for this data.  There is an unique ID field for each record in the table and an index on that field.

When I created the Smartlist for this I wanted a GoTo that would open the inquiry window I created in Dex for this table.

When the form opened it sometimes displayed the right record, and sometimes did not.

I sorted for the form by a different column and found that it was returning the first in the sequence by that column.

I realized that it was likely the key of the Smartlist table was probably defined incorrectly.  When I adjusted that I received the correct result.

No comments:

Post a Comment