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

Retrieving data from NAV with Power Query


Power Query is a tool for retrieving data from various data sources, which enables the user to transform, purify, and merge data with ease. Power Query is used to load data into analytical tools, such as Power BI. Data analysis in Power BI is the topic of several recipes to follow, and now we will configure a query to import data into Excel.

Getting ready

If your Microsoft Office version is 2016, Power Query is already a part of the standard setup, no additional steps are required.

For earlier versions of Office, Power Query must be installed separately. It is available for downloading on microsoft.com.

Note

Note that examples in the current and subsequent recipes are based on Office 2016. The Power Query Excel add-in is accessed in the Data ribbon tab in this version. In Excel 2010 and 2013, Power Query actions are located in the ribbon in the Power Query tab.

How to do it...

In this recipe, we will use Power Query to export a list of customers with total...