FMTFMT

eConnect Archives | FMT

Search Archive
How to Deal with eConnect Exceptions for Bank Transactions Integration in Dynamics GP
In this blog post, we are going to discuss how to deal with eConnect primary key exceptions. Let’s say there is a company called Fabrikam Inc. and they provided the data for Dynamics GP. We are going to leverage eConnect to integrate Bank Transactions into Dynamics GP. The eConnect Primary Key Exception When I try to integrate Bank Transactions into Dynamics GP, the eConnect throws an exception and the following message shows up "Violation of PRIMARY KEY constraint 'PKCM20100'. Cannot insert duplicate key in object 'dbo.CM20100'." This Primary Key error is thrown by the SQL Server whenever I tried to insert duplicate key values into the table. The primary key for the table dbo.CM20100 is a combination of two fields CMDNUMWK and VOIDED. Take a look at the screenshot below to view the schema of dbo.CM20100 table and highlighted the primary key. The Data Issue I analyzed the eConnect business […]
How to resolve eConnect API Timeout Errors
When creating an integration to Dynamics GP, you might encounter errors returned at some point in the process such as eConnect API Timeout Errors. Finding a solution can be overwhelming and time-consuming. So in this blog post, we will go over how we resolved them. Recently there was a requirement from one of our client to develop an integration to integrate Sales Orders into Dynamics GP. For the requirement, a .NET AddIn leveraging eConnect was developed. The .Net AddIn uses the eConnect serialization classes to construct an eConnect XML document and then uses eConnectMethods class to create the transaction into Dynamics GP. All was good until we faced an eConnect exception. The exception thrown by eConnect was “There was an error writing to the pipe: The pipe is being closed.”  The exception is due to the eConnect call getting timeout. In order to resolve the above issue, we need to […]
Microsoft Dynamics GP Integration Tools Guaranteed to Make Your Life Easier
Integration tools can be used to incorporate data from a variety of sources into Dynamics GP. They can also export data from Dynamics GP into many different file types such as text, Excel and XML. For some integrations, you will simply be moving data straight into Dynamics GP. For others, you will want to convert or manipulate the data prior to integrating it. Simple or complex, integration tools can make the whole process easier! The backbone of these tools is eConnect, a set of SQL stored procedures that can be installed for Dynamics GP. They are used to accept data and integrate it into the appropriate database tables. The eConnect stored procedures use business rules to validate the data before integrating it to GP, thus protecting the integrity of the data and only allowing you to insert valid data. Using eConnect without integration tools can be a complicated process. Which […]
Decrypting Microsoft Dynamics GP eConnect Stored Procedures
On a recent project, I had to decrypt an eConnect stored procedure – something you typically never have to do when using eConnect. eConnect provides both Pre and Post procedures for modifying business logic before passing a transaction through eConnect to Microsoft Dynamics GP (I advise against modifying any Dynamics GP stored procedures as it may cause problems down the road with upgrades). In my case, I was working on an integration using SmartConnect to insert a payables transaction into Dynamics GP. (If you haven’t used SmartConnect before, it’s a terrific tool for creating quick integrations to GP from other sources including flat files, SQL, CRM etc.; but that’s a blog for another day.) It was a pretty straightforward integration using eConnect and leveraging the taPMTransactionInsert procedure. However, I was running into issues because of an error caused by code written by a previous consulting firm in the post procedure […]
©
2021
 FMT Consultants, LLC.
|
Privacy Policy
X
FMT

Contact Us

X
FMT

Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram