MS Dynamics NAV Decimal support changed (version 3.2.87x)
By Michael Bock - December 24, 2013
In order to get a more precise handling of Decimal fields (and avoid conversion to/from the Double data type) with MS Dynamics NAV (C/Front) connections, we now use a new developed NaviDecimal class to read/write BCD values from/to NAV. This is more compatible with MS-SQL Decimal read/write and give better precision and usually smaller data size to transfer.
The use of the new way can be controlled by cfg setting "NavisionUseDecimalForBCD" (default 1).
We also fixed error in DCDecimal equals so now Decimal fields compare correctly and only update if they are really different.
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.