eConnect

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]

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]

Extra Purchase Distribution for Accounts Payable Transaction

We are importing Dynamics GP Accounts Payable transactions and there is an extra Purchase distribution showing up in our transaction with a blank account number. We are mapping our own distributions using the Add Distribution Node.   When mapping the distributions for Accounts Payable transactions, we need to turn off the automatic creation of distributions…

[Read More]

eConnect error 9498 – Creating Employee Pay Code

Trying to create a Dynamics GP Employee Overtime Pay Code, basing the Pay Rate amount based on the employee’s standard wage but I keep receiving the error 9498 – The Pay Type is Overtime or Doubletime and the Pay Factor multiplied by the Based On Rate does not agree with Pay Rate Amount (PAYRTAMT). I…

[Read More]

RECENT POSTS


Accessing SmartConnect after purchasing a subscription on behalf of your customer
Disassociate a CRM Record
How to drop and recreate all the SmartList Builder stored procedures
Failed to connect to the CRM server : Failed to get CRM Organizations : Access is denied
Connection could not be validated when using Excel data source

POPULAR POSTS


Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
SSL Security error using OLEDB Connection
Manufacturing Serial Trace SmartList Builder Template
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

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk