eConnect

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 : 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 : 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 : 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]

How to run a SmartConnect map to an XML file

Often times it makes it easier to troubleshoot SmartConnect errors if you can see the exact data that is being submitted to eConnect.  You can do this by running a map to XML file and then opening up the file in a XML Editor.   Follow these steps to output a map to Microsoft Dynamics…

[Read More]

RECENT POSTS


Accessing your SmartConnect.com environment after purchasing on behalf of your customer at the eOne Shop
The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
SalesForce INVALID_LOGIN: Invalid username, password, security token; or user locked out.
Unknown identifier 'GenerateTableTypes'

POPULAR POSTS


Manufacturing Serial Trace SmartList Builder Template
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
How to update SmartConnect from 10.0.0.51 to SmartConnect 2014
Running a map in SmartConnect and receiving an error that says "The source was not found, but some or all event logs could not be searched."

CATEGORIES

ARCHIVES

open all | close all

TAGS

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