Book Image

Learning Dynamics NAV Patterns

By : Marije Brummel
Book Image

Learning Dynamics NAV Patterns

By: Marije Brummel

Overview of this book

Microsoft Dynamics NAV is a complete ERP system, which also contains a robust set of development tools to support customization and enhancement. These include an object designer for each of the seven application object types, a business application-oriented programming language with .NET interface capability, a compiler, a debugger, and programming testing language support. Learning Dynamics NAV Patterns will guide you through the NAV way of solving problems. This book will first introduce you to patterns and the software architecture of the NAV and then help you to build an example application. Then, it walks you through the details of architectural patterns, design patterns, and implementation patterns. This book will also talk about anti-patterns and handling legacy code. Finally, it teaches you to build solutions using patterns. Proven patterns and best practices will help you create better solutions that are easy to maintain in larger teams across several locations. It will guide you through combining abstract patterns using easy-to-understand examples and will help you decide which patterns to use in which scenarios.
Table of Contents (9 chapters)
Thank you for buying Learning Dynamics NAV Patterns

The Entry Pattern

Most EARP systems are data cemeteries. A lot of data comes in, nothing much ever comes out. To store data in Microsoft Dynamics NAV, the Entry Pattern is most popular with over 75 implementations in the standard product.

Technical description

Although there are many variations, all entry tables have the same technical structure that can be expanded upon the functional requirements.

The Primary Key for all the entry tables is a field called Entry No. of the type Integer. The value of the field is determined using either the AutoIncrement property, or a code algorithm as the following:

IF NextEntryNo = 0 THEN BEGIN
    NextEntryNo := ExLedgEntry."Entry No.";
    NextEntryNo := NextEntryNo + 1;
WITH ExLedgEntry DO
  "Entry No." := NextEntryNo;

The following diagram explains how to implement the Entry Pattern:

Entry tables contain...