+1 (888) 319-3663 | sales@smartconnect.com

Using a Page Key Field Lookup

  1. On the Integration tab click on Additional Columns tab.
  2. Click on Add Additional Column button.

  3. The Additional Column window will open.
  4. Name – enter a name for the column.
  5. Tab off the Name field to enable the Type field.
  6. Type – select Page Key Lookup from the Type dropdown list.

  7. Service – select the name of the web service to be used.
  8. Service Url – displays the url associated with the Service that was selected.
  9. Filter Fields – click Add Attribute to enter the matching details for the lookup.
    1. Field – Select the source Field column that contains the data to be matched to the Dynamics NAV data.
    2. Field Type – select the field type for the selected Field.
    3. Criteria – select the criteria field that matches the source field.
  10. Add additional criteria rows if required.
  11. Save the settings.

Leave a Comment