Book Image

Implementing Microsoft Dynamics NAV - Third Edition

By : Alex Chow
Book Image

Implementing Microsoft Dynamics NAV - Third Edition

By: Alex Chow

Overview of this book

Microsoft Dynamics NAV 2016 is an Enterprise Resource Planning (ERP) application used in all kinds of organizations around the world. It provides a great variety of functionality out-of-the-box in different topics such as accounting, sales, purchase processing, logistics, or manufacturing. It also allows companies to grow the application by customizing the solution to meet specific requirements. This book is a hands-on tutorial on working with a real Dynamics NAV implementation. You will learn about the team from your Microsoft Dynamics NAV partner as well as the team within the customer’s company. This book provides an insight into the different tools available to migrate data from the client’s legacy system into Microsoft Dynamics NAV. If you are already live with Microsoft Dynamics NAV, this books talks about upgrades and what to expect from them. We’ll also show you how to implement additional or expanding functionalities within your existing Microsoft Dynamics NAV installation, perform data analysis, debug error messages, and implement free third-party add-ons to your existing installation. This book will empower you with all the skills and knowledge you need for a successful implementation.
Table of Contents (19 chapters)
Implementing Microsoft Dynamics NAV Third Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Extracting data


Dynamics NAV offers several ways of analyzing and reporting data inside the application. If that is not enough, you can also extract data from the application and use external tools to report and analyze your data.

In this section, we will see the different ways you can extract your data from Dynamics NAV. Once it is outside the application, you can use the most convenient tool for you.

Data in Dynamics NAV can be extracted in multiple ways. The various ways include:

  • Copying and pasting to Excel

  • Extracting data through SQL Server

  • Any external data/reporting tools that can connect to SQL Server

  • Web services

  • EDI

The list goes on and on…

In this section, we'll focus only on two ways of exporting the data:

  • Sending data to Microsoft Office applications

  • Using web services

Sending data to Microsoft Office applications

Dynamics NAV data can be sent to either Microsoft Word or Microsoft Excel by the users.

Whenever that is possible, which is on all the pages in Dynamics NAV, except on the Role...