Interface methodologies

So now we have discussed interface types, interface technologies, and the built-in interfaces in Microsoft Dynamics NAV.

Let's design and develop a new business to business interface. We will use the objects from Chapter 7, Storage and Logistics, to create the interface.

The scenario

One of our customers wants to e-mail the shipments from now on instead of faxing. The e-mail will contain an Excel file in a predefined format.

The design

Let's bring back the data model we designed for the logistics part of the solution in Chapter 7, Storage and Logistics.

The process starts in the registration table. From a registration, we generate shipments and shipments are combined into a Route with stops.

So we need to move the data from the Excel sheet to the registration table.

The mapping

When a customer delivers us an Excel sheet with information, it seldom happens that they exactly use the same fields as our table. Therefore,...