Skip to content
+1-888-319-3663

HELP ARTICLES

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]
  Tuesday, March 31, 2015   /     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]
  Wednesday, June 2, 2021   /     Ethan Sorenson
When reading a REST API is common for custom fields and metadata related to a record be stored in an array. This creates a problem for SmartConnect because it parses each entry in the array as a separate line in your source. With the new source column type “ValueArray” we can now manually define… [Read More]
  Monday, April 19, 2021   /     Patrick Roth
I have created a SmartConnect email task and entered in multiple email addresses.  I have the same valid addresses on other email tasks that work fine however on this map task, SmartConnect throws the error:An invalid character was found in the email header: ','The issue is the format of the email… [Read More]
  Friday, April 2, 2021   /     David Youngquist
How can I use SmartConnect to import SOP Transactions with Avalara Avatax?SmartConnect utilizes Microsoft's eConnect procedures to import data into Dynamics GP.   According to this article on the Avalara website, "Using eConnect or another solution to import sales documents to Dynamics GP and… [Read More]
  Wednesday, March 31, 2021   /     Ethan Sorenson
ErrorWhen launching the SmartConnect client received the below message:Could not log into the SQL Servercould not initialize a collection: [eOne.SmartConnect.Engine.User.UserWebFormOptions#6c6113ce-075b-4d49-8ec1-9ea400bb6db8][SQL: SELECT userwebfor0_.UserId as UserId1_,… [Read More]
  Friday, February 5, 2021   /     David Youngquist
When opening a SmartConnect map that uses an Excel datasource, receiving an error that says this:ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x514 Thread 0x1d4c DBC 0xc1c85f4 Excel'.ERROR [01S00] [Microsoft][ODBC… [Read More]
  Thursday, January 21, 2021   /     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]
  Tuesday, January 5, 2021   /     Ethan Sorenson
ErrorA user in Business Central is receiving the error:You do not have the following permissions on TableData eOneChangeMain: ReadCauseThe SmartConnect Change Tracking Extension is installed in Business Central, and the current user is not assigned the SmartConnect Change Tracking permission… [Read More]
  Tuesday, December 29, 2020   /     David Youngquist
When importing a SOP Batch using SmartConnect, my taxes are not getting automatically calculated, I am using Avalara AvaTaxAvalara does not have any eConnect procedures that will automatically trigger a tax calculation on documents pushed in from outside of GP.   The tax calculations are only… [Read More]
  Monday, December 14, 2020   /     David Youngquist
These downloads are provided only for adding new SmartConnect clients to already existing installations of SmartConnect.   Any new installations should be using the current version of SmartConnect which you can download on our SmartConnect Downloads pageSmartConnect 9 (9.1.0.51)SmartConnect 10… [Read More]
  Wednesday, October 28, 2020   /     David Youngquist
Using the Excel AddIn and attempting to run a SmartConnect map.  Receiving an error back that says "Web request did not return any data.  Verify the mapID is correct and try again."   The error message in the Excel AddIn looks like this:This means you do not have the ASP.NET components installed… [Read More]