HELP ARTICLES

Help Articles

  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]
  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, 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]
  Tuesday, August 1, 2017   /     Lorren Zemke
When trying to log into SmartConnect we receive an error stating, Login failed for user 'SmartConnect'. This may occur trying to log into SmartConnect, running a map, trying to start the SmartConnect Windows Service. Basically, the error could occur anywhere in SmartConnect. … [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]
  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]
  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]
  Friday, June 16, 2017   /     Nicole Albertson
General Questions:  … [Read More]
  Friday, July 14, 2017   /     David Youngquist
When logging into SmartConnect, receiving an error that says, "Your login failed.  Please contact your system administrator".   … [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]
  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