HELP ARTICLES

Help Articles

  Tuesday, March 31, 2015   /     eOne Solutions
The Lifecycle PolicyThis policy states the standard support policies for all eOne products. This policy went into effect on August 1st, 2014. The standard policy allows for 5 years of Standard support and 5 years of Extended support for a total of 10 years of support for the products included, with… [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]
  Friday, January 26, 2018   /     Nicole Albertson
This error may be caused by the Transport Layer Security  (TLS) version 1.2  being the only enabled version on the SmartConnect Server.  TLS 1.2 support for Microsoft SQL Server If you are using TLS 1.2 on your server that runs SmartConnect with TLS 1.0 and 1.1 turned off, the OLEDB Connection… [Read More]
  Wednesday, January 29, 2014   /     David Youngquist
When browsing to the SmartConnectWCF web service, receiving an error that says "Memory gates checking failed because the free memory (373817344 bytes) is less than 5% of total memory. As a result, the service will not be available for incoming requests."In order to resolve this, you need to edit the… [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]
  Thursday, December 8, 2011   /     Kevin
How to write a case statement in a data source query using the Microsoft ODBC Text driver. The syntax for a case statement using the Microsoft ODBC Text driver is different than it would be in SQL. This is an example of a case statement: iif(F15='DropShip','1661','2684') as ACCT This is… [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]
  Thursday, December 8, 2016   /     Nicole Albertson
The Employment History SmartList Builder setup is designed to return data similar to the new Employment History SmartList added in Microsoft Dynamics GP 2016 R2.  The Excel Report Builder and Navigation List Builder setups have been duplicated by eOne from the SmartList Builder setup. … [Read More]
  Thursday, December 8, 2011   /     Kevin
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 caused by 1 of 2 things.  Either the stored procedures… [Read More]
  Thursday, December 8, 2011   /     Kevin
A map runs correctly when run in the SmartConnect Map Setup screen, but will not run when scheduled.Here are typical things that cause it not to run. 1. The user assigned to run the scheduled task needs to be an administrator on the local machine. 2. The user assigned to run the scheduled… [Read More]
  Monday, December 17, 2018   /     Katie Soderberg
Our resellers have the opportunity to purchase SmartConnect.com 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]

FILTER BY PRODUCT


ARCHIVES

open all | close all

TAGS

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 SalesForce.com scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk