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

Designing reports in Visual Studio


For an introductory example, we will create a simple client-side report presenting data in a NAV Report object. External reporting tools can provide more extensive functionality and flexibility in data manipulation, but client-side reports are a foundation of the NAV reporting toolbox. Its certain advantage is full integration with Role-Tailored Client, including the security system and the ability to execute C/AL code.

The object developed in the recipe is available in the source files (REP50010_ItemSales.txt).

How to do it...

In the following example, we will design a report to calculate the amount of income, cost, and profit for each sold item.

  1. Switch to the report designer and press New to create a new Report object.

  2. First set up the dataset. Insert one line in the Dataset Designer: Data Type = DataItem, Data Source = Item.

  3. Under the data item, insert report fields:

    Data type

    Data source

    Name

    DataItem

    Item

    Item

    Column

    "No."

    No

    Column

    Description...