Skip to content


Help Articles

  Tuesday, March 22, 2016   /     David Youngquist
Having problems with an application? Before you decide to call support, there are few basic steps that anyone can try first. These are general steps that you can apply to any software, not just eOne software. Trying some basic troubleshooting steps before contacting support can save you a lot of… [Read More]
  Monday, April 21, 2014   /     Nicole Albertson
Linking tables in SmartList Builder can be confusing.  Below you will find the difference between using the Equals and Left Outer as well as which order the tables should be in. Equals:This option will exclude any records that don't exist in both tables from the results. A record must exist in… [Read More]
  Wednesday, January 18, 2017   /     Ethan Sorenson
When executing a map, we are getting this error. … [Read More]
  Thursday, August 9, 2018   /     Ethan Sorenson
Microsoft now requires all Business Central SaaS customers to use OAuth to access the APIs. Documentation for authentication can be found here. … [Read More]
  Friday, December 31, 2021   /     eOne Solutions
The eOne Lifecycle policy states the standard support policies for all eOne products. This policy is a worldwide policy. However, if local laws require different policies, those changes will be made individually.SmartConnect On-Premise LifecycleThe policy follows the Fixed and Modern Lifecycle… [Read More]
  Thursday, December 8, 2011   /     Kevin
This article has been superseded by this article. Receiving an error when running a SmartConnect map that says "Could not retrieve next number in the sequence".  This may or may not be followed by a second error that says, "The execute permission denied on the E1_SC_GetNextNumber"This can be… [Read More]
  Thursday, December 8, 2011   /     Kevin
When importing transactions with SmartConnect receiving an error that says "Violation of PRIMARY KEY constraint 'PKAAGx0000', cannot insert duplicate key in object 'AAGx0000'" where x is a number 1, 2 or 3This problem occurs because the next value in the AAG00102 table has already been used in the… [Read More]
  Thursday, November 8, 2012   /     David Youngquist
The SmartConnect scheduler service will not stay running.  When going into the Windows services, the service is stopped.  When the service is started, a message appears that says 'The eOne SmartConnect Service on Local Computer started and then stopped.  Some services stop automatically if they… [Read More]
  Tuesday, March 8, 2016   /     Brady Swenson
Recently I was working on a project that involved using the SmartConnect Excel 2013 Add-in to run a customized Map. After successfully installing the SmartConnect Excel Add-in, I found each time I would close Excel 2013 and re-open my spreadsheet the eOne Solutions Add-in ribbon (as you can see in… [Read More]
  Thursday, December 8, 2011   /     Kevin
How to write a SmartConnect script that will return the current system date in a format that GP Dynamics will accept.return DateTime.Now.ToString("MM/dd/yyyy") [Read More]
  Monday, January 30, 2023   /     David Youngquist
When attempting to browse the SmartConnect WCF web service, the browser window reports an error that says "HTTP Error 500.19 - Internal Server Error" followed by an additional message that says "The requested page cannot be accessed because the related configuration data for the page is invalid." … [Read More]
  Friday, December 30, 2022   /     Patrick Roth
I'm running a integration and once in a while see this saysError: The client has been inactive since <date & time> and it has exceeded the inactivity timeout of 50000 ms.  Stopping the connection.[caption id="attachment_39719"… [Read More]
  Friday, December 16, 2022   /     Patrick Roth
My customer had been using SmartConnect 2018 and an ODBC query against an on-prem Microsoft CRM for a number of years and was working fine even after updating to SC 21.Recently, they moved to Microsoft CRM CE.  After enabling their Dataverse Tabular Data Stream (TDS) endpoint that emulates a SQL… [Read More]
  Monday, December 12, 2022   /     David Youngquist
After performing an upgrade of Extender, receiving an error when launching Dynamics GP that says, "Message #24574 is missing."All 18.X versions of Extender use a customer account code to register the product.   All the error message is indicating is that you have updated to a newer version and you… [Read More]
  Monday, December 12, 2022   /     David Youngquist
After performing an upgrade of SmartList Builder, receiving an error when launching Dynamics GP that says, "Your registered version of SmartList Builder does not match the installed version of SmartList Builder"All 18.X versions of SmartList Builder use a customer account code to register the… [Read More]
  Thursday, December 8, 2022   /     Nicole Albertson
Here are the steps to pay for a product renewal on eOne's website:  Go to and select the Sign In button at the top, right-hand side of the screen.Be sure that eOne Portal is marked and select Sign In.Enter your email and password and select Sign In.Select the My Account >… [Read More]
  Thursday, November 3, 2022   /     Maksudul Haq
The following steps are for creating integration:If you do not have SmartConnect Login. See the Getting Started with Click on Connections, then Create Connection button. You will see all applications connections available list. Here is the Print screen… [Read More]
  Wednesday, July 13, 2022   /     Patrick Roth
I am running a SmartConnect integration to Microsoft Dynamics GP that works correctly on all my machines except for one.  On the problem machine, when the integration runs, it fails with the error:Login failed for user 'eonedemo\EONE-2014$'.[caption id="attachment_38604" align="aligncenter"… [Read More]
  Friday, July 1, 2022   /     David Youngquist
Installing the 32 bit Excel Add-in for SmartConnect 21.  It appears to install successfully, however it does not show up in Excel, and there is not any way to add it.  If you are using a 64 bit operating system, but you have 32 bit Excel installed, there is an additional registry setting that… [Read More]
  Friday, July 1, 2022   /     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"If you are on SmartConnect 2018 or lower you need… [Read More]