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]
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]
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]
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 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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]