Import sales orders with EAN Codes

EDI often use the EAN coding standards to indentify items. Since the EAN code is not part of standard Microsoft Dynamics NAV application it is not possible to create Sales Order Lines whithout getting the Item No. field.
This post explains how to import an EDI order with EAN codes by using To-Increase Connectivity Studio for Microsoft Dynamics NAV.

Assumption: the EAN code is maintained by the field Common Item No.

The following Xml document represents the EDI order which we try to import in this scenario:

<SalesOrder>
    <OrderNumber>23490234</OrderNumber>
    <Customer>10000</Customer>
    <SalesLine>
        <EAN>ABCDEFGHI</EAN>
        <Quantity>10</Quantity>
    </SalesLine>
</SalesOrder>

The document definition has the following structure:


The SalesOrder block has the following members:
The SalesLine block has the following members:

The Item block has a table relation which is based on the No. field to the primary key of the Item table

The Item Block uses an Alternative Key:

And has the following members:


We now configure a Connectivity Studio Project and import the xml document for this scenario.


Open the item card for item LS-120 and enter the EAN code in the field Common Item No.

We process the project and check the result in the Queue.


Open the Sales Order List with the drilldown of the field Record ID (yet another nice undocumented feature :))