Help Articles

Connecting SmartConnect to Salesforce without a Security Token

  Tuesday, April 5, 2016   /     Jared Dux
With the latest released version of SmartConnect you can connect to Salesforce without using the Salesforce security token. This allows the Salesforce connector to be setup using just the Salesforce login and password. You will want to have a static IP address, otherwise you will need to be updating… [Read More]

System Requirements for SmartConnect

  Thursday, December 8, 2011   /     Kevin
What are the system requirements for SmartConnect?The hardware and operating system requirements for SmartConnect are the same as the Microsoft requirements for Dynamics. So if your machines will successfully run Dynamics, you can run SmartConnect. The following are additional requirements for… [Read More]

Manufacturing Receipt Master SmartList Builder Template

  Tuesday, June 14, 2016   /     Nicole Albertson
The Manufacturing Receipt Master SmartList Builder setup is built to give you a list of the receipts for orders in the Manufacturing series.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID: MFG_REC_MASTERName: Manufacturing… [Read More]

Manufacturing Routing Line SmartList Builder Template

  Tuesday, June 14, 2016   /     Nicole Albertson
The Manufacturing Routing Line SmartList Builder setup is built to give you a list of the routing information in Manufacturing.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID: MFG_ROUT_LINEName: Manufacturing Routing LineTables… [Read More]

Tech Tuesday: SmartConnect Email Task Feature

  Tuesday, August 2, 2016   /     Shannon
In today's Tech Tuesday article, I am going to show you the email task feature within SmartConnect. The email task can be used on a map task that allows emails to be sent containing the details of map processing. This allows a user to get the status on a map, without having to log into SmartConnect… [Read More]

Creating Your First SmartConnect Integration

  Friday, September 2, 2016   /     Katie Soderberg
Following are steps, from a high-level, for creating your first SmartConnect integration: … [Read More]

Average Salary by Department SmartList Builder Template

  Tuesday, April 14, 2015   /     Nicole Albertson
The Average Salary by Department SmartList Builder template is built to calculate the average salary for each department setup in the Microsoft Dynamics GP Payroll module. It uses the Pay Rate Amount from the Payroll Pay Code Master and is summarized by Department. This is only for Pay Type of… [Read More]

The Column Name ‘MyColumn’ is specified more than once in the SET Clause.

  Tuesday, July 8, 2014   /     David Youngquist
I have my SmartConnect destination set as a Microsoft SQL … [Read More]

Tech Tuesday: Understanding Dynamics GP eConnect Errors

  Tuesday, August 30, 2016   /     Lorren Zemke
It's inevitable that when creating an integration to Dynamics GP there are going to be errors returned at some point in the process due source data differences, mapping data incorrectly or differences in eConnect business logic. We might have missing vendors or customers or distributions amounts… [Read More]

Creating a batch file to run a SmartConnect map

  Thursday, December 8, 2011   /     David Youngquist
How to create a batch file to run a SmartConnect map. The syntax of the batch file depends on the version of SmartConnect you are on. If you are on the or prior, the batch file looks like this. Replace CUSTOMERS with the name of the map you are running. Replace TWO with the database name… [Read More]

Tech Tuesday : Changing the Column Names on an Excel File Destination

  Tuesday, May 23, 2017   /     Patrick Roth
In a previous column, I had discussed how we could change the column names of the text output file that SmartConnect had created. … [Read More]

Tech Tuesday : SOP with Header Level Taxes

  Tuesday, May 16, 2017   /     David Youngquist
This week’s Tech Tuesday will give an example of how to do a SOP Transaction with header level taxes. The most common scenario we run into is allowing the sales transaction to use the default tax engine inside of GP.  However, the second most common request is how to import a sales transaction… [Read More]

Node Builder – Incorrect syntax near ‘TRIPLE_DES’

  Wednesday, May 10, 2017   /     Lorren Zemke
I am trying to install Node Builder and receiving the error "incorrect syntax near 'TRIPLE_DES'". The Node Builder database is created but it contains no tables. … [Read More]

Tech Tuesday: SmartConnect Dynamics 365/CRM Connection Errors

  Tuesday, May 9, 2017   /     Ethan Sorenson
Here is a list of SmartConnect SmartConnect Dynamics 365/CRM Connection Errors, and how to resolve the errors. Our SmartConnect manual goes into detail about how to setup the connector, and Katie Soderberg posted a help article specifically for Dynamics 365 CRM. … [Read More]

Missing Excel Report Builder menu items

  Thursday, May 4, 2017   /     David Youngquist
The Excel Report Builder menu is missing items, or has items on it that appear to be from other menus.   … [Read More]

Restricting access to the Modify button in SmartList and SmartList Builder

  Thursday, May 4, 2017   /     David Youngquist
Starting in Microsoft Dynamics GP 2013, there is a new option added to the SmartList window.  On a standard installation, pressing this button will open the Microsoft SmartList Designer product.  If you have SmartList Builder installed, pressing the button will open eOne SmartList Builder.   … [Read More]

How to run a SmartConnect map to an XML file

  Thursday, May 4, 2017   /     David Youngquist
Often times it makes it easier to troubleshoot SmartConnect errors if you can see the exact data that is being submitted to eConnect.  You can do this by running a map to XML file and then opening up the file in a XML Editor.   … [Read More]

Could not log into the SQL Server Could not create session factory after updating to SmartConnect 2017

  Tuesday, May 2, 2017   /     David Youngquist
When upgrading SmartConnect to, I receive an error that says "Could not log into the SQL Server Could not create session factory" … [Read More]

GL Trial Balance Summary SmartList Builder Template

  Wednesday, April 26, 2017   /     Nicole Albertson
The GL Trial Balance Summary SmartList Builder setup is designed to return the Beginning Balance, Monthly Net Change, and Ending Balance for each account for each History and Open year.  This is data similar to the General Ledger Summary Trial Balance that can be printed in Microsoft Dynamics GP. … [Read More]

Tech Tuesday: Extender Filter Lookups on Detail Windows

  Tuesday, April 25, 2017   /     Mark Anderson
In a previous Tech Tuesday article, we discussed how to add restrictions to lookups on forms and windows. This article will discuss how to apply this to fields on a detail window or a detail form. This is currently only available in our latest Extender 2016 version (build 16.00.0030 or higher). In… [Read More]
open all | close all