NAV 2017 Sample Integrations - All in One
NAV 2017 Sample Integrations - All in One
Get a jump start on integrating data into Dynamics NAV using SmartConnect! The sample maps show how to import data from Excel or csv files into 24 different Dynamics NAV pages. Each map can be used as-is or can be used as a great starting point to customize further. Each integration includes a SmartConnect map and an excel data source. For clients without Excel installed, there are CSV versions of each data source as well that can be used instead. The provided maps integrate to:
- Customer Card (21)
- Vendor Card (26)
- Employee Card (5200)
- G/L Account Card (17)
- Item Card (30)
- Fixed Asset Card (5600)
- Location Card (5703)
- Production BOM (99000786)
- Contact Card (5050)
- Campaign Card (5086)
- Opportunity Card (5124)
- Sales Quote (41)
- Sales Order (42)
- Sales Invoice (43)
- Purchase Order (50)
- Purchase Invoice (51)
- Purchase Credit Memo (52)
- Assembly Order (900)
- General Journal (39)
- Payment Journal (256)
- Cash Receipt Journal (255)
- General Journal Batches (251)
- Item Journal (40)
- Transfer Order (5740)
General InformationThe Dynamics NAV Sample maps consist of 24 different maps and an Excel or CSV data source for each map. Every map is a bulk map and set to use an Excel spreadsheet as a data source. The data sources each contain a small number of records and contain enough fields to run, but more columns can be added. Every map is included in the main download zip file, but each map can be used as a stand-alone integration and do not need to be ran in any order.
Prerequisites to using these templates are as follows:
- Have a valid Dynamics NAV organization set up
- SmartConnect 20.17 or higher installed and registered
- Dynamics NAV Connector already configured within SmartConnect
- Set Up Dynamics NAV Web Services to Allow Integrations
- Import map files(s)
- Update file path to data source
- Review mapping (and customize if desired)
Set Up Dynamics NAV Web Services to Allow IntegrationsDynamics NAV requires a page object to be published before any applications can interact with them through a web service. Because every map is sending data into NAV, a page for every map must be published.
To publish a page:
- Search for "Web Services" in the search box and select the "Web Services" page.
- Click "New" in the top left corner.
- Set the Object Type to "Page". Enter the "Object ID" and the "Object Name" will be auto-filled.
- Enter a service name. Our web service will use this service name to identify pages, so set the Service Name to the same name as the "Object name" without any spaces or special characters.
- Check the Publish checkbox.
Below is a list of pages to publish. The number in parenthesis is the Object ID. The map name and map description show which map references that particular page. Only publish the pages that have a map you want to integrate with.
Import Map Files
- Download the "Dynamics NAV 2017 Maps.sce" file.
- From the Maintenance tab in SmartConnect, click Import Wizard.
- Browse to the downloaded maps file and click next. The next window will show everything in the import file.
- To import everything, click next. If you don't want to import all the maps, check only the maps you wish to use.
- Once the maps are imported, the map has to be set up and reviewed before running. The process is similar for all maps so only the "IMP_NAV_ITEMS" map will be shown below
Steps to Setting Up Map
- From SmartConnect, double click the "IMP_NAV_ITEMS" map name to open the Map Setup window.
- An error may appear if the source workbook cannot be found. If so, enter a new Excel Workbook path by browsing to a new workbook and re-selecting the Sheet.
- Expand the Destination section of the map setup window to see the mapped nodes. The "Service Name" is the same name given on the Web Services window in Dynamics NAV. The "Service URL" also comes from the Web Services page in the "SOAP URL" column.
To inspect the mapping, double click a mapped node to open it.
- In the SmartConnect Mapping window, the "Source Columns" section lists all of the columns in the Excel or CSV source file. In the "Destination Columns" section, the Name column shows all the possible Dynamics GP fields to map to, and the "Column Name" column shows which source column data will come from. Many of the fields have a "...Specified" field to go with it. These fields are booleans that tell NAV that the field is to be used. Not every field has a "...Specified" field, but that is something to look for when customizing any templates!
- After the "SmartConnect Mapping" window has been reviewed and modified if necessary, run the map.