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)

Data items based on temporary tables

In all reports created in this chapter, we took data directly from a table and mapped table fields to report UI elements. But this is not always possible; complicated analysis reports often require aggregated data that cannot be simply extracted from a table, but requires preprocessing.

In the next example, we will create a report presenting a list of customers with quarterly payment amounts calculated for each customer. This information is not stored anywhere in the database; amounts have to be calculated and stored in a temporary table.

Create a report, 50502 Quarterly Payments. The following table lists the global variables required in the report. Declare these variables in C/AL Globals:

...
Name DataType Subtype
TempCustomer Record Customer
TempCustomerPayment Record Customer Payment
StartingDate Date
EndingDate Date
EntryNo