Posts by Lorren Zemke
Tech Tuesday : What Data Can SmartConnect Integrate in Dynamics GP (eConnect)
A question that comes up many times each month is whether SmartConnect can integrate to specific tables or tables in Dynamics GP, whether it’s Human Resources, Manufacturing, Void Payables, Apply Payables, and many other modules. Typically, we will point them to the eConnect documentation, the Microsoft API for data integrations, but it probably doesn’t provide…
[Read More]
Tech Tuesday: SmartConnect Setup for Office 365 E-Mail with TLS
Recently we have encountered multiple customers who have TLS turned on for communication with their Office 365 Email system instead of SSL. This in turn prevents their SmartConnect system from sending emails on map tasks.Just in case you are not aware of the ability to send emails within SmartConnect, click here for a refresher on…
[Read More]
Tech Thursday: SmartConnect Configuration Utility
Within the SmartConnect executable folder, there is a wonderful tool called eOne.SmartConnect.Config.exe. This tool allows for corrections to the SmartConnect configuration file. By default, the SmartConnect configuration file is encrypted so we cannot manually modify it and this utility gives us that option. Typical SituationsHere is a list of typical items the Configuration Utility will…
[Read More]
Tech Tuesday: Troubleshooting Folder Data Source
The folder data source within SmartConnect is a great way to automate an integration where the name of the file is not known at integration time or there are many files that need to be integrated throughout the workday. However, since the integration typically runs on a schedule, troubleshooting why some documents don’t process can…
[Read More]
Tech Thursday: Referencing a SmartConnect Calculated Field
SmartConnect On-premise utilizes .NET scripting for creating data transformations that are more complex than can be used for the Translation Table, Date Translation or Rolling Column additional columns. However, while it is not capable of creating functions or methods to be used between integrations, calculated fields can be referenced and used within the same map.…
[Read More]
Tech Tuesday: SmartConnect WCF REST Service Methods – runmap
One of the components of SmartConnect is the WCF REST service that may be installed on a machine where IIS is also installed. This document is a series of KnowledgeBase Articles that are written to show how the use and execute existing SmartConnect API methods. runmap The runmap method allows you to run a map…
[Read More]
Tech Tuesday: Calculating Sequence Numbers when Creating General Ledger Transaction with Analytical Account (AA)
In a prior article I discussed how to create General Ledger Transactions while including Analytical Accounts but with the assumption that if the Distribution Sequence number is being mapped, based on the scenario, it would be a part of the source data. It turns out that is rarely the case. This article will show how…
[Read More]
Finding and fixing the Unbalanced GL Entry Distribution. eConnect Error Number = 944
One of the most fun (insert sarcastic emoji) items to troubleshoot is eConnect error 944, Unbalanced journal entry, the credits do not equal the debits. The difficulty with this error is eConnect cannot not show which distribution(s) causes the transaction to be out of balance and with large Journals, searching through a source file or…
[Read More]
Tech Tuesday : Implement Extender Form Next Number for SmartConnect Import
With an Extender form, you can create standalone data within the Dynamics GP environment. With this standalone data, there are many times where the users should not enter their own ID/Key value so the numbering sequence stays consistent. In this case, we can set the ID field on the Extender Form to Auto Increment. The…
[Read More]
Tech Thursday : Query data in SmartConnect with .NET scripting
This article will show the basics of using a SmartConnect scripting to query additional data during an integration with the focus on the MSSQL ADO.NET Provider. With the capabilities of .NET in a SmartConnect calculated field or script task, almost any piece of data can be read or updated, if one of the Microsoft ADO.NET…
[Read More]