eConnect

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]

You are not allowed to have negative actual quantity importing Project Accounting Timesheets

Importing Project Accounting Timesheets using SmartConnect and receiving an error that says, “Error Number = 1256 Stored Procedure= taPATimeSheetLineInsert Error Description = You are not allowed to have negative actual quantity”What typically causes this is importing a batch of timesheets, deleting the batch, and then importing them back in again.  In order to resolve the…

[Read More]

RECENT POSTS


Web request did not return any data. Verify the mapID is correct and try again.
Configure a Business Central Change Data Source
Failed to create record.: Entity does not support insert
Too Many Fields Defined After Microsoft Update
The operating system is not presently configured to run this application

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

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