Help Articles

  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]
  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, 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]
  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]
  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, 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]
  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, 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]
  Thursday, December 8, 2011   /     Kevin
How to utilize Binary Stream Multi Facility Nodes in SmartConnect.First you must obtain and install the Multi Facility eConnect nodes from Binary Stream Software, Inc. Run the stored procedures according to the instructions supplied with the nodes. This document describes how to add the Facility ID… [Read More]
  Wednesday, December 21, 2016   /     Katie Soderberg
When you integrate with Microsoft Dynamics 365 for Financials using SmartConnect, you are able to integrate with all the data in your instance that is published to web services. In Microsoft Dynamics 365 for Financials, only some of the objects are published to web services by default.  However,… [Read More]
  Monday, December 17, 2018   /     Katie Soderberg
Our resellers have the opportunity to purchase 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]



open all | close all


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 scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk