Book Image

Implementing Microsoft Dynamics NAV 2013

By : Laura Nicolàs Lorente, Cristina Nicolàs Lorente
Book Image

Implementing Microsoft Dynamics NAV 2013

By: Laura Nicolàs Lorente, Cristina Nicolàs Lorente

Overview of this book

<p>Microsoft Dynamics NAV 2013 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 and purchases processing, logistics, or manufacturing. But it also allows companies to grow the application by customizing the solution to meet specific requirements.<br /><br />"Implementing Microsoft Dynamics NAV 2013" explains all you need to know to successfully handle your first Dynamics NAV 2013 implementation. You will learn what the application can do out of the box, how you can extend it to meet any kind of requirements, and how to manage real implementation projects with real customers.<br /><br />This book does not only cover typical topics when implementing the new version of an ERP system; topics that are not found in any previous documentation of Dynamics NAV, such as the implementation process at the customer side, or implementing functional changes on existing Dynamics NAV implementations are included in here. This approach makes this book different.<br /><br />After reading "Implementing Dynamics NAV 2013" you will be empowered with the skills and knowledge you need for successful implementations.</p>
Table of Contents (22 chapters)
Implementing Microsoft Dynamics NAV 2013
Credits
About the Authors
Acknowledgement
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

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


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

In most of the Dynamics NAV tables, the primary key uses a code field type. For example, all master and document tables do. 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 number. But Dynamics NAV does not act this way. A code is always sorted by character, even if it only contains numbers. This may confuse the user, so using fixed-length number codes is recommended. Let's see 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, the way these codes are sorted in Dynamics NAV is the same as the number sort. Therefore, we recommend...