HELP ARTICLES

Help Articles

  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 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]
  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]
  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]
  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]
  Wednesday, July 11, 2018   /     Patrick Roth
I have a Shopify REST connector set up in SmartConnect that has been working for some time.Now when I try to run a SmartConnect map using that Shopify REST connector as either a source or destination I get the error:Connection could not be validated.The underlying connection was closed: An… [Read More]
  Wednesday, January 18, 2017   /     Ethan Sorenson
When executing a map, we are getting this error. … [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]
  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, December 27, 2019   /     Ethan Sorenson
OverviewSmartConnect will automatically find new Objects and fields added to SalesForce by parsing the metadata provided by the Salesforce web services. This article will go through the steps to resolve cases where an Object or field is not visible for use in SmartConnect.Connector SetupCheck the… [Read More]
  Thursday, December 12, 2019   /     Ethan Sorenson
Failed to retrieve data from source: Attempting to select a readonly publisher for solutionCauseThis error occurs when attempting to create a Dynamics 365 CRM Change Data Source. The cause is a publisher with the prefix eone already exists in CRM and is assigned to a managed… [Read More]
  Tuesday, December 10, 2019   /     Michelle Aune
eOne Solutions is delighted to offer a SmartConnect Solution Success Manager.Your Solution Success Manager is fully committed to your success using SmartConnect and wants to make sure you’re aware of the resources and benefits included with your SmartConnect purchase.Shortly after your purchase,… [Read More]
  Tuesday, December 10, 2019   /     Michelle Aune
eOne Solutions is committed to the success of each SmartConnect sale and provides a solution success manager, Michelle Aune, to assist in launching each SmartConnect project. We know some customers will want to hand you their integration project and let you manage it entirely. That’s great. In… [Read More]
  Thursday, October 31, 2019   /     Ethan Sorenson
For connectors that connect to a database on a local server, you will need to open a port to allow SmartConnect to access them. To protect your security, you can add firewall white list rules to only allow SmartConnect in. The IP addresses that require access vary depending on your app login… [Read More]
  Monday, October 28, 2019   /     Chris Hanson
With the purchase of a SmartConnect subscription plan, dual access rights are granted to your company. 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]
  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]

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 error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartView SOP SQL Support Tech Tuesday Templates training