Skip to content
+1-888-319-3663
Tech Tuesday

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

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

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

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

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]

RECENT POSTS


2021 Q4 Promotions
Connect with us at Directions EMEA 2021 in Milan!
eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

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