Last week I had a problem with a client witch was that the export of dimensions on analysis view was wrong. After a lot of research I found the following detail. Navision sorting on Code field is different when the table is normal and when the table is temporary.
Lets say that we have a table with a key field (ID => Code 10). If we insert into table values ‘1000’, ‘1000-1’, ‘1001’ and we open the table we will see the following sorting
1000
1000-1
1001
If we create then a form with SourceTableTemporary = Yes on form properties
and insert the same values, the sorting will be like this
1000
1001
1000-1
