Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag South Korea
Country selected
country flag Turkey
Country selected
country flag Switzerland
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Chile
Country selected
country flag Norway
Country selected
country flag Ecuador
Country selected
country flag Indonesia
Country selected
country flag New Zealand
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag Austria
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag South Africa
Country selected
country flag Malaysia
Country selected
country flag Japan
Country selected
country flag Slovakia
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Home > Business & Other > Enterprise Resource Planning > Extending Microsoft Dynamics NAV 2016 Cookbook
Extending Microsoft Dynamics NAV 2016 Cookbook
Extending Microsoft Dynamics NAV 2016 Cookbook

Extending Microsoft Dynamics NAV 2016 Cookbook: Extend Dynamics NAV 2016 to win the business world

Arrow left icon
Profile Icon Alexander Drogin
Arrow right icon
€45.99
Full star icon Full star icon Full star icon Full star icon Empty star icon 4 (1 Ratings)
Paperback Jan 2017 458 pages 1st Edition
eBook
€24.99 €36.99
Paperback
€45.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Alexander Drogin
Arrow right icon
€45.99
Full star icon Full star icon Full star icon Full star icon Empty star icon 4 (1 Ratings)
Paperback Jan 2017 458 pages 1st Edition
eBook
€24.99 €36.99
Paperback
€45.99
Subscription
Free Trial
Renews at €18.99p/m
eBook
€24.99 €36.99
Paperback
€45.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Extending Microsoft Dynamics NAV 2016 Cookbook

Chapter 2. Advanced C/AL Development

In this chapter we will cover the following recipes:

  • Creating custom tables
  • Understanding database triggers
  • Implementing a user interface with pages
  • Linking datasources in subpages
  • Working with page triggers
  • Presenting related data in FactBoxes
  • Designing reusable code
  • Accessing temporary tables
  • Role-Tailored client and role centers
  • Assigning role centers to user profiles
  • Simplifying data access with queries
  • Improving performance with table indexes
  • Linking datasources with advanced queries
  • Exchanging data with XMLPort objects
  • Designing user menu
  • Referencing records and fields via RecordRef and FieldRef
  • Working with single instance codeunits
  • Running tasks in background sessions

Introduction

Each object type in Dynamics NAV has a designer associated with it. So far, we dealt with only one type - codeunit designer where you could write C/AL code. But different tasks, such as describing a table structure or designing a user interface in pages, require different tools. In this chapter we will have a closer look at all types of object designers presented in NAV development environment.

To make all the examples consistent, recipes in this chapter are presented in a form of a small add-on, each recipe expanding its functionality. We will see how to create a data model, present data in pages, move common code into codeunits, and create custom menus and a role center for the add-on.

Examples will be centered around a fictitious company selling goods that require a quality certificate to be sold. We will create a solution to store certificates, keep track of their validity, and block sales documents posting for items with an expired or invalid certificate.

Creating custom tables

Data is the core of any business application. We will start developing our solution from designing the data model. The first recipe will show how to create custom tables, set up field references and configure FlowFields that are calculated by the NAV platform based on table data.

How to do it...

In this recipe, we design the data model for the solution.

  1. Open Object Designer and select Table in the list of object types. Click New. Table designer will open.
  2. Each table field must have a number, a name, and a data type. Number 1 is already assign automatically. In the Field Name field enter No. and choose Code as Data Type. Finally, enter 20 in Length. This will create a Code[20] field.
  3. Move to the next empty line. Field No. will automatically increment. Enter CA Code in Field Name, Code in Data Type, and 20 in Length.
  4. Create other fields as given in the following table:

    Field No.

    Field Name

    Data Type

    Length

    1

    No.

    Code

    20

    2

    CA Code

    Code

    20

    3

    Item No...

Understanding database triggers

Data in the database is constantly changed - records are inserted, updated, deleted. Almost any user action results in data modification, and all modifications of data run application triggers.

How to do it...

In this recipe we will learn how to use some of the most important and frequently used table triggers to control data flow.

  1. Open table 50010 Item Certificate in object designer. Click C/AL Code in the View menu or press F9 to open table code. Open C/AL Globals and create two functions, DeleteCertificateActions and UpdateItemOnActions.
  2. Position cursor in the DeleteCertificateActions variable and declare a local record variable ItemCertificateAction:

    Name

    DataType

    Subtype

    ItemCertificateAction

    Record

    Item Certificate Action

  3. This is a simple function with lines of code in it:
            ItemCertificateAction.SETRANGE("Certificate No.","No."); 
        ItemCertificateAction.DELETEALL;
  4. Move to the function UpdateItemOnActions...

Implementing a user interface with pages

The foundation of the user interface in Dynamics NAV, is the Page object. Pages can be used to represent table data, receive user input, and exhibit actions buttons.

C/AL code can be executed in pages to format data and process data received from the input.

How to do it...

In this recipe, we will implement the user interface based on pages, and write C/AL code formatting data in the page.

  1. In the object designer, select Page in the object types list and Click on New -- this action button will open the page designer.
  2. In the Table field of the page wizard, select table 50010 Item Certificate as the source table for the page, or just enter its name or ID manually.
  3. Chose Create a page using wizard option and select Card in the list of page types. Click OK:

    How to do it...

  4. Next step in the wizard will suggest you to create FastTabs on the page. Leave one tab named General, as per the default setup, then click Next.
  5. In the next step, we select table fields that will...

Linking datasources in subpages

Subpages are used to present related information linked to the master record shown in the page. A document header displayed in the main page with linked lines in a subpage is a typical example.

Subpage always has a rule linking it to its master page, and it is always updated in response to any action in the master page. In NAV 2016 it is possible to update the master page after modifying data in a subpage.

How to do it...

In current recipe, we will create a subpage presenting the list of actions performed on a certificate.

  1. Create a new page in object designer.
  2. Set table 50012 Item Certificate Action as a source table for the new page.
  3. Choose the Create a page using a wizard option and select the ListPart page type.
  4. Select the following fields to be presented in the page:
    • Action Date
    • Action Type
    • Expiration Date

  5. Finish and save as page 50012 Item Certificate Subform.
  6. Design the page 50010 Item Certificate Card and add a line below the last field:
    • Type =...

Introduction

Each object type in Dynamics NAV has a designer associated with it. So far, we dealt with only one type - codeunit designer where you could write C/AL code. But different tasks, such as describing a table structure or designing a user interface in pages, require different tools. In this chapter we will have a closer look at all types of object designers presented in NAV development environment.

To make all the examples consistent, recipes in this chapter are presented in a form of a small add-on, each recipe expanding its functionality. We will see how to create a data model, present data in pages, move common code into codeunits, and create custom menus and a role center for the add-on.

Examples will be centered around a fictitious company selling goods that require a quality certificate to be sold. We will create a solution to store certificates, keep track of their validity, and block sales documents posting for items with an expired or invalid certificate.

Creating custom tables

Data is the core of any business application. We will start developing our solution from designing the data model. The first recipe will show how to create custom tables, set up field references and configure FlowFields that are calculated by the NAV platform based on table data.

How to do it...

In this recipe, we design the data model for the solution.

  1. Open Object Designer and select Table in the list of object types. Click New. Table designer will open.

  2. Each table field must have a number, a name, and a data type. Number 1 is already assign automatically. In the Field Name field enter No. and choose Code as Data Type. Finally, enter 20 in Length. This will create a Code[20] field.

  3. Move to the next empty line. Field No. will automatically increment. Enter CA Code in Field Name, Code in Data Type, and 20 in Length.

  4. Create other fields as given in the following table:

    Field No.

    Field Name

    Data Type

    Length

    1

    No.

    Code

    20

    2

    CA Code

    Code

    20

    3

    Item No.

    Code...

Understanding database triggers

Data in the database is constantly changed - records are inserted, updated, deleted. Almost any user action results in data modification, and all modifications of data run application triggers.

How to do it...

In this recipe we will learn how to use some of the most important and frequently used table triggers to control data flow.

  1. Open table 50010 Item Certificate in object designer. Click C/AL Code in the View menu or press F9 to open table code. Open C/AL Globals and create two functions, DeleteCertificateActions and UpdateItemOnActions.

  2. Position cursor in the DeleteCertificateActions variable and declare a local record variable ItemCertificateAction:

    Name

    DataType

    Subtype

    ItemCertificateAction

    Record

    Item Certificate Action

  3. This is a simple function with lines of code in it:

            ItemCertificateAction.SETRANGE("Certificate No.","No."); 
        ItemCertificateAction.DELETEALL;

  4. Move to the function UpdateItemOnActions. Declare a local...

Implementing a user interface with pages

The foundation of the user interface in Dynamics NAV, is the Page object. Pages can be used to represent table data, receive user input, and exhibit actions buttons.

C/AL code can be executed in pages to format data and process data received from the input.

How to do it...

In this recipe, we will implement the user interface based on pages, and write C/AL code formatting data in the page.

  1. In the object designer, select Page in the object types list and Click on New -- this action button will open the page designer.

  2. In the Table field of the page wizard, select table 50010 Item Certificate as the source table for the page, or just enter its name or ID manually.

  3. Chose Create a page using wizard option and select Card in the list of page types. Click OK:

  4. Next step in the wizard will suggest you to create FastTabs on the page. Leave one tab named General, as per the default setup, then click Next.

  5. In the next step, we select table fields that will be presented...

Linking datasources in subpages

Subpages are used to present related information linked to the master record shown in the page. A document header displayed in the main page with linked lines in a subpage is a typical example.

Subpage always has a rule linking it to its master page, and it is always updated in response to any action in the master page. In NAV 2016 it is possible to update the master page after modifying data in a subpage.

How to do it...

In current recipe, we will create a subpage presenting the list of actions performed on a certificate.

  1. Create a new page in object designer.

  2. Set table 50012 Item Certificate Action as a source table for the new page.

  3. Choose the Create a page using a wizard option and select the ListPart page type.

  4. Select the following fields to be presented in the page:

    • Action Date

    • Action Type

    • Expiration Date

  5. Finish and save as page 50012 Item Certificate Subform.

  6. Design the page 50010 Item Certificate Card and add a line below the last field:

    • Type = Part

    • SubType...

Working with page triggers

Page triggers are used to change the way page data is presented to the user. In this recipe, we will use triggers to calculate a value that will be displayed in the page "on-the-fly", when a record in retrieved from the database. Besides, trigger code will update the style of text boxes depending on the data displayed in them.

How to do it...

To illustrate the data presentation in a page, we write page trigger code highlighting expired certificates to draw user's attention to entries demanding immediate action.

  1. Open the page 50010 Item Certificate Card in page designer. Declare a global variable ExpirationDate of the Date type.

  2. Insert a new field in the General group, just below the field Issued Date. Set SourceExpr = ExpirationDate to make the ExpirationDate variable as the data source for the new field.

  3. Open the C/AL Code page. Declare a function GetCertificateExpirationDate.

  4. Open function parameters and add one parameter:

    Name

    DataType

    Length

    CertificateNo...

Presenting related data in FactBoxes

FactBoxes are subpages presenting information related to the main page, but considered less important than the main content. This is an auxiliary page that can be minimized or completely removed from the view when it is not needed.

How to do it...

This recipe creates a FactBox to present information about item certificates in sales orders.

  1. Create a new page in page designer.

  2. Select the table 50010 Item Certificate as a source for the page. Choose Create a page using a wizard option and select the page type CardPart.

  3. Add fields to the page:

    • No.

    • Certification Authority

    • Issued Date

  4. The FactBox page must display the certificate expiration date the same way as it is shown in the Item Certificate Card page. In the next recipe we will see how to reuse the function we already have in page 50010. For now, let's copy the function to the new page.

  5. Declare two global variables: ExpirationDate of type Date and IsCertificateOverdue of type Boolean.

  6. Close variable declarations...

Designing reusable code

Code modules in NAV are called codeunits. A codeunit does not have any user interface; the only purpose of a codeunit object is to store application code that can be called from other objects.

How to do it...

Now we will create a codeunit that will store functions common for objects in the current chapter, and move duplicated code from different objects into the codeunit.

  1. Create a new codeunit in object designer. Save it as codeunit 50010 Item Certificate Mgt.

  2. Declare a global function GetCertificateExpirationDate.

  3. Select the function in C/AL Globals list and open its properties. By default, property Local is set to Yes. Change it to No to make the function accessible from other objects.

  4. Open function parameters in C/AL Locals and declare one parameter:

    Name

    Type

    Length

    CertificateNo

    Code

    20

  5. Still in C/AL Locals, add a local variable to the function:

    Name

    DataType

    Subtype

    ItemCertificateAction

    Record

    Item Certificate Action

  6. Change the function...

Accessing temporary tables

Temporary tables, created in server memory instead of the database, are widely used to store the interim results of complex calculations. Temp tables can be used as buffers for data presented to the user, when the dataset cannot be obtained directly from a table.

An example of such dataset can be a list of certificates issued or prolonged in the past year, that have not been revoked and not yet expired. While it is possible to construct a SQL query that will collect this data from a join of several tables, C/AL code for this task will be a little more intricate and requires a temporary storage for the records.

How to do it...

In this recipe, a temporary table is used to store a list of certificates collected in a C/AL function. The table will be used as a data source for a page to present the data to the user.

  1. Edit the codeunit 50010 Item Certificate Mgt. and declare a global function CollectProlongedNotRevokedCertificates. To allow the function to be called from other...

Role-Tailored client and role centers

Role center is a special type of page created through the page designer. Usually role centers include a number of subpages.

Typical role center is not a single page, but a container with a number of subbpages presenting different dataset under various angles. Therefore, creating and configuring a role center may be a complicated task that requires creating many auxiliary tables and pages.

How to do it...

In this recipe, we will develop a role center for our custom solution to present the most important information in one screen.

  1. Create a table with the following fields:

    Field No.

    Field Name

    Data Type

    Length

    Field Class

    1

    Primary Key

    Code

    10

    Normal

    2

    Certificates - Total

    Integer

    FlowField

    3

    Certificates - Issued

    Integer

    FlowField

    4

    Certificates - Revoked

    Integer

    FlowField

    5

    Date Filter

    Date

    FlowFilter

    6

    Future Period Filter

    Date

    FlowFilter

  2. Select field 2 Certificates - Total and change its CalcFormula property to...

Assigning role centers to user profiles

The role center is the central access point to everyday tasks for the user. This is what he or she will see first when launching the application, and the role center page should be configured accordingly. Role centers are assigned to users in agreement with their roles in the organization.

Getting ready

In this recipe you will assign the role center created in the previous demo, to a user profile. In order to do it, you will need all object from the Role-Tailored client and role centers recipe imported and compiled.

How to do it...

Now we will assign the custom role center to a user account to make it the user's homepage:

  1. In the application menu, open /Departments/Administration/Application Setup/RoleTailored Client/Profiles, or type Profiles in the Search field and select the Profiles page in the search results.

  2. In the Profiles page, click New to create a new user profile.

  3. Enter profile ID. Name CERT MANAGER and Certification Manager in the Description.

  4. Click...

Simplifying data access with queries

Structures of NAV client application language allow accessing only one table at a time, there is no C/AL structure that would enable a table join in one statement. This limitation often affects the performance of C/AL code, forcing the developer to use loops on table records where a single query would be sufficient. With a Query object, developers can overcome this limitation and create queries joining several tables.

How to do it...

In this recipe, we will create a query object calculating profit per item, and use the query as a data source for a page.

  1. In the first step, we will add a field to the Item table that will specify if an item certificate is required to post an item entry. Open the table 27 Item in table designer and insert the field:

    Field No.

    Field Name

    Data Type

    50100

    Certificate Required

    Boolean

  2. Save the modification in the table. Switch to the page designer and open the page 30 Item Card. Insert the field Certificate Required in...

Improving performance with indexes

Selecting data from a large table with millions of records can be a very slow process when records are scanned directly. A good index can drive search queries many times faster. We will see how to control table indexed from the NAV development environment.

How to do it...

This recipe shows how to create indexes in a table to improve the performance of queries from the previous recipe.

  1. In the list of keys, move to the empty line below the primary key No. and click the assist button on the right.

  2. Open table 50010 Item Certificate in object designer and click View | Keys.

  3. In the Fields List window, add two fields to the index:

    • Item No.

    • CA Code

  4. Click OK, then close key's list and save the table:

  5. Open table 5802 Value Entry in table designer, go to key's definition.

  6. Add a key containing two fields: Item No. and Certificate No..

    Certificate No. is a custom field added in the recipe Creating Custom Tables.

  7. Click the assist button in the SumIndexFields field and add two...

Linking datasources with advanced queries

The data item property DataItemLinkType specifies how the tables will be joined in the query. Besides two basic types, there is an option that allows the developer to enable advanced options and perform right outer joins, full outer joins, and cross joins.

How to do it...

In this recipe , we will build a Query object with full outer join between two tables to see detailed information on customer discount groups configuration:

  1. Create a Query object in object designer.

  2. Insert a data item with the Customer table as data source.

  3. Include two columns from the Customer table: No. and Name.

  4. Add another data item Customer Discount Group.

  5. Include two fields from the Discount group: Code and Description:

  6. Open the properties for customer discount group data item and choose SQL Advanced Options in the DataItemLinkType property.

  7. The new property, SQLJoinType will become available. Select FullOuterJoin.

  8. Open link editor in the DataItemLink property and configure the link...

Left arrow icon

Page 1 of 20

Right arrow icon
Download code icon Download Code

Key benefits

  • •Extend Dynamics in a cost-effective manner by using tools that are ready at your disposal
  • •Solve common business problems with the valuable features and flexibility of Dynamics NAV
  • •Follow practical and easy-to-grasp examples, illustrations, and coding to make the most out of Dynamics NAV in your organisation

Description

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. Its integrated development environment enables customizations with minimal disruption to business processes. The book starts explaining the new features of Dynamics NAV along with how to create and modify a simple module. Moving on, you will learn the importance of thinking beyond the boundaries of C/AL development and the possibilities opened by with it. Next, you will get to know how COM can be used to extend the functionalities of Dynamics NAV. You’ll find out how to extend the Dynamics NAV 2016 version using .NET interoperability and will see the steps required to subscribe to .NET events in order to extend Dynamics NAV. Finally, you’ll see the cmdlets available to manage extension packages. By the end of the book, you will have the knowledge needed to become more efficient in selecting the extending methods, developing and deploying them to the Dynamics NAV, and practicing the best practices.

Who is this book for?

This book is for Dynamics NAV developers and administrators who have a good knowledge level and understanding of Dynamics NAV application development and administration.

What you will learn

  • •Develop a module in Dynamics NAV using C/AL
  • •Build relationships with COM technologies
  • •Develop and integrate COM with Dynamics NAV 2016
  • •Call the framework members from C/AL
  • •Develop an event in the .NET framework and see how to subscribe to it using C/AL
  • •Automate the deployment into Dynamics NAV
  • •Develop Windows Client Control add-Ins
  • •Deploy your resource automatically from Visual Studio
  • •Install and Configure Windows Client Control add-Ins
  • •Integrate Dynamics NAV with Sharepoint
Estimated delivery fee Deliver to Netherlands

Premium delivery 7 - 10 business days

€17.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jan 19, 2017
Length: 458 pages
Edition : 1st
Language : English
ISBN-13 : 9781786460608
Vendor :
Microsoft
Category :
Business & Other
Languages :
C#
Concepts :
Enterprise Resource Planning
Tools :
Dynamics NAV

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Netherlands

Premium delivery 7 - 10 business days

€17.95
(Includes tracking information)

Product Details

Publication date : Jan 19, 2017
Length: 458 pages
Edition : 1st
Language : English
ISBN-13 : 9781786460608
Vendor :
Microsoft
Category :
Business & Other
Languages :
C#
Concepts :
Enterprise Resource Planning
Tools :
Dynamics NAV

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

Extending Microsoft Dynamics NAV 2016 Cookbook
Extending Microsoft Dynamics NAV 2016 Cookbook
Read more
Jan 2017 458 pages
Full star icon 4 (1)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €45.99
€24.99 €36.99
€45.99
Mastering Microsoft Dynamics NAV 2016
Mastering Microsoft Dynamics NAV 2016
Read more
Mar 2017 450 pages
Full star icon 3.3 (3)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €45.99
€24.99 €36.99
€45.99
Programming Microsoft Dynamics NAV
Programming Microsoft Dynamics NAV
Read more
Apr 2017 706 pages
Full star icon 4.3 (4)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €45.99
€24.99 €36.99
€45.99
Stars icon
Total € 137.97
Extending Microsoft Dynamics NAV 2016 Cookbook
€45.99
Mastering Microsoft Dynamics NAV 2016
€45.99
Programming Microsoft Dynamics NAV
€45.99
Total € 137.97 Stars icon

Table of Contents

10 Chapters
1. Writing Basic C/AL Code Chevron down icon Chevron up icon
1. Writing Basic C/AL Code
Introduction
Installing NAV Development Environment
Application object triggers
NAV Development Environment - C/SIDE
Compiling objects and error handling
Importing and exporting application objects
Basic C/AL programming
Accessing the database in C/AL
Configuring NAV Server
Configuring web server
2. Advanced C/AL Development Chevron down icon Chevron up icon
2. Advanced C/AL Development
Introduction
Creating custom tables
Understanding database triggers
Implementing a user interface with pages
Linking datasources in subpages
Working with page triggers
Presenting related data in FactBoxes
Designing reusable code
Accessing temporary tables
Role-Tailored client and role centers
Assigning role centers to user profiles
Simplifying data access with queries
Improving performance with indexes
Linking datasources with advanced queries
Exchanging data with XMLPort objects
Designing the user menu
Referencing records and fields via RecordRef and FieldRef
Working with single instance codeunits
Running tasks in background sessions
3. Reporting and Data Analysis Chevron down icon Chevron up icon
3. Reporting and Data Analysis
Introduction
Designing reports in Visual Studio
Developing Word layout for RDLC reports
Writing C/AL code in a report
Designing the report request page
Writing RDLC code in a report
Using built-in expressions in the report layout designer
Including user interaction in reports
Updating NAV data with the Excel add-in
Retrieving data from NAV with Power Query
Creating pivot tables with Power Query
Analyzing data with Power BI
Data hierarchies in Power BI reports
Statistical data analysis in Power BI with R
Sales forecast in Power BI with R
Designing server-side reports in SQL Server Reporting Studio
4. .NET Interoperability in C/AL Chevron down icon Chevron up icon
4. .NET Interoperability in C/AL
Introduction
Using .NET assemblies in C/AL
Understanding static classes and methods
Developing server-side extensions
Developing client-side extensions
Working with generics in C/AL
Working with interfaces
Accessing collections with the FOREACH statement
Working with .NET strings and arrays in C/AL
Invoking .NET methods via reflection
Handling exceptions with try functions
Handling .Net events in C/AL
Developing your own .NET class
Starting processes in separate threads
5. Extending C/AL with COM Components Chevron down icon Chevron up icon
5. Extending C/AL with COM Components
Introduction
Using COM type libraries in C/AL
Mapping COM datatypes to C/AL
Disposing of COM objects
Working with the Variant datatype
Sending data to the Excel automation server
Creating a Word document using automation objects
Creating and registering a COM component that can be used in NAV
6. SharePoint Integration Chevron down icon Chevron up icon
6. SharePoint Integration
Introduction
Creating a developer SharePoint site
Developing NAV apps for SharePoint
Embedding NAV page objects in site pages
Publishing NAV reports in SharePoint
Deploying applications on SharePoint
Configuring user permissions
7. Control Add-ins Chevron down icon Chevron up icon
7. Control Add-ins
Introduction
Developing a control add-in
Signing the control add-in assembly
Registering and embedding a control add-in
JavaScript in web, phone, and tablet clients
Installing and using JavaScript control add-ins
Sending events from add-ins to NAV server
Linking add-ins with the database
Exchanging data with add-ins
8. Web Services Chevron down icon Chevron up icon
8. Web Services
Introduction
Publishing a SOAP web service
Calling object methods in SOAP web services
Exposing and consuming OData web services
Querying NAV OData web services with LINQ
Updating NAV data through web services
Securing access to web services
Consuming the NAV web service from Java
9. Events and Extension Packages Chevron down icon Chevron up icon
9. Events and Extension Packages
Introduction
Subscribing to business and integration events
Subscribing to global events
Using database trigger events
Extending UI with page trigger events
Creating custom events
Subscribing to events in runtime
Developing an extension
Installing an extension
10. PowerShell Chevron down icon Chevron up icon
10. PowerShell
Introduction
Managing the database
Managing users and user permissions
Managing companies
Administering NAV services with PowerShell
Handling application objects
Merging application objects

Recommendations for you

Left arrow icon
Mastering PyTorch
Mastering PyTorch
Read more
May 2024 558 pages
Full star icon 4.7 (20)
eBook
eBook
  • eBook eBook €21.99
  • Paperback Paperback €38.99
€21.99 €31.99
€38.99
Microsoft 365 and SharePoint Online Cookbook
Microsoft 365 and SharePoint Online Cookbook
Read more
Feb 2024 640 pages
Full star icon 4.8 (23)
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €29.99
€15.99 €23.99
€29.99
Tools and Skills for .NET 8
Tools and Skills for .NET 8
Read more
Jul 2024 778 pages
Full star icon 5 (12)
eBook
eBook
  • eBook eBook €19.99
  • Paperback Paperback €35.99
€19.99 €28.99
€35.99
Information Theory
Information Theory
Read more
Nov 2024 294 pages
eBook
eBook
  • eBook eBook €4.99
€4.99 €7.99
The Music Producer's Ultimate Guide to FL Studio 21
The Music Producer's Ultimate Guide to FL Studio 21
Read more
Jun 2023 462 pages
Full star icon 5 (11)
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €29.99
€15.99 €23.99
€29.99
Workflow Automation with Microsoft Power Automate, Second edition
Workflow Automation with Microsoft Power Automate, Second edition
Read more
Aug 2022 424 pages
Full star icon 4.3 (36)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Mastering QuickBooks 2024
Mastering QuickBooks 2024
Read more
Dec 2023 570 pages
Full star icon 4.6 (19)
eBook
eBook
  • eBook eBook €13.99
  • Paperback Paperback €26.99
€13.99 €20.99
€26.99
Programming Microsoft Dynamics 365 Business Central
Programming Microsoft Dynamics 365 Business Central
Read more
Oct 2024 466 pages
Full star icon 5 (1)
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
€17.99 €26.99
€33.99
Unreal Engine 5 Character Creation, Animation, and Cinematics
Unreal Engine 5 Character Creation, Animation, and Cinematics
Read more
Jun 2022 598 pages
Full star icon 4.7 (16)
eBook
eBook
  • eBook eBook €32.99
  • Paperback Paperback €59.99
€32.99 €47.99
€59.99
Power Apps Tips, Tricks, and Best Practices
Power Apps Tips, Tricks, and Best Practices
Read more
Nov 2024 430 pages
Full star icon 4.5 (2)
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
€17.99 €26.99
€33.99
Right arrow icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
(1 Ratings)
5 star 0%
4 star 100%
3 star 0%
2 star 0%
1 star 0%
Colin G. Bradley Jan 01, 2018
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Written by a Russian speaker so don't expect perfect English grammar.That aside, it gives clues and in some cases, a lot of detail.To do the job as well as I would like would need several volumes I expect but have found answers to several tricky issues.Forums are still the first port of call for me but this is good to read in bed so you can dream of code or give yourself a list of things to try next day.
Amazon Verified review Amazon

People who bought this also bought

Left arrow icon
Workflow Automation with Microsoft Power Automate, Second edition
Workflow Automation with Microsoft Power Automate, Second edition
Read more
Aug 2022 424 pages
Full star icon 4.3 (36)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
101 UX Principles – 2nd edition
101 UX Principles – 2nd edition
Read more
May 2022 454 pages
Full star icon 4.7 (60)
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
  • Audiobook Audiobook €31.99
€17.99 €26.99
€33.99
€31.99
Mastering PostgreSQL 15
Mastering PostgreSQL 15
Read more
Jan 2023 522 pages
Full star icon 4.9 (7)
eBook
eBook
  • eBook eBook €25.99
  • Paperback Paperback €46.99
€25.99 €37.99
€46.99
Mastering Microsoft Dynamics 365 Business Central
Mastering Microsoft Dynamics 365 Business Central
Read more
Mar 2024 684 pages
Full star icon 4.9 (17)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Learn Blender Simulations the Right Way
Learn Blender Simulations the Right Way
Read more
Nov 2022 368 pages
Full star icon 4 (14)
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
€17.99 €26.99
€33.99
Right arrow icon

About the author

Profile icon Alexander Drogin
Alexander Drogin
Alexander Drogin started working with Navision Attain version 3.01 in 2002 as a software developer at a consulting company. After seven years of development, he shifted his focus to end-user support. In 2012, he joined the Microsoft Russia development team as a software engineer in testing, and worked on NAV test automation and sustained engineering tasks. He currently works as a NAV technical architect for a Microsoft partner in Malta.
Read more
See other products by Alexander Drogin
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the digital copy I get with my Print order? Chevron down icon Chevron up icon

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela