The current version of Microsoft Dynamics NAV is the result of much inspiration and hard work along with some good fortune and excellent management decision making over the last quarter century or so.

Three college friends, Jesper Balser, Torben Wind, and Peter Bang, from Denmark Technical University (DTU) founded their computer software business in 1984 when they were in their early twenties. That business was Personal Computing & Consulting (PC & C) and its first product was called PC Plus.

PC Plus was released in 1985 with a primary goal of ease of use. An early employee said its functional design was inspired by the combination of a manual ledger journal, an Epson FX 80 printer, and a Canon calculator. Incidentally, Peter Bang is the grandson of one of the founders of Bang & Olufsen, the manufacturer of home entertainment systems par excellence.

PC Plus was PC DOS-based, a single user system. PC Plus' design features included the following:

The PC Plus product was marketed through dealers in Denmark and Norway.

In 1987, PC & C released a new product, the multi-user Navigator and a new corporate name, Navision. Navigator was quite a technological leap forward. It included:

In 1990, Navision was expanding its marketing and dealer recruitment efforts into Germany, Spain, and the United Kingdom. Moreover, in 1990, V3 of Navigator was released. Navigator V3 was still a character-based system, albeit a very sophisticated one. If you had an opportunity to study Navigator V3.x, you would instantly recognize the roots of today's NAV product. By this time, the product included:

When Navigator V3.5 was released, it also included support for multiple platforms and multiple databases. Navigator V3.5 would run on both Unix and Windows NT networks. It supported Oracle and Informix databases as well as the one that was developed in-house.

At about this time, several major strategic efforts were initiated. On the technical side, the decision was make to develop a GUI-based product. The first prototype of Navision Financials (for Windows) was shown in 1992. At about the same time, a relationship was established that would take Navision into distribution in the United States. The initial release in the US in 1995 was V3.5 of the character-based product, rechristened Avista for US distribution.

In 1995, Navision Financials V1.0 for Microsoft Windows was released. This product had many (but not all) of the features of Navigator V3.5. It was designed for complete look and feel compatibility with Windows 95. There was an effort to provide the ease of use and flexibility of development of Microsoft Access. The new Navision Financials was very compatible with Microsoft Office and was thus sold as "being familiar to any Office user". Like any V1.0 product, it was fairly quickly followed by a V1.1 that worked much better.

In the next few years, Navision continued to be improved and enhanced. Major new functionalities were added:

Various Microsoft certifications were obtained, providing muscle to the marketing efforts. Geographic and dealer base expansion continued apace. By 2000, according to the Navision Annual Report of that year, the product was represented by nearly 1,000 dealers (Navision Solution Centers) in 24 countries and used by 41,000 customers located in 108 countries.

In 2000, Navision Software A/S and its primary Danish competitor, Damgaard A/S, merged. Product development and new releases continued for the primary products of both original firms (Navision and Axapta). In 2002, the now much larger Navision Software, with all its products (Navision, Axapta, and the smaller, older C5 and XAL) was purchased by Microsoft, becoming part of the Microsoft Business Systems division along with the previously purchased Great Plains Software business and its several product lines. Since that time, one of the major challenges for Microsoft has been to meld these previously competitive businesses into a coherent whole. One aspect of that effort was to rename all the products as Dynamics software, with Navision being renamed to Dynamics NAV.

Fortunately for those who have been working with Navision, Microsoft has not only continued to invest in the product, but has increased the investment. This promises to be the case for the foreseeable future.

As early as 2003, research began with the Dynamics NAV development team planning moves to further enhance NAV, taking advantage of various parts of the Microsoft product line. Goals were defined to increase integration with products such as Microsoft Office and Microsoft Outlook. Goals were also set to leverage the functional capabilities of Visual Studio and SQL Server, among others. All the while, there has been a determination not to lose the strengths and flexibility of the base product.

This was a massive change that required almost a complete rewrite of the underlying code, the foundation that's normally not visible to the outside world. To accomplish that while not destroying the basic user interface, the business application model, or the development environment, was a major effort. The first public views of this new version of the system, a year or two later, were not greeted with universal enthusiasm from the NAV technical community. But the Dynamics NAV development persevered and Microsoft continued supporting the investment, until NAV 2009 was released in late 2008. With the addition of Service Pack 1 in mid-2009, the biggest hurdles to the new technologies have been cleared. More new capabilities and features are yet to come, taking advantage of all these efforts.

The new product will take ever-increasing advantage of SQL Server technologies. Development will become more and more integrated with Visual Studio and be more and more .NET compliant. The product is becoming more open and, at the same time, more sophisticated, supporting features like Web Services access, integration of third-party controls, RDLC reporting, and so on. In our industry, it would be appropriate to say To survive is to change. Change and survive are part of what Dynamics NAV does very well.

One of the first questions often asked by developers and development managers new to C/AL is What other language is it like? The proper response is "Pascal". If the questioner is not familiar with Pascal, the next best response would be "C" or "C#".

At the time the three founders of Navision were attending classes at Denmark Technical University (DTU), Pascal was in wide use as a preferred language not only in computer courses, but in other courses where computers were tools and software had to be written for data analysis. Some of the strengths of Pascal as a tool in an educational environment also served to make it a good model for Navision's business applications development.

Perhaps coincidentally (perhaps not) at DTU in this same time period, a Pascal compiler called Blue Label Pascal was developed by Anders Hejlsberg. That compiler became the basis for what was Borland's Turbo Pascal, which was the "every man's compiler" of the 1980s because of its low price. Anders went with his Pascal compiler to Borland. While he was there, Turbo Pascal morphed into the Delphi language and IDE tool set under his guidance.

Anders later left Borland and joined Microsoft, where he led the C# design team. Much of the NAV-related development at Microsoft is now being done in C#. So the Pascal-C/AL-DTU connection has come full circle, only now it appears to be C#-C/AL. Keeping it in the family, Anders' brother, Thomas Hejlsberg also works at Microsoft on NAV and AX at the campus in Copenhagen. Each in their own way, Anders and Thomas continue to make significant contributions to Dynamics NAV.

In a discussion about C/AL and C/SIDE, Michael Nielsen of Navision and Microsoft, who developed the original C/AL compiler, runtime, and IDE, said that the design criteria were to provide an environment that could be used without:

Paraphrasing some of Michael's additional comments, the language and IDE design was to:

Michael is still working as part of the Microsoft team in Denmark on new capabilities for NAV; this is another example of how, once part of the NAV community, most of us want to stay part of that community.

This book will not teach you programming from scratch, nor will it tutor you in business principles. To get the maximum out of this book, you should come prepared with some significant experience and knowledge. You will benefit most if you already have the following attributes:

If you have those attributes, then by careful reading and performance of the suggested exercises in this book, you should significantly reduce the time it will take you to become productive with C/AL and NAV. Those who don't have all these attributes, but want to learn about the development technology of Dynamics NAV, can still gain a great deal by studying Chapter 1 in detail and other chapters as the topics appear to apply to their situation.

This book's illustrations are from the W1 Cronus database V2009 SP1.

Hopefully this book will smooth the path to change and shine a little light on some of the challenges and the opportunities alike. Your task is to take advantage of this opportunity to learn, to change, and then use your new skills productively.

Chapter 1, A Short Tour through NAV 2009, covers basic definitions as they pertain to NAV and C/SIDE. In addition, an introduction to eight types of NAV objects, Page and Report Creation Wizards, and tools that we use to integrate NAV with external entities is provided. There is a brief discussion of how backups and documentation are handled in C/SIDE.

Chapter 2, Tables, focuses on the top level of NAV data structure: tables and their structures. You will work your way through hands-on creation of a number of tables in support of an example application. We will review most types of tables found in the out of the box NAV application.

In Chapter 3, Data Types and Fields for Data Storage and Processing, you will learn about the basic building blocks of NAV data structure, fields and their attributes, data fields that are available, and field structure elements (properties, triggers) for each type of field. This chapter covers the broad range of Data Type options as well as Field Classes. We will also discuss the concept of filtering and how it can be considered as you design your database structure.

In Chapter 4, Pages—Tools for Data Display, we will review different types of pages, work with some of these, and review all the controls that can be used in pages. You will learn to use the Page Wizard and have a good introduction to the Page Designer. You will expand your example system, creating a number of forms for data maintenance and inquiry.

In Chapter 5, Reports, we will learn about the structural and layout aspects of NAV Report objects using both the Classic Report Designer and the Visual Studio Report Designer. In addition, you will be experimenting with some of the tools and continue to expand your example application.

Chapter 6, Introduction to C/SIDE and C/AL, will help you learn about the general Object Designer Navigation as well as more specific Navision individual (Table, Form/Page, Report) Designers. This chapter also covers variables of various types created and controlled by the developer or by the system, basic C/AL syntax and some essential C/AL functions.

Chapter 7, Intermediate C/AL, covers a number of practical tools and topics regarding C/AL coding and development. You will learn about the C/AL Symbol Menu and how it assists in development. This chapter also discusses various Computation, Validation and Data Conversion functions, Dates, FlowFields and SIFT, Processing Flow Control, Input-Output, and Filtering functions.

In Chapter 8, Advanced NAV Development Tools, we will review some of most important elements of the Role Tailored User Experience, in particular Role Center Page construction. In addition, we will cover a number of tools and techniques aimed at making the life of a NAV developer easier and more efficient.

Chapter 9, Extend, Integrate, and Design—into the Future, covers a variety of interfaces, with special emphasis on XMLports and Web Services. It also discusses designing NAV modifications, creating a new functional area, or enhancing an existing functional area. Finally, this chapter provides tips for design efficiency, updating and upgrading the system, all with the goal of helping you to be a more productive NAV developer.

You will need some basic tools, including at least the following:

If you have access to other NAV manuals, training materials, websites, and experienced associates, those will obviously be of benefit as well. But they are not required for your time with this book to be a worthwhile investment.

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "Transactions are entered into a Journal table; data is preliminarily validated as it is entered, master and auxiliary data tables are referenced as appropriate."

A block of code is set as follows:

http://localhost:7047/DynamicsNAV/WS/Services
http://Isaac:7047/DynamicsNAV/WS/CRONUS_International_Ltd/Services

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "clicking on the Next button moves you to the next screen".

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an email to <[email protected]>, and mention the book title via the subject of your message.

If there is a book that you need and would like to see us publish, please send us a note in the SUGGEST A TITLE form on www.packtpub.com or email <[email protected]>.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book on, see our author guide on www.packtpub.com/authors.

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.