Book Image

Building ERP Solutions with Microsoft Dynamics NAV

By : Stefano Demiliani
Book Image

Building ERP Solutions with Microsoft Dynamics NAV

By: Stefano Demiliani

Overview of this book

Implementing Microsoft Dynamics NAV in the real world often requires you to integrate the ERP with external applications or solve complex architectural tasks in order to have a final successful project. This book will show you how to extend a Microsoft Dynamics NAV installation to the enterprise world in a practical way. The book starts with an introduction to Microsoft Dynamics NAV architecture and then moves on to advanced topics related to implementing real-world solutions based on NAV and external applications. You will learn how an enterprise distributed architecture with NAV at the core can be implemented. Through a series of real-world cases on every topic and every industry (sales, retail, manufacturing, distribution, healthcare, and so on), you’ll see step by step how to efficiently solve a technical problem. These common problems encountered in a NAV implementation will be solved using the entire technology stack that Microsoft offers. By the end of the book, you will have the knowledge to efficiently solve certain scenarios, you will know which is the best solution architecture to propose to a customer and how to implement it.
Table of Contents (17 chapters)
Building ERP Solutions with Microsoft Dynamics NAV
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Developing the solution


Our solution is essentially composed of two parts as follows:

  • The NAV business logic

  • The interface layer (cloud service)

In the NAV instances of the subsidiary companies, we need to retrieve the sales shipment's data for every item:

  1. To do so, we need to create a Query object that reads  Sales Shipment Header and Sales Shipment Line, and exposes them as web services (OData).

    The Query object will be designed as follows:

  2. For every Sales Shipment Header (table 110), we retrieve the corresponding Sales Shipment Lines (table 111) that have Type = Item:

    Note

    I've changed the name of the  No. field in Sales Shipment Line in the   dataitem field as ItemNo because the default name was used in the Sales Shipment Header field as dataitem.

  3. Compile and save the Query object (here I've used object ID = 50009 and Name = Item Shipments).

  4. Now we have to publish the Query object as a web service in NAV (as described in the first chapters of this book), so open the Web Services page and create...