HELP ARTICLES

Help Articles

  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]
  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]
  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]
  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, 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]
  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
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]
  Wednesday, October 23, 2019   /     Chris Hanson
With the purchase of a SmartConnect subscription plan, dual access rights are granted to the customer. If using the on-premise windows client of SmartConnect, registration keys will be needed to fully enable the product. If the hosted SmartConnect.com solution will be utilized, you will gain access… [Read More]
  Friday, September 27, 2019   /     Ethan Sorenson
If you have a lookup field on a record in CRM that you want cleared so it is blank you can use this process. SmartConnect will utilize the CRM SDK to remove the link between the two records.SetupIn this example I am going to remove the primary contact from an Account record. As part of the process… [Read More]
  Wednesday, September 18, 2019   /     David Youngquist
How can I recreate all the SmartList Builder stored procedures if I suspect some of them have been deleted or corrupted?Follow these steps to drop and create all the stored procedures for the SmartList Builder product1. Login to GP as the SA user. 2. Go to Microsoft Dynamics GP - Maintenance - SQL3.… [Read More]
  Friday, September 13, 2019   /     David Youngquist
Trying to setup the CRM Connector.  I have put "crm.dynamics.com" as the CRM server URL and put in my user name and password, and I receive the error "Failed to connect to the CRM server : Failed to get CRM Organizations : Access is denied".  I have triple checked my username and password and they… [Read More]
  Friday, September 6, 2019   /     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"This is caused by not having 32 Bit Excel/Office… [Read More]
  Wednesday, September 4, 2019   /     Ethan Sorenson
Cards in Nav/Business Central can have default dimensions assigned. These dimensions are not stored on the card, but rather in the Default Dimensions table. Therefore, after the card is created a second mapping will need to be used to add the dimensions.MappingA new web service will need to be… [Read More]
  Wednesday, August 28, 2019   /     Ethan Sorenson
When creating a Sales Order or Sales Invoice in Business Central, you will receive an error like the one shown above if trying to define a Ship-to Address.*Note that any code provided is for use as a point of reference and will not be supported by eOne Solutions. CauseWhen you change the… [Read More]
  Friday, August 23, 2019   /     Patrick Roth
I'm using the WinSCP application to connect to my SFTP server.I can connect and upload/download files successfully when using the WinSCP application included in the download, but when I try to connect via SmartConnect scripting per this blog article, it fails with the… [Read More]
  Friday, July 12, 2019   /     Ethan Sorenson
When importing a Sales Invoice or Sales Order to Business Central and receive the below error message.Type must be equal to 'Inventory' in Item: No.=XXXX. Current value is 'Service'.CauseThe line item has been setup as a Service type Item. This can be verified by checking the Item Card for the field… [Read More]
  Tuesday, July 9, 2019   /     David Youngquist
Attempting to start the "eOne SmartConnect Service" in Windows and receiving an error that says, "Error 1068: The dependency or group failed to start."Make sure that the user you have configured to start the "eOne SmartConnect Service" is an administrator in SmartConnect.  Also make sure that the… [Read More]

FILTER BY PRODUCT


ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk