Book Image

Implementing Microsoft Dynamics NAV 2013

By : Laura Nicolàs Lorente, Cristina Nicolàs Lorente
Book Image

Implementing Microsoft Dynamics NAV 2013

By: Laura Nicolàs Lorente, Cristina Nicolàs Lorente

Overview of this book

<p>Microsoft Dynamics NAV 2013 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 and purchases processing, logistics, or manufacturing. But it also allows companies to grow the application by customizing the solution to meet specific requirements.<br /><br />"Implementing Microsoft Dynamics NAV 2013" explains all you need to know to successfully handle your first Dynamics NAV 2013 implementation. You will learn what the application can do out of the box, how you can extend it to meet any kind of requirements, and how to manage real implementation projects with real customers.<br /><br />This book does not only cover typical topics when implementing the new version of an ERP system; topics that are not found in any previous documentation of Dynamics NAV, such as the implementation process at the customer side, or implementing functional changes on existing Dynamics NAV implementations are included in here. This approach makes this book different.<br /><br />After reading "Implementing Dynamics NAV 2013" you will be empowered with the skills and knowledge you need for successful implementations.</p>
Table of Contents (22 chapters)
Implementing Microsoft Dynamics NAV 2013
Credits
About the Authors
Acknowledgement
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

What is a query


Query is the name of a new Dynamics NAV application object introduced in Microsoft Dynamics NAV 2013. This application object is only meant to retrieve data from the database. It is a read-only object. It cannot modify, delete, or insert new data into the database.

Queries are the ninth object type in Dynamics NAV, although only seven are available in Dynamics NAV 2013, now that forms and dataports are gone.

There are many things about queries in Dynamics NAV that will make you just love them:

  • They allow us to retrieve data from multiple tables at the same time

  • They allow us to retrieve only specific fields in a table

  • They allow us to group the retrieved data according to certain fields without the need of any explicit key for them

  • They allow us to total the retrieved data using different totaling methods (sum, count, average, min, and max)

If you are a Dynamics NAV programmer and you have worked with the previous versions of Dynamics NAV, you will see the advantages and the possibilities...