Book Image

Microsoft Dynamics NAV Development Quick Start Guide

By : Alexander Drogin
Book Image

Microsoft Dynamics NAV Development Quick Start Guide

By: Alexander Drogin

Overview of this book

Microsoft Dynamics NAV is an enterprise resource planning (ERP) software suite for organizations. The system offers specialized functionality for manufacturing, distribution, government, retail, and other industries. This book gets you started with its integrated development environment for solving problems by customizing business processes. This book introduces the NAV development environment – C/SIDE. It gives an overview of the internal system language and the most essential development tools. The book will enable the reader to customize and extend NAV functionality with C/AL code, design a user interface through pages, create role centers, and build advanced reports in Microsoft Visual Studio. By the end of the book, you will have learned how to extend the NAV data model, how to write and debug custom code, and how to exchange data with external applications.
Table of Contents (10 chapters)

Designing the table structure

NAV table objects are mapped to actual database tables; for each table in NAV, there is a corresponding table in the SQL Server database, and the NAV table designer is an interface for constructing table metadata that will be represented in database table fields.

The first table we will create is the contract header containing general information related to the contract: contract number, customer, and starting and ending dates.

Creating tables

To create a table, open the Object Designer and switch to the Table view; press the Table button in the left pane of the designer window. In the Table Designer, we create the new table by describing its fields line by line with the following metadata values...