HELP ARTICLES

Help Articles

How to update GL posting date on a receivables transaction

  Thursday, December 8, 2011   /     Kevin
There is nowhere to map a GL posting date when creating a receivables transaction. How can I set the posting date to the current date?If your posting setup is set so that the posting date is coming from the batch date, you can use the following script to update the GL posting date on the batch. In… [Read More]

Chunk file will not merge

  Thursday, December 8, 2011   /     Kevin
After installing SmartConnect, when I launch Dynamics GP, I do not get the message asking me if I want to add new code. This can be caused by several different things. 1. Check to make sure that the cnk file is in the correct directory. If the cnk file is not in the Great Plains directory it… [Read More]

Invalid URI: The hostname could not be parsed.

  Thursday, December 8, 2011   /     Kevin
When running SmartConnect System Maintenance, receiving an error that says "Invalid URI: The hostname could not be parsed."This message results when trying to unregister real time CRM triggers. If you are using CRM, there should be a URL listed in Tools - SmartConnect - Setup - Dynamics CRM. This… [Read More]

Where to change the SmartConnect web service address on SmartConnect 2010

  Thursday, December 8, 2011   /     Kevin
Cannot find the location to change/update the SmartConnect web service address.On the 10.0 and prior versions of SmartConnect, the SmartConnect web service location was set in the SmartConnect Setup window. (Tools - SmartConnect - Setup). On the 2010 and above versions, the web service location… [Read More]

A list of functions available in Extender and SmartList Builder calculations

  Thursday, February 21, 2013   /     David Youngquist
A list of functions available in Extender and SmartList Builder calculationsAt the following link, you will find a list of the functions that are available in the Extender and SmartList Builder Calculations. The document includes a definition of what the function does and a few syntax examples for… [Read More]

Call Tracking Template for Extender

  Thursday, June 4, 2015   /     Nicole Albertson
Form Name: … [Read More]

Manufacturing Potential Shortages SmartList Builder Template

  Tuesday, June 14, 2016   /     Nicole Albertson
The Manufacturing Potential Shortages SmartList Builder setup is built to give you a list of any potential shortages by looking at the picklists and inventory quantities.  The setups for Excel Report Builder and Navigation List Builder are duplicates of the SmartList Builder setup.ID:… [Read More]

Real Time SQL data source in SmartConnect

  Tuesday, October 21, 2014   /     David Youngquist
Attempting to create a real time SQL data source in SmartConnect.  During registration of the trigger, receiving a SQL error that says:Msg 6257, Level 16, State 1, Line 1CREATE ASSEMBLY for assembly 'eOne.SmartConnect.MSSQLServerRealTime' failed because the assembly is built for an unsupported… [Read More]

Using Linked servers in SmartList Builder

  Wednesday, December 17, 2014   /     David Youngquist
If you try to use a linked server in SmartList builder you will see that you cannot access any databases from the linked server.  If you have a SQL view that references a linked server you will receive an error saying:SQL Error 7405 ODBC SQL Server Driver Heterogeneous queries require the… [Read More]

List of SmartConnect tables

  Thursday, December 8, 2011   /     Kevin
Is there a list of SmartConnect tables available?You can download a list of the SmartConnect tables from here [Read More]

SmartConnect/eConnect does not create default distributions for Payables Manual Checks

  Wednesday, March 29, 2017   /     Patrick Roth
The user was creating Payables Manual Checks with SmartConnect and letting eConnect default the distributions for the check by setting the Create distributions mapping to 1. … [Read More]

Could not open a connection to SQL server when launching SmartView internal

  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]

Aged Trial Balance not showing up in SmartView

  Tuesday, February 21, 2017   /     David Youngquist
In SmartView, some users can see the "Aged Trial Balance" under Purchasing and Sales, and some users cannot.  The sa user, and anyone that is a poweruser can see it, however normal users cannot see these reports.  Where do I grant access to these two reports? … [Read More]

GL Intercompany Import Setup using SmartConnect

  Monday, February 20, 2017   /     Lorren Zemke
If you are using SmartConnect 20.16 or newer, eOne has automatically included the nodes for creating intercompany distributions. We will walk through the setup of a standard General Ledger Transaction integration with the one additional step of including the Intercompany mapping. Please note, this… [Read More]

AP Intercompany Import Setup using SmartConnect

  Monday, February 20, 2017   /     Lorren Zemke
If you are using SmartConnect 20.16 or newer, eOne has automatically included the nodes for creating intercompany distributions. We will walk through the setup of a standard Payables Transaction integration with the one additional step of including the Intercompany mapping. Please note, this does… [Read More]

Creating your own Dynamics GP Rolling Column

  Monday, February 13, 2017   /     Lorren Zemke
SmartConnect has an Additional Column type for the Dynamics GP Destination types called GP Rolling Column that is used to get the next transaction number from the Dynamics GP setup tables. This allows for maintaining the existing Dynamics GP numbering sequence for all transactions and prevents the… [Read More]

Connecting to Dynamics 365 Online

  Thursday, February 9, 2017   /     Katie Soderberg
If you're planning to integrate with Dynamics 365, one of the first things you'll do in SmartConnect is enter connection information about your Dynamics 365 instance into the connector setup window.  Whether you're simply updating the default CRM online instance in SmartConnect or you're starting… [Read More]

Cannot insert the value NULL into column ‘FAYEAR’

  Monday, January 30, 2017   /     David Youngquist
Running a Fixed Assets General map and receiving an error that says "Cannot insert the value NULL into column 'FAYEAR', table 'TWO.dbo.FA00902'; column does not allow nulls.  INSERT fails. … [Read More]

Running a map and the progress instantly goes to done with no record count, no successes, and no errors.

  Friday, January 27, 2017   /     David Youngquist
Running a map results in the map instantly saying it's done with no record count, no successes, and no failures … [Read More]

Scheduled map fails after adding an assembly to the SmartConnect script namespace.

  Friday, January 27, 2017   /     David Youngquist
SmartConnect has a feature that allows users to add scripting namespaces to enhance the scripting capabilities in any of the coding windows within SmartConnect.  This feature is accessed by going to the Maintenance Tab and then selecting Script Name Spaces.   … [Read More]
BY PRODUCT
BY DATE
open all | close all