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.

Preface

Who this book is for

What this book covers

To get the most out of this book

Free Chapter

Getting Started with the NAV Development Environment

Getting Started with the NAV Development Environment

Installing the NAV development environment

Managing NAV server configuration with Microsoft Management Console (MMC)

Managing NAV installation with NAV the Administration Shell

Introducing the Object Designer

Exporting and deploying NAV objects

Codeunits - Structuring C/AL Code

Codeunits - Structuring C/AL Code

Compiling a codeunit and error handling

Declaring and calling functions

Function parameters and return values

Declaring variables – variable scope

Passing variables by value and by reference

Record variables

Codeunit variables – calling functions from other codeunits

Tables - Creating Data Structure

Tables - Creating Data Structure

Designing the table structure

Defining the primary key and secondary indexes

Configuring default pages for tables

Table relations

Field class – Flowfields and Flowfilters

Rec and xRec global variables

Designing User Interface

Designing User Interface

Page creation wizard

ListPart and CardPart pages – subpages and FactBoxes

Page triggers – C/AL code in pages

Lookups and DrillDowns

Page action designer

Exchanging Data with XML Ports

Exchanging Data with XML Ports

Importing data from CSV files

Importing data from XML files

XMLport triggers

Exporting table data

Designing the request page

Running XMLports from C/AL code

NAV Event Model

NAV Event Model

Integration events

Database trigger events

Publishing custom events

Manual event subscription

Presenting Data in Reports

Presenting Data in Reports

Preparing a report dataset

Modeling a report layout

Report triggers

Designing a report request page

RDLC expressions

Interactive reports

Data items based on temporary tables

Debugging Your Code

Debugging Your Code

Activating the debugger

Conditional breakpoints

Variables – Watches – Callstack

Capturing code coverage

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Record variables

Record is one of the most important and widely used data types in C/AL code. A Record variable refers to a database table, and allows us to retrieve and manipulate table data. A code example in this section will demonstrate how to search data with a Record variable and update found records. This is a more business-related scenario than those we coded in previous sections. As an example, we will update sales prices for an item based on certain criteria calculated from other database tables.

Iterating over a recordset

To declare a Record variable, you must enter its name, select the Record data type in the DataType field, and choose one of the database tables as the variable's Subtype. In the next code...