eConnect transaction not rolling back

I ran across an interesting case the other day with eConnect.  I had a similar type of case I wrote about previously, but this one is for a completely different reason. The ISV was moving his working customization from GP 10.0 to GP 2010/2013. The Problem Essentially the customization would use eConnect to create a…

3

Handling Australian GST Requirements for Payables Transactions in eConnect

As part of the handling of Australian Good and Services Tax (GST), Microsoft Dynamics GP needs to be able to track if a Tax Invoice has been received for payables transactions. This is important as a company must have a Tax Invoice for a purchase before they are allowed to claim the Input Tax Credit…

2

Differences with SQL Transaction Rollback behaviour for eConnect for Microsoft Dynamics GP 2010

A recent case has highlighted some subtle differences in behaviour with eConnect for Microsoft Dynamics GP 2010 and the way it handles SQL transaction commit and rollback. Prior to Microsoft Dynamics GP 2010, if a XML Document file contained any transactions which generated errors from eConnect, the entire Document and all the transactions that have…

3

Product Suggestion: eConnect POP Tax Engine

Over the last few weeks, Mark Polino, MVP over at DynamicAccounting.net has been posting articles asking you to vote for Product Suggestions using the Microsoft Connect site. Well now it is my turn….   History To start with we need a little bit of history: When the Purchase Order Processing module in Great Plains Dynamics was…


Choosing between eConnect for Microsoft Dynamics GP and Web Services for Microsoft Dynamics GP

Should I write this integration using eConnect or Web Services for Microsoft Dynamics GP?   This is often a question we receive at conferences like Convergence or in support cases from both Customers and Partners.  Like most questions in our field, there really is no concrete answer to this one.  The answer is usually the dreaded “Well, it depends on…”.   What…

17

eConnect error – The stored procedure doesn’t exist

I ran across an odd eConnect issue a while back that I thought I’d share today. In this case, the customer had recently updated to GP 2010 and updated their application to eConnect 2010 from the previous version that worked fine. But now under GP 2010, when trying to run their eConnect integration it would…

3

Failed eConnect document leaves orphaned records

I assisted on an eConnect incident today that was quite interesting and I thought I’d share the case and the solution. The issue: The ISV was integrating a Payables Invoice using eConnect 10.0. The XML document had 2 distributions and the invoice data. What the ISV found was that there was an issue in the…

3

Leveraging the changes in eConnect for Microsoft Dynamics GP 2010

In this post I will talk about the changes made to the API for eConnect for Microsoft Dynamics GP 2010 and how developers can take advantage of these changes to affect their custom application.   If you have been using eConnect 2010 you have already realized that there is a new Windows service running called the eConnect for Microsoft Dynamics…

7

Quick Tip: Using eConnect to update Customer or Vendor Addresses with a blank Address Line 3

I had a case this week that was asking a fairly commonly asked question about integrating address information using eConnect. The scenario is that we want to update a customer or vendor address and the previous address had three lines in the address and the new address only has two lines. When the update is processed, Address Lines…

5

Creating a Custom Serialization Assembly for eConnect for Microsoft Dynamics GP 2010

The eConnect Programmer’s guide discusses creating a custom XML node and stored procedure so developers can process new types of data.   For example, a custom or 3rd party table could be updated when integrating a master record like a Customer or a transaction like a Sales Invoice using eConnect.   The strategy that I will discuss below is…

7

Procedure or function ‘aagCreateGLWorkDist’ expects parameter ‘@LedgerID’, which was not supplied

A number of support cases have popped up recently with this error message, it can occur when using eConnect to integrate General Ledger transactions or when using the eConnect Adaptor for General Ledger transactions from Integration Manager. Vaidy Mohan has some details in his post: GL With AA – IM2010 Integration – aagCreateGLWorkDist Error Message. The LedgerID…


Retrieve more than 1000 Records using Web Services for Microsoft Dynamics GP 2010

A question we have received in the past in Developer Support is how to retrieve more than 1000 records using Web Services.   The maximum number of records a GetList method will return is 1000 records.  This is by design as this value is coded into the call to eConnect and it cannot be changed with a configuration file.      If you have…

1

More Microsoft Dynamics GP 10.0 Service Pack 5 releases

Last month, we released Microsoft Dynamics GP 10.0 Service Pack 5. Since then many other components of the Microsoft Dynamics GP suite have had Service Pack 5 releases. This includes the Dexterity Development Environment build 10.00.0331. Check out the links below:   PartnerSource Feature Pack 1 DVD with SP5: Product Release Downloads for Microsoft Dynamics GP…

2

Microsoft Dynamics GP 10.0 Service Pack 5

Great News. The long awaited Microsoft Dynamics GP 10.0 Service Pack 5 for English Installations is now available!!  [Edit] This Service Pack brings SQL Server 2008 R2 compatibility to Microsoft Dynamics GP 10.0. Please make sure you read all the hot topics and notes BEFORE installing, especially this new FAQ which explains some important changes:…

9

Microsoft Dynamics GP 2010 Software Development Kits Released

The Software Development Kits for the various parts of the Microsoft Dynamics GP 2010 application have been released to CustomerSource and PartnerSource.  The links are below:    Microsoft Dynamics GP 2010 Application Software Development Kits Software Development Kit (SDK) for Microsoft Dynamics GP 2010 (CustomerSource) Software Development Kit (SDK) for Microsoft Dynamics GP 2010 (PartnerSource)   Software Development Kit (SDK) for Business…

6

Serializing CDATA tags in eConnect XML Documents

I had a recent support incident where the customer was trying to update a field to a blank value using the eConnect serialization assembly and the value was not being removed.  Specifically, they were attempting to remove the existing value in the ADDRESS2 column of the RM00101 table by setting the string value to a blank…

1

How to filter Dynamics GP Notes – Not!

A month or three ago, I had a case where special characters entered into a Note on a Sales Invoice were causing the eConnect Requester to fail.  Since the Requester utilizes XML to pass the data, characters like Control-B can cause problems.  If you want to see the Note entry screen in Dynamics GP you could…

1

Fixed Asset Integration error: "String was not recognized as a valid DateTime"

I recently had a support case, running a Fixed Asset integration with Integration Manager, where we received the following error: DOC 1 ERROR: System.FormatException: String was not recognized as a valid DateTime.at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)at System.DateTime.Parse(String s, IFormatProvider provider)at System.Convert.ToDateTime(String value, IFormatProvider provider)at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)at System.Data.SqlClient.SqlParameter.CoerceValue(Object…


Filtering eConnect Requester data

I wanted to tell you about a recent case I had where the Partner was trying to restrict the Microsoft Dynamics GP data they had selected with the eConnect Requester Setup Tool. They were first importing some of their Sales Orders from an external system into GP with eConnect.  Then when they fulfilled and shipped the…

6

Microsoft Dynamics GP Technical Conference 2009 Training Opportunities

As you know, I have been encouraging all technical partner consultants and developers to register for and attend the upcoming Microsoft Dynamics GP Technical Conference 2009 in November.  Well, the reason is not just because I will be there presenting a couple of sessions with my good friend Mariano. Also, it is not just that the conference…

2