HELP ARTICLES

Help Articles

  Tuesday, March 28, 2017   /     David Youngquist
When launching SmartView internal, receiving an error that says "A network-related or instance-specific error occurred while establishing a connection to the SQL Server.  The server was not found or was not accessible.  Verify that the instance name is correct and that SQL Server is configured to… [Read More]
  Thursday, June 4, 2015   /     Nicole Albertson
Action Name: … [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]
  Wednesday, March 26, 2014   /     David Youngquist
Running a map with dollar amounts mapped to it.  For each transaction that tries to get imported, receiving an error that says "Failed to convert parameter value from a String to a Decimal".  The odd thing is if the transaction amounts are integers, the map runs.  It's only when decimal places… [Read More]
  Wednesday, December 17, 2014   /     David Youngquist
You may receive this error in SmartView internal or external depending on how many records you are returning and how many filters you have applied. … [Read More]
  Tuesday, October 20, 2015   /     Jared Dux
If you have modified one of the default Microsoft Dynamics GP SmartLists with SmartList Builder and would like to revert back to the default version of the list follow these steps:Open SmartList Builder.Set the SmartList Type to Existing.Set the SmartList ID to the list you would like to revert back… [Read More]
  Wednesday, January 18, 2017   /     Ethan Sorenson
When executing a map, we are getting this error. … [Read More]
  Thursday, May 26, 2016   /     Brady Swenson
Running a map using the WCF Webservice returns the error message "The Request failed with HTTP status 405: Method Not Allowed".Typically, this indicates an issue with the Real time and SmartList web service URL, which is found under the SmartConnect Dynamics GP Connector.To correct this issue, log… [Read More]
  Wednesday, May 14, 2014   /     Nicole Albertson
When launching Microsoft Dynamics GP, you get the message that SmartList Builder needs to finish installing.  It runs through the install, but when launching Microsoft Dynamics GP again, it prompts for the install again.Upon further review, the DexSQL.log and/or SQL Profiler Trace show errors on… [Read More]
  Wednesday, November 11, 2015   /     Patrick Roth
I'm running a SmartConnect integration and it is failing with the error - Cannot generate SSPI context. What does this error mean and how can I fix it?There are two reasons that you can get this error.If the integration has never worked due to this error, possibly you are running into a… [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