Developing for Dynamics GP
by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)
Search this blog
Search all blogs
Email Blog Author
GP 2010 R2
Menus for Visual Studio Tools
Notes & OLE Attachments
Row Level Filtering
Source Code Control
Source Code Program
Support Debugging Tool
Visual Studio Tools
Dates of Interest
11-Jul-2008: Blog Created by David Musgrave.
03-Oct-2008: Syndicated to the
10-Oct-2008: First Post by Scott Stephenson.
04-Nov-2008: First Post by Dave Dusek.
11-Nov-2008: First Post by Beth Gardner.
28-Nov-2008: First Post by Chris Roehrich.
30-Dec-2008: First Post by Patrick Roth.
24-Feb-2009: First Post by Greg Willson.
22-Apr-2009: First Post by David Clauson.
04-May-2009: First Post by Ryan Wigestrand.
19-Jun-2009: First Post by Dawn Langlie.
03-Jul-2009: First Post by Emily Halvorson.
with blog feed.
20-Nov-2009: First Post by Alice Newsam.
21-Apr-2010: First Post by Allan Cahill.
19-May-2010: First Post by Marian Verzosa.
24-May-2010: Blog Migrated to new Platform.
with blog feed.
15-Aug-2011: First Post by Development team.
15-Sep-2012: First Post by Aaron Donat.
27-Sep-2012: First Post by Jason Lech.
23-Jul-2013: First Post by Lee Butenhoff.
Social Networking & Syndication
Follow David Musgrave and the blog on:
This blog at
Inside GP Blog:
GP Support Blog:
Menus for VST:
This blog is provided "AS IS" with no warranties, and confers no rights.
The links in this blog may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.
WorldMaps Statistics since 24-Feb-2009:
Click for WorldMaps Stumbler
Translate this page
General Articles & Links
Modifier & VBA Articles & Links
Dexterity Articles & Links
Developer Toolkit Articles & Links
Modifier & VBA Samples
Developer & Consultant Articles & Links
Report Writer Articles & Links
Developer Toolkit Samples
Microsoft Dynamics GP Blogs
Support Debugging Tool Portal
Menus for Visual Studio Tools Portal
Newsgroups & Forums Links
Microsoft Dynamics GP Community Forum
Great Plains Tek Tips Forum
Microsoft Dynamics GP Partner Forum (Old)
Microsoft Dynamics GP Blogs at Dynamics Communities
Microsoft Dynamics GP Partner Forum
Dynamics GP Support and Services Blog
DynamicAccounting.net (Mark Polino's Blog)
The Dynamics GP Blogster (Mariano Gomez's Blog)
Microsoft Dynamics GP UK Blog
Microsoft Dynamics GP (Duke DelPrado's Blog)
Microsoft Dynamics GP Blogs Page
VSToolsForum.com (Steve Gray's Blog)
About Dynamics, Development and Life (Jivtesh Singh's Blog)
DynExtra (Habib Salim's Blog)
The Death of Reason (Dwight Specht's Blog)
BlogMS - Official Microsoft Team Blogs
Dynamics GP Land (Christina Phillips, Steve Endow & Lorren Zemke's Blog)
Victoria Yudin's Blog
Dynamics GP Learn & Discuss (Vaidy Mohan's Blog)
Mohammad Daoud's Blog
Catherine Eibner's Blog
Rose Business Solutions Blog
Merit Matters Blog
GP2theMax (Frank Hamelly's Blog)
Dynamics Confessor Blogspot (Leslie Vail's Blog)
Interesting Findings & Knowledge Sharing (Sivakumar Venkataraman's Blog)
Dynamics GP Middle East (Feradh Zain's Blog)
MBS Guru (Michael Johnson's Blog)
Inside Microsoft Dynamics GP (Official Blog)
ComputerationDynamics (Gloria Braunschweig's Blog)
Microsoft Dynamics Partner Community Blog
Q Factor's Blog (Constance Gilleland's Blog)
Dynamics Small Business (Matt Landis' Blog)
DynamicsBlogger (Janakiram M.P.'s Blog)
DynamicsGP.ie (Ian Stewart's Blog)
Dynamics Solution Edge (AMLLP Consulting's Blog)
Great Plains Guy (David Patrick's Blog)
Dynamics CPM (Corporate Performance Management)
Waqas Butt's Microsoft Dynamics GP Blog
eOne Business Solutions Blog
Real Life Dynamics User (Ron Wilson's Blog)
In Touch with Dynamics GP (Touchstone Group's Blog)
Dynamics GP - Knowledge Share (Sandip Jadhav's Blog)
Andy Nifong's Blog
Dynamics GP Builders & Reporting (Devon Southall's Blog)
Summit Group Software Blog
Belinda, the GP CSI (Belinda Allen's Blog)
GPWindow.com - Your window into Dynamics GP Resources
Dynamics Latam Blog
Dynamics for Distribution (Todd McDaniel's Blog)
Omar H. Kloub's Blog
Kuntz Consulting Blog (Jen Kuntz's Blog)
Aaron Berquist - High Dynamic Range
Dynamics GP Blog (Imtiaz Ahmed's blog)
Dynamics GP Help (Rubalpal Kaur's Blog)
Inside Dynamics GP Blog
Microsoft Dynamics GP Discussion (Samuel Mathew's Blog)
BKD Dynamics GP Insights Blog
Andrew Karasev's Blog
MonzerOsama.com (Monzer Osama's Blog)
azurecurve (Ian Grieve's Blog)
Microsoft Dynamics GP DBA (John Lowther's Blog)
Accidental Administrator (John Lowther's other Blog)
Dynamics GP Essentials (Mahmoud M. AlSaadi's Blog)
Dynamics Tips (Venugopal G.A.'s Blog)
Create Support Incident
Search Knowledge Base
Microsoft Dynamics GP Developer Center
Microsoft Connect: Add a Product Suggestion
Microsoft Dynamics GP Demo Site
Microsoft Dynamics Partner Solutions
Microsoft Dynamics Partner Community
Microsoft Dynamics ISV Solutions (PartnerSource)
Microsoft Dynamics GP Solution Center (PartnerSource)
GPWindow.com - Your window into Dynamics GP Resources
Microsoft Dynamics GP Community
GP Logos through the years
Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0
Support Debugging Tool for Microsoft Dynamics GP
Cross Dictionary Dexterity Development
How to get started with Dexterity
Support Debugging Tool - The wait is over
Choosing a Development Tool
Microsoft Dynamics GP Technical Airlift 2008
Menus for Visual Studio Tools - The wait is over
Finding Table and Field Information in Microsoft Dynamics GP
Microsoft Dynamics GP Application Level Security Series
Useful SQL Scripts Series
Support Debugging Tool Build 10 released
Translating Dexterity Applications Series
Why does Microsoft Dynamics GP encrypt passwords?
Support Debugging Tool Build 11 released
Automating Distribution of Customizations
Installing the Support Debugging Tool for Microsoft Dynamics GP FAQ
Understanding Cross Dictionary Dexterity Development
Microsoft Dynamics GP Technical Conference 2009 Wrap Up
Support Debugging Tool Build 12 released
Support Debugging Tool for Microsoft Dynamics GP 2010 Beta
Microsoft Dynamics Convergence Atlanta 2010 Wrap Up
Support Debugging Tool Build 13 released
Menus for Visual Studio Tools Build 9 Released
Getting the most out of your Microsoft Dynamics GP Community
Why can't I run Microsoft Dynamics GP via ODBC over a WAN?
Support Debugging Tool Build 14 released
Microsoft Dynamics GP Technical Conference 2011 - Wrap Up
The Great West Australian Bike Ride - Wrap Up
Microsoft Convergence 2011 Atlanta - Wrap Up
Support Debugging Tool Build 15 released
Support Debugging Tool Build 16 released
Microsoft Convergence 2012 Houston - Wrap Up
Understanding the Support Debugging Tool Series
Support Debugging Tool Build 16 Hotfix released
Support Debugging Tool Build 17 released
Menus for Visual Studio Tools Build 9 for Microsoft Dynamics GP 2013 Released
Support Debugging Tool Build 17 hotfix released
Microsoft Convergence 2013 New Orleans - Wrap Up
Microsoft Dynamics GP Technical Airlift 2013 Wrap Up
Browse by Tags
Developing for Dynamics GP
Tagged Content List
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...
1 Nov 2013
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...
28 Jul 2013
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...
14 Oct 2012
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...
8 Jul 2012
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...
26 Apr 2012
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...
10 Feb 2012
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...
27 Jan 2012
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...
22 Sep 2011
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...
25 Aug 2011
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...
2 Dec 2010
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...
12 Nov 2010
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...
29 Oct 2010
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...
7 Sep 2010
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...
18 Aug 2010
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...
14 Jun 2010
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...
18 Mar 2010
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...
4 Mar 2010
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...
28 Jan 2010
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...
3 Dec 2009
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....
30 Sep 2009
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...
15 Sep 2009
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...
2 Aug 2009
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 Web...
26 Jun 2009
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 article explains how to use eConnect, Microsoft...
19 May 2009
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 scrolling window? He explains that the answer...
13 May 2009
Page 1 of 2 (39 items)
Social Media Sharing
© 2013 Microsoft Corporation.
Privacy & Cookies