Extending Microsoft Dynamics NAV 2016 Cookbook电子书

Extending Microsoft Dynamics NAV 2016 Cookbook

Extending Microsoft Dynamics NAV 2016 Cookbook

Credits

About the Author

About the Reviewer

www.PacktPub.com

Why subscribe?

Customer Feedback

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Getting ready

How to do it…

How it works…

There's more…

See also

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Writing Basic C/AL Code

Introduction

Installing NAV Development Environment

Getting ready

How to do it...

How it works...

Application object triggers

How to do it...

How it works...

NAV Development Environment - C/SIDE

How to do it...

How it works...

Compiling objects and error handling

How to do it...

How it works...

Importing and exporting application objects

How to do it...

How it works...

Basic C/AL programming

How to do it...

How it works...

Accessing the database in C/AL

How to do it...

How it works...

Configuring NAV Server

Getting ready

How to do it...

How it works...

Creating a NAV user account

Generating a self-signed certificate

Obtaining the certificate thumbprint

Changing the server configuration

Configuring web server

Getting ready

How to do it...

How it works...

There's more...

See also

2. Advanced C/AL Development

Introduction

Creating custom tables

How to do it...

How it works...

Understanding database triggers

How to do it...

How it works...

Implementing a user interface with pages

How to do it...

How it works...

Linking datasources in subpages

How to do it...

How it works...

Working with page triggers

How to do it...

How it works...

Presenting related data in FactBoxes

How to do it...

How it works...

Designing reusable code

How to do it...

How it works...

See also

Accessing temporary tables

How to do it...

How it works...

See also

Role-Tailored client and role centers

How to do it...

How it works...

Assigning role centers to user profiles

Getting ready

How to do it...

How it works...

Simplifying data access with queries

How to do it...

How it works...

Improving performance with indexes

How to do it...

How it works...

Linking datasources with advanced queries

How to do it...

How it works...

Exchanging data with XMLPort objects

How to do it...

How it works...

Designing the user menu

How to do it...

How it works...

Referencing records and fields via RecordRef and FieldRef

How to do it...

How it works...

Working with single instance codeunits

How to do it...

How it works...

Running tasks in background sessions

How to do it...

How it works...

See also

3. Reporting and Data Analysis

Introduction

Designing reports in Visual Studio

How to do it...

How it works...

Developing Word layout for RDLC reports

Getting ready

How to do it...

How it works...

There's more...

Writing C/AL code in a report

Getting ready

How to do it...

How it works...

Designing the report request page

Getting ready

How to do it...

How it works...

Writing RDLC code in a report

Getting ready

How to do it...

How it works...

Using built-in expressions in the report layout designer

Getting ready

How to do it...

How it works...

Including user interaction in reports

Getting ready

How to do it...

How it works...

Updating NAV data with the Excel add-in

Getting ready

How to do it...

How it works...

Retrieving data from NAV with Power Query

Getting ready

How to do it...

How it works...

Creating pivot tables with Power Query

Getting ready

How to do it...

Analyzing data with Power BI

Getting ready

How to do it...

How it works...

Data hierarchies in Power BI reports

How to do it...

Statistical data analysis in Power BI with R

Getting ready

How to do it...

How it works...

Sales forecast in Power BI with R

Getting ready

How to do it...

How it works...

Designing server-side reports in SQL Server Reporting Studio

Getting ready

How to do it...

How it works...

There's more...

4. .NET Interoperability in C/AL

Introduction

Using .NET assemblies in C/AL

How to do it...

How it works...

Understanding static classes and methods

How to do it...

How it works...

Developing server-side extensions

How to do it...

How it works...

Developing client-side extensions

How to do it...

How it works...

Working with generics in C/AL

How to do it...

How it works...

Working with interfaces

How to do it...

How it works...

Accessing collections with the FOREACH statement

How to do it...

How it works...

Working with .NET strings and arrays in C/AL

How to do it...

How it works...

Invoking .NET methods via reflection

How to do it...

How it works...

Handling exceptions with try functions

How to do it...

How it works...

Handling .Net events in C/AL

How to do it...

How it works...

Developing your own .NET class

How to do it...

How it works...

Starting processes in separate threads

Getting ready

How to do it...

How it works...

5. Extending C/AL with COM Components

Introduction

Using COM type libraries in C/AL

How to do it...

How it works...

Mapping COM datatypes to C/AL

How to do it...

How it works...

Disposing of COM objects

How to do it...

How it works...

Working with the Variant datatype

How to do it...

How it works...

Sending data to the Excel automation server

How to do it....

How it works...

Creating a Word document using automation objects

How to do it...

How it works...

Creating and registering a COM component that can be used in NAV

How to do it...

How it works...

6. SharePoint Integration

Introduction

Creating a developer SharePoint site

How to do it...

Developing NAV apps for SharePoint

Getting ready

How to do it...

How it works...

Embedding NAV page objects in site pages

Getting ready

How to do it...

How it works...

Publishing NAV reports in SharePoint

How to do it...

Deploying applications on SharePoint

How to do it...

How it works...

Configuring user permissions

How to do it...

How it works...

7. Control Add-ins

Introduction

Developing a control add-in

How to do it...

How it works...

Signing the control add-in assembly

How to do it...

How it works...

Registering and embedding a control add-in

How to do it...

How it works...

JavaScript in web, phone, and tablet clients

Getting ready

How to do it...

How it works...

Installing and using JavaScript control add-ins

How to do it...

How it works...

Sending events from add-ins to NAV server

Getting ready

How to do it...

How it works...

Linking add-ins with the database

How to do it...

How it works...

Exchanging data with add-ins

How to do it...

How it works...

8. Web Services

Introduction

Publishing a SOAP web service

How to do it...

Calling object methods in SOAP web services

How to do it...

How it works...

Exposing and consuming OData web services

How to do it...

How it works...

Querying NAV OData web services with LINQ

How to do it...

How it works...

Updating NAV data through web services

Getting ready

How to do it...

How it works...

Securing access to web services

Getting ready

How to do it...

How it works...

Consuming the NAV web service from Java

Getting ready

How to do it...

How it works...

9. Events and Extension Packages

Introduction

Subscribing to business and integration events

How to do it...

How it works...

Subscribing to global events

How to do it...

How it works...

Using database trigger events

How to do it...

How it works...

Extending UI with page trigger events

How to do it...

How it works...

Creating custom events

How to do it...

How it works...

Subscribing to events in runtime

How to do it...

Developing an extension

Getting ready

How to do it...

How it works...

Installing an extension

Getting ready

How to do it...

10. PowerShell

Introduction

Managing the database

How to do it...

How it works...

Managing users and user permissions

How to do it...

How it works...

Managing companies

How to do it...

Administering NAV services with PowerShell

How to do it...

How it works...

Handling application objects

How to do it...

How it works...

Merging application objects

How to do it...

How it works...