Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Microsoft Dynamics GP Technical Conference 2009 Training Opportunities

    As you know, I have been encourqging 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....
  • Blog Post: Dexterity and Other Tools for v10.00 SP4 now available

    If you have not found it already, the Service Pack 4 update for Dexterity version 10.0 (build 10.00.0324) is now available for download. Please download and use it when developing Dexterity code which is meant to run on a Service Pack 4 system . Note: You will need to uninstall your previous version...
  • Blog Post: Where are Dynamics GP's Business Rules Defined and Enforced?

    In a recent forum post , the question of where the business logic for Dynamics GP resides was raised. This is an excellent question which, sadly, does not have a simple answer. When Great Plains Dynamics was first developed for the Ctree and Btrieve ISAM (flat file) databases, there was little demand...
  • Blog Post: Web Services Configuration Settings for Integrating Large Transactions

    It is definitely possible to use Web Services for Microsoft Dynamics GP to create large transactions. By large transactions I am referring to examples of where a sales invoice would have several thousands of lines on it. That's right, some companies are integrating transactions this large using our...
  • Blog Post: Development White Papers for Download

    I recently came across some development tool based White Papers which are available for download from Microsoft Downloads. I thought I would highlight them as they are worth a read: Creating a Windows Service That Uses eConnect to Integrate Data This...( read more )
  • Blog Post: How Many Lines can a Transaction have? and more Dynamics GP blogs

    The blogsphere continues to be a source of great information for the entire Microsoft Dynamics GP community. The Dynamics GP Blogster , Mariano Gomez, has tackled the age old question of Is there a maximum number of lines that can be inserted in any given...( read more )
  • Blog Post: Upcoming Microsoft Dynamics GP Workshops

    There are two Microsoft Dynamics GP workshops that have been scheduled to take place in Fargo, ND, USA the first week of June. We will be offering this workshop to both Partners and Deluxe/Premier Customers. The instructors for these workshops will be Dave Clauson for the Integration Manager workshop...