Today I’ve spent some time in NAV2016 figuring out this error message:
As you know in NAV2016 you can sort on each column even if there is no key and even if it’s a flowfield. So why am I getting this error?
In my case the Test field is a Flowfield of the type COUNT to another table. This should work fine, so why doesn’t it work here.
Reason is that the SQL Data Type is Integer instead of VarChar. A very old trick to make a SQL Database sort a Code field just like the Native database.
The SQL Data Type in the “Other” table does not match this SQL Type hence the sorting fails.
Since I could not find any info online on this message I thought it was worth sharng.