Book Image

Extending Microsoft Dynamics NAV 2016 Cookbook

By : Alexander Drogin
Book Image

Extending Microsoft Dynamics NAV 2016 Cookbook

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. 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.
Table of Contents (17 chapters)
Extending Microsoft Dynamics NAV 2016 Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Sending data to the Excel automation server


The automation datatype in C/AL is frequently used in practice for communication with Microsoft Office applications that export their API through automation servers.

Now we will export the contents of the Customer table from a codeunit using the COM automation library.

How to do it....

  1. Create a new codeunit in the object designer. This will be the object exporting data through an automation server.

  2. Triggering OnRun of the codeunit will instantiate the automation server and iterate on records of the Customer table to export each of them. First declare local variables in the trigger:

    Name

    DataType

    Subtype

    Customer

    Record

    Customer

    ExcelApp

    Automation

    Microsoft Excel 16.0 Object Library.Application

    Workbook

    Automation

    Microsoft Excel 16.0 Object Library.Workbook

    Worksheet

    Automation

    Microsoft Excel 16.0 Object Library.Worksheet

    RowNo

    Integer

    Note

    The Microsoft Excel 16 Object Library version in variable declarations corresponds to...