MS Dynamics NAV automatically setting key (version 3.2.88g)
By Michael Bock - January 10, 2014
With MS Dynamics NAV (native or SQL based - C/Front only) and using SourceControl, it is important to use a key so that the records are read from the database in order of the SourceControl field. If this is not done and you have "Commit Per" set, then you risk missing some records if you run into errors in your transfer.
Before you had to manually ensure that a correct field was set in the "Sorting Source Table".
Now we automatically set the sorting to the SourceControl field on the native database and also when having an SQL based NAV database and not using the Timestamp as SourceControl.
version 3.2.88g (January 2014)
About the author
Michael founded Rapidi on technological excellence, fantastic customer service and continuous improvement. A data integration specialist since 1987, he remains focused on creating technology that solves real business problems.