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...