Book Image

Implementing Microsoft Dynamics NAV - Third Edition

By : Alex Chow
Book Image

Implementing Microsoft Dynamics NAV - Third Edition

By: Alex Chow

Overview of this book

Microsoft Dynamics NAV 2016 is an Enterprise Resource Planning (ERP) application used in all kinds of organizations around the world. It provides a great variety of functionality out-of-the-box in different topics such as accounting, sales, purchase processing, logistics, or manufacturing. It also allows companies to grow the application by customizing the solution to meet specific requirements. This book is a hands-on tutorial on working with a real Dynamics NAV implementation. You will learn about the team from your Microsoft Dynamics NAV partner as well as the team within the customer’s company. This book provides an insight into the different tools available to migrate data from the client’s legacy system into Microsoft Dynamics NAV. If you are already live with Microsoft Dynamics NAV, this books talks about upgrades and what to expect from them. We’ll also show you how to implement additional or expanding functionalities within your existing Microsoft Dynamics NAV installation, perform data analysis, debug error messages, and implement free third-party add-ons to your existing installation. This book will empower you with all the skills and knowledge you need for a successful implementation.
Table of Contents (19 chapters)
Implementing Microsoft Dynamics NAV Third Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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. This may confuse the user, so using fixed-length number codes is recommended. Let's look at this with an example:

Number Sort

Dynamics NAV Sort

Fixed length Sort

1

1

01

2

10

02

3

2

03

10

3

10

As you can see, if you use fixed length codes...