HELP ARTICLES

Help Articles

  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]
  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]
  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]
  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, 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
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]
  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, May 4, 2017   /     David Youngquist
Starting in Microsoft Dynamics GP 2013, there is a new option added to the SmartList window.  On a standard installation, pressing this button will open the Microsoft SmartList Designer product.  If you have SmartList Builder installed, pressing the button will open eOne SmartList Builder.   … [Read More]
  Thursday, December 8, 2011   /     Kevin
When trying to import notes into CRM using SmartConnect, you receive the following error: The entity with a name = '1' was not found in the MetadataCache.This occurs when the Object Type attribute is incorrectly mapped in the entity mapping screen. In CRM the Object Type is a picklist, but 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