HELP ARTICLES

Help Articles

  Friday, July 14, 2017   /     Chris Hanson
Overview … [Read More]
  Tuesday, October 17, 2017   /     David Youngquist
Attempting to run SmartConnect maps using Excel as a datasource.  Maps have been working fine until recently when all my Excel maps starting giving the error that says, "Error [HY000] [Microsoft] [ODBC Excel Driver] Reserved error (-5016); there is no message for this error."  Double clicking on… [Read More]
  Friday, January 5, 2018   /     Nicole Albertson
The GL Trial Balance Summary by Period 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… [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]
  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, June 18, 2018   /     Nicole Albertson
The SmartList Favorites SmartList Builder setup is designed to return a list of SmartList Favorites along with their save level. … [Read More]
  Friday, June 16, 2017   /     Nicole Albertson
General Questions: … [Read More]
  Friday, January 5, 2018   /     Nicole Albertson
The GL Trial Balance Summary by Year SmartList Builder setup is designed to return the Beginning Balance, Yearly 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… [Read More]
  Friday, April 25, 2014   /     David Youngquist
When my user tries to run a map I am getting the error message "[ODBC Excel Driver] General error Unable to open registry key Temporary (volatile) Ace DSN for process"This is caused by the user not having the proper rights to read the folder location of the source file. Move the source file to a… [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]
  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