HELP ARTICLES

Help Articles

  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]
  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, 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 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 17, 2018   /     Ethan Sorenson
The full error message is:Metadata contains a reference that cannot be resolved: ‘https://yourinstance.api.crm.dynamics.com/XRMServices/2011/Organization.svc?wsdl&sdkversion=9’Microsoft changed CRM to use TLS 1.2 starting with the release of version 9. SmartConnect has been updated to use… [Read More]
  Monday, August 8, 2016   /     Brady Swenson
In the example below, I was attempting to import Items into Microsoft Dynamics NAV and received the following error message: "Failed to create record with keys No = TestA-1000 and No = TestA-1000". The Unit of Measure does not exist. Identification fields and values: Code = 'PCS'."To correct this, I… [Read More]
  Monday, January 16, 2017   /     Ethan Sorenson
A common error message that pops up when importing to Dynamics GP states: Node TransactionInsert not found in TransactionType. The element node is required for this transaction type. … [Read More]
  Wednesday, July 12, 2017   /     Lorren Zemke
I have an existing SmartConnect map that is pointing to an Excel file. If I add a new column to that file, I receive the error message 'Object reference not set to an instance of an object' when I click validate or preview. The map was working until I added the new column. … [Read More]
  Wednesday, June 2, 2021   /     Ethan Sorenson
When reading a REST API is common for custom fields and metadata related to a record be stored in an array. This creates a problem for SmartConnect because it parses each entry in the array as a separate line in your source. With the new source column type “ValueArray” we can now manually define… [Read More]
  Monday, April 19, 2021   /     Patrick Roth
I have created a SmartConnect email task and entered in multiple email addresses.  I have the same valid addresses on other email tasks that work fine however on this map task, SmartConnect throws the error:An invalid character was found in the email header: ','The issue is the format of the email… [Read More]
  Friday, April 2, 2021   /     David Youngquist
How can I use SmartConnect to import SOP Transactions with Avalara Avatax?SmartConnect utilizes Microsoft's eConnect procedures to import data into Dynamics GP.   According to this article on the Avalara website, "Using eConnect or another solution to import sales documents to Dynamics GP and… [Read More]
  Wednesday, March 31, 2021   /     Ethan Sorenson
ErrorWhen launching the SmartConnect client received the below message:Could not log into the SQL Servercould not initialize a collection: [eOne.SmartConnect.Engine.User.UserWebFormOptions#6c6113ce-075b-4d49-8ec1-9ea400bb6db8][SQL: SELECT userwebfor0_.UserId as UserId1_,… [Read More]
  Friday, February 5, 2021   /     David Youngquist
When opening a SmartConnect map that uses an Excel datasource, receiving an error that says this:ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x514 Thread 0x1d4c DBC 0xc1c85f4 Excel'.ERROR [01S00] [Microsoft][ODBC… [Read More]
  Thursday, January 21, 2021   /     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"If you are on SmartConnect 2018 or lower you need… [Read More]
  Tuesday, January 5, 2021   /     Ethan Sorenson
ErrorA user in Business Central is receiving the error:You do not have the following permissions on TableData eOneChangeMain: ReadCauseThe SmartConnect Change Tracking Extension is installed in Business Central, and the current user is not assigned the SmartConnect Change Tracking permission… [Read More]
  Tuesday, December 29, 2020   /     David Youngquist
When importing a SOP Batch using SmartConnect, my taxes are not getting automatically calculated, I am using Avalara AvaTaxAvalara does not have any eConnect procedures that will automatically trigger a tax calculation on documents pushed in from outside of GP.   The tax calculations are only… [Read More]
  Monday, December 14, 2020   /     David Youngquist
These downloads are provided only for adding new SmartConnect clients to already existing installations of SmartConnect.   Any new installations should be using the current version of SmartConnect which you can download on our SmartConnect Downloads pageSmartConnect 9 (9.1.0.51)SmartConnect 10… [Read More]
  Wednesday, October 28, 2020   /     David Youngquist
Using the Excel AddIn and attempting to run a SmartConnect map.  Receiving an error back that says "Web request did not return any data.  Verify the mapID is correct and try again."   The error message in the Excel AddIn looks like this:This means you do not have the ASP.NET components installed… [Read More]

FILTER BY PRODUCT


ARCHIVES

open all | close all

TAGS

Business Central CRM D365 Business Central 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 SmartPost SmartView SQL Tech Tuesday Templates training