eConnect

SOP Taxes not automatically calculating when using SmartConnect and Avalara AvaTax

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 triggered on manually keyed transactions.  The approach to handling tax calculations…

[Read More]
SmartConnect Office Hours

SmartConnect Office Hours: Understanding eConnect Nodes

If you missed out on SmartConnect Office Hours last week, here is a quick summary of what we covered on Friday, December 13th, 2019:Our topic of the day was Understanding eConnect NodesWe discussed:What nodes are available?Node MaintenanceCustom NodesHere is the link to the recording.If you want to read more about eConnect nodes:Check out our blog: What Data Can…

[Read More]

The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

The user is running a SmartConnect integration to Dynamics GP.On one machine, the integration fails with the error:Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting…

[Read More]

Error Code 12005 not found when using Create Employee in SmartConnect

I’m running a SmartConnect map  to create employees using the Create Employee destination.  Most of the records are successful but a few give the error: Error Number = 12005  Stored Procedure=   Error Description = Error Codes were not found in table DYNAMICS..taErrorCode. Please insure that the table taErrorCode is up to update. 12005Since it doesn’t…

[Read More]

Error message when running the map “Conversion failed when converting the varchar value ‘The’ to data type Int.

Running a SmartConnect map using KEY2ACT eConnect nodes and receiving an error that says. “Conversion failed when converting the varchar value ‘The’ to data type Int.”   The word “The” might be replaced by the word “Job” or another random word.  This is caused by a setting in the Wennsoft eConnect nodes.  At the bottom of each…

[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 : Using Binary Stream eConnect procedures with SmartConnect

I quite often talk to customers using Multi-Entity Management from Binary Stream.  They have written some eConnect procedures that you can utilize from within SmartConnect.  Typically there are 2 steps to getting these nodes installed. You first need to get the installer from Binary Stream.  They have an installer that creates their eConnect procedures in all…

[Read More]
Tech Tuesday

Tech Tuesday : Write Back Error Message

 While doing an integration into Dynamics GP, have you ever wanted to be able to write back the error message returned by Dynamics GP to the source system? However, the error message is “too confusing”, so you would rather just show the error description to make it easier to read. For example, here is the…

[Read More]

RECENT POSTS


UPCOMING WEBINAR: So, You're Staying with Dynamics GP - Great!
eOne Office Hours Recap: SmartConnect for Complex Multi-Company Integrations
Q1 2021 Partner All Hands Call - Recording Now Available!
eOne Office Hours: SmartConnect for Complex Multi-Company Integrations
2021 Q1 Promotions

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

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