Module 1: DATA AND PROCESS MODEL
Module 2: MASTER TABLES AND PAGES
Module 3: DOCUMENTS
Module 4: POSTING
Module 5: FEATURE INTEGRATION
Module 6: REPORTING
Module 7: STATISTICS
Module 8: DIMENSIONS
Module 9: ROLE TAILORING
Module 10: INTERFACES
Module 11: WEB SERVICES
Module 12: TESTING AND DEBUGGING
Module 13: SQL SERVER OPTIMIZATION
- Lesson 1: SQL Server for Microsoft Dynamics NAV
- Lesson 2: Representation of NAV Tables and Indexes in SQL Server
- Lesson 3: Collation Options
- Lesson 4: SQL Server Query Optimizer
- Lesson 5: SQL Server Query Optimizer
- Lesson 6: Data Access Redesign
- Lesson 7: C/AL Database Functions and Performance on SQL Server
- Lesson 8: Bulk Inserts
- Lesson 9: Locking, Blocking, and Deadlocks
- Lesson 10: SIFT Data Storage in SQL Server
- Lesson 11: SQL Server Profiler
Lesson 1: Prerequisite Knowledge
Before you design and develop the solution for managing master data, you must review Microsoft Dynamics NAV 2013 standard functionality. In each module, this “Prerequisite Knowledge” lesson presents Microsoft Dynamics NAV 2013 standards and principles that you can apply while customizing the solution for CRONUS International Ltd.
Triggers are methods that execute when a system event occurs or when they are invoked by code. Following are two types of active triggers (triggers that contain executable code):
- Event Triggers have names that begin with “On…” and execute when specific events occur. For example, the OnInsert trigger executes when a user inserts a record in a table.
- Function Triggers are custom triggers that developers define. There are many function triggers that are defined as a part of the base application. You can add many more as part of your customization. These triggers execute when they are called by other C/AL code.
The Documentation Trigger is the third type of trigger. There is only one Documentation trigger per object, and anything that is written in it is not processed by the application, even if it contains C/AL code. It typically contains free-form documentation. This trigger lets you document the changes that you have made to objects. This chapter demonstrates how to use these triggers in various scenarios.
Microsoft Dynamics NAV 2013 is a multilanguage application. This means that a localized version of Microsoft Dynamics NAV 2013 can present itself in different languages. In other words, two or more RoleTailored clients that are connected to the same database can present their user interface in two or more languages at the same time. Users can change the language at any time, and the change is applied immediately.
To enable multilanguage functionality for your custom solutions, use the following guidelines:
- Always define the Name property of an object, a control, or a table field in English (United States), or ENU. You must make sure that this is never visible to the user, by specifying the Caption property.
- Always provide language-specific names in the CaptionML property of the objects, controls, or table fields.