O'Reilly logo

Microsoft Dynamics NAV by Mark Brummel, Christopher Studebaker, David Studebaker, David Roys, Vjekoslav Babić, Cristina Nicolàs Lorente, Laura Nicolàs Lorente, Alex Chow

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Converting data from the old system to Dynamics NAV's needs

The company's legacy system will probably have a very different data structure. However, in the meantime, a conversion process must be done. In this section, we'll explain a few tips to convert data to meet Dynamics NAV's needs.

In most of the Dynamics NAV tables (including all master and document tables), the primary key uses a code field type. The code field type is alphanumeric and is stored in the database in uppercase characters. You can write either numbers or characters in a Code field. If a code contains only numbers, people expect the data to be ordered by a number. But Dynamics NAV does not act this way. A code is always sorted by a character, even if it only contains numbers. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required