Building ERP Solutions with Microsoft Dynamics NAV

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