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:

    Developing the solution

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


    I've changed the name of the  No. field in Sales Shipment Line in the  

Get Building ERP Solutions with Microsoft Dynamics NAV now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.