Help Articles

  Thursday, December 8, 2011   /     Kevin
How to utilize Binary Stream Multi Facility Nodes in SmartConnect.First you must obtain and install the Multi Facility eConnect nodes from Binary Stream Software, Inc. Run the stored procedures according to the instructions supplied with the nodes. This document describes how to add the Facility ID… [Read More]
  Thursday, December 8, 2011   /     Kevin
This article explains how to pass a variable into a source query.1. When you first create the map, you need to hard code the field that will be the variable. The source query will not validate with a variable in the source query. For example: SELECT * FROM RM00101 2. Create your map, and map… [Read More]
  Thursday, December 8, 2011   /     Kevin
The following article from Microsoft tells how to create a SQL stored procedure that will function as an eConnect node.Creating an eConnect SQL stored procedureOnce you have created the node, you can add the node in SmartConnect Node Maintenance. [Read More]
  Wednesday, December 21, 2016   /     Katie Soderberg
When you integrate with Microsoft Dynamics 365 for Financials using SmartConnect, you are able to integrate with all the data in your instance that is published to web services. In Microsoft Dynamics 365 for Financials, only some of the objects are published to web services by default.  However,… [Read More]
  Thursday, December 8, 2011   /     Kevin
The settings in IIS7 differ from IIS6 and as a result there are different steps that need to be followed.Once the SmartConnect installer has finished and the SmartConnect web service is installed on the IIS7 machine, it needs to be configured. First, the ASP.NET components need to be installed… [Read More]
  Thursday, December 8, 2011   /     Kevin
Importing SOP transactions with taxes requires adding a sequence number to the source file in order to link the correct tax detail to the correct line item.Taxes Use the XML node to control how taxes are calculated. To use header level taxes, set the header level taxes (USINGHEADERLEVELTAXES)… [Read More]
  Tuesday, March 29, 2016   /     Patrick Roth
I've been working with SmartConnect for a few years now and eConnect for another ten more before that and one fairly common thing I run into is users often want to bring in a specific distribution (typically SALES or PURCH distribution) and let the rest default.As it turns out, that even while… [Read More]
  Monday, October 9, 2017   /     David Youngquist
When attempting to browse the SmartConnect WCF web service, the browser window reports an error that says "HTTP Error 404.3 - Not Found" followed by an additional message that says "The page you are requesting cannot be served because of the extension configuration.  If the page is a script, add a… [Read More]
  Thursday, December 8, 2011   /     Kevin
The following resolution was taken from an exercise in the SmartConnect training manual and shows how to grant users access to the SmartConnect Run Map window along with any associated windows and processes. Note that these steps do not cover setting up security inside of SmartConnect. Users in… [Read More]
  Wednesday, October 26, 2016   /     Lorren Zemke
Get the following error trying to run a Dynamics GP Payables Transaction integration.  … [Read More]
  Wednesday, October 23, 2019   /     Chris Hanson
With the purchase of a SmartConnect subscription plan, dual access rights are granted to the customer. If using the on-premise windows client of SmartConnect, registration keys will be needed to fully enable the product. If the hosted solution will be utilized, you will gain access… [Read More]
  Friday, September 27, 2019   /     Ethan Sorenson
If you have a lookup field on a record in CRM that you want cleared so it is blank you can use this process. SmartConnect will utilize the CRM SDK to remove the link between the two records.SetupIn this example I am going to remove the primary contact from an Account record. As part of the process… [Read More]
  Wednesday, September 18, 2019   /     David Youngquist
How can I recreate all the SmartList Builder stored procedures if I suspect some of them have been deleted or corrupted?Follow these steps to drop and create all the stored procedures for the SmartList Builder product1. Login to GP as the SA user. 2. Go to Microsoft Dynamics GP - Maintenance - SQL3.… [Read More]
  Friday, September 13, 2019   /     David Youngquist
Trying to setup the CRM Connector.  I have put "" as the CRM server URL and put in my user name and password, and I receive the error "Failed to connect to the CRM server : Failed to get CRM Organizations : Access is denied".  I have triple checked my username and password and they… [Read More]
  Friday, September 6, 2019   /     David Youngquist
Using an Excel data source, and receiving an error that says "Connection could not be validated".  When clicking on Details, the message says "ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"This is caused by not having 32 Bit Excel/Office… [Read More]
  Wednesday, September 4, 2019   /     Ethan Sorenson
Cards in Nav/Business Central can have default dimensions assigned. These dimensions are not stored on the card, but rather in the Default Dimensions table. Therefore, after the card is created a second mapping will need to be used to add the dimensions.MappingA new web service will need to be… [Read More]
  Wednesday, August 28, 2019   /     Ethan Sorenson
When creating a Sales Order or Sales Invoice in Business Central, you will receive an error like the one shown above if trying to define a Ship-to Address.*Note that any code provided is for use as a point of reference and will not be supported by eOne Solutions. CauseWhen you change the… [Read More]
  Friday, August 23, 2019   /     Patrick Roth
I'm using the WinSCP application to connect to my SFTP server.I can connect and upload/download files successfully when using the WinSCP application included in the download, but when I try to connect via SmartConnect scripting per this blog article, it fails with the… [Read More]
  Friday, July 12, 2019   /     Ethan Sorenson
When importing a Sales Invoice or Sales Order to Business Central and receive the below error message.Type must be equal to 'Inventory' in Item: No.=XXXX. Current value is 'Service'.CauseThe line item has been setup as a Service type Item. This can be verified by checking the Item Card for the field… [Read More]
  Tuesday, July 9, 2019   /     David Youngquist
Attempting to start the "eOne SmartConnect Service" in Windows and receiving an error that says, "Error 1068: The dependency or group failed to start."Make sure that the user you have configured to start the "eOne SmartConnect Service" is an administrator in SmartConnect.  Also make sure that the… [Read More]



open all | close all


Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce scripting SmartConnect SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk