Help Articles

  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, May 26, 2016   /     Brady Swenson
Running a map using the WCF Webservice returns the error message "The Request failed with HTTP status 405: Method Not Allowed".Typically, this indicates an issue with the Real time and SmartList web service URL, which is found under the SmartConnect Dynamics GP Connector.To correct this issue, log… [Read More]
  Thursday, December 8, 2011   /     Kevin
The following document gives step by step instructions for creating a custom eConnect node, that can be used with SmartConnect.The following article from Microsoft tells how to create a SQL stored procedure that will function as an eConnect node.Once you have created the node, you can add the node… [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]
  Thursday, December 8, 2011   /     Kevin
When launching Great Plains, receiving an error message that says "SmartConnect could not be loaded"This can be caused by several different issues. Open the Windows Event Viewer and look at the SmartConnect Event Log. If the error message says "Login failed for user 'SmartConnect'" it means that… [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]
  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]
  Tuesday, April 14, 2015   /     Nicole Albertson
The Employee Pay Codes SmartList Builder setup is built to show all the of the Pay Codes and the information that goes with those such as pay rate, for each Employee.SmartList ID:  UPR_EMP_PAYCODESmartList Name:  Employee Pay CodesTables Involved:Payroll Pay Code MasterPayroll MasterPayroll Pay… [Read More]
  Wednesday, October 26, 2016   /     Lorren Zemke
Get the following error trying to run a Dynamics GP Payables Transaction integration.  … [Read More]
  Thursday, June 4, 2015   /     Nicole Albertson
Action Name: … [Read More]
  Monday, December 17, 2018   /     Katie Soderberg
Our resellers have the opportunity to purchase subscription plans on behalf of their customers at the eOne Shop.  Once purchased, following are the steps to access the environment for the first time:1. Log in on the eOne website.  2. Under My Account, select Renewals/Keys.3. … [Read More]
  Tuesday, December 4, 2018   /     Ethan Sorenson
Recently I encountered a scenario where a client machine was returning the error, "The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception", when running a map that connects to SQL. The error message is a standard .NET Framework error, that is saying .NET can't create the… [Read More]
  Monday, November 26, 2018   /     Ethan Sorenson
What is FIPS?Windows has a setting that prevents applications on the machine from using encryption that are not compliant with Federal Information Processing Standards(FIPS). This setting is typically only needed for servers that contain government data. Here is a good article about FIPS and why it… [Read More]
  Tuesday, November 20, 2018   /     David Youngquist
Trying to setup the SalesForce connector and receiving the error, "INVALID_LOGIN: Invalid username, password, security token; or user locked out."First confirm that you can login to SalesForce manually using the same username, password, and security token.  If they are correct, and you can login… [Read More]
  Monday, November 19, 2018   /     Patrick Roth
I've installed the latest SmartView (Internal) on my GP 2013/2013 R2 system and it seems to work well.However when I try to use any of the GoTos for my SmartList Builder reports, SmartView gives the error:Unknown identifier 'GenerateTableTypes'.The destination GoTo window does not open. The GoTos… [Read More]
  Monday, October 29, 2018   /     Patrick Roth
I'm trying to delete a Customer record in Business Central/NAV using the SmartConnect SOAP CustomerCard endpoint.When I run the integration, it fails with the error:Failed to delete record with Keys 'Key = XXX' Key "XXX" is not well formed!Why do I get this error?The reason for the error is a… [Read More]
  Wednesday, September 26, 2018   /     Ethan Sorenson
A quick article to assist in resolving a common error message when creating a map to SalesForce.First, we should address how SmartConnect sends data to SalesForce. SmartConnect connects to SalesForce using the SOAP API. For every record SmartConnect makes two calls to the web service. The first call… [Read More]
  Thursday, August 9, 2018   /     Ethan Sorenson
Looking to integrate with Microsoft Dynamics 365 Business Central?  Your first step in SmartConnect will be to set up the connector, then you will be able to create your SmartConnect maps to set up your integrations.The Dynamics NAV/D365 Business Central Odata Connector is available in SmartConnect… [Read More]
  Monday, August 6, 2018   /     David Youngquist
How can I add either the Company ID or the Company Name to a Multicompany SmartList?You can add Company ID or Company Name using a calculated field in SmartList Builder.  Click on the Calculations button in SmartList Builder, then click on the Add button.  There is a section at the bottom of the… [Read More]
  Wednesday, August 1, 2018   /     David Youngquist
When attempting to browse the SmartConnect web client, the browser window reports an error that says “HTTP Error 403.14 – Forbidden” followed by an additional message that says “The Web server is configured to not list the contents of this directory."  What is causing this?This means you do… [Read More]



open all | close all


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