Developing for Dynamics GP
by David Musgrave (Perth, Australia) and Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)
Search this blog
Search all blogs
Email Blog Author
GP 2010 R2
GP 2013 R2
Menus for Visual Studio Tools
Notes & OLE Attachments
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.
23-Sep-2009: Created Twitter account 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.
28-May-2010: Created Facebook account 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.
16-May-2014: First Post by Tracy Steere.
30-May-2014: First Post by Kevin Racer.
18-Aug-2014: First Post by Lucas Miller.
17-Oct-2014: Last Post by David Musgrave.
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 Blogs at Dynamics Communities
Microsoft Dynamics GP Partner Forum
GPUG Member 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'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)
Armanino Dynamics Blog
Great Plains Guy (David Patrick's Blog)
Dynamics Financial Reporting
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)
Connector -- Integrating Dynamics ERP with Dynamics CRM
The Dynamics GP Geek Blog (Beat Bucher's Blog)
David Musgrave's Winthrop Development Consultants 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
Support Debugging Tool Build 18 released
Microsoft Convergence 2014 Atlanta - Wrap Up
Support Debugging Tool Build 18 hotfix released
Support Debugging Tool Build 19 released
David Musgrave - Time for a Change
Browse by Tags
Developing for Dynamics GP
Tagged Content List
Five Years later: Welcome to the Developing for Dynamics GP blog
Five years ago today, I decided that I could help the community better by writing about my experiences as a developer, consultant, administrator and support engineer with Microsoft Dynamics GP in a single location. Previously, I would respond to questions in a number of Microsoft forums and independent...
10 Jul 2013
Windows Logos through the years
With the upcoming General Availability release of Microsoft Windows 8 on 26 th October 2012, I thought it would be fun to take a look back at how the Windows logos have changed through the years. Back on 20 th November 1985, Microsoft released Microsoft Windows 1.0 which had the following logo with...
16 Sep 2012
Microsoft Logo updated
This week there was a significant change in the Microsoft world. It's been 25 years since we updated the Microsoft logo. Now is the perfect time for a change... This works nicely with the new logos for the Windows and Office logos: Check out this video which shows the new logos: ...
28 Aug 2012
End of an Era: Farewell Dave Gaboury & the Creation of Dexterity - Part 2
If you have not read the first post in this series, please read it now: End of an Era: Farewell Dave Gaboury & the Creation of Dexterity - Part 1 Here is the continuing story of the creation of Dexterity and Dynamics from Dave Gaboury. Although our progress was slow, our work on graphical...
28 Feb 2012
End of an Era: Farewell Dave Gaboury & the Creation of Dexterity - Part 1
Back in 1998 when I was experimenting with Cross Dictionary Dexterity Development in version 4.00 and version 5.00, I was contacted by Dave Gaboury from Great Plains in Fargo. He was currently developing cross dictionary triggers for Dexterity 5.10 and wanted my feedback and help testing the new Trigger_...
26 Feb 2012
Do not use the DEX_ROW_ID table column in your Customizations and Integrations
Today, I responded on a post on the Partner Forum asking " Can the DEX_ROW_ID change for a record over time? ". In this case the partner had seen the values for DEX_ROW_ID change on the GL20000 (GL_YTD_TRX_OPEN) and GL30000 (GL_Account_TRX_HIST) tables. This caused problems for an integration to an external...
15 Nov 2011
The Creation of the Support Debugging Tool
If you have seen me present on the Support Debugging Tool for Microsoft Dynamics GP , you know that I usually give a brief overview of why the tool was created. After a chat with my co-presenter, Mariano Gomez, The Dynamics GP Blogster , I decided that it would be worth explaining a bit more about the...
18 Aug 2011
April Fool: Microsoft Dynamics GP "12" to have support for Apple Macintosh
I have some exciting news for those of you who still work with Apple Macintosh computers. I have been given permission to "leak' another cool feature for the upcoming Microsoft Dynamics GP "12" release. Microsoft Dynamics GP "12" will have support for Apple Macintosh computers*, for details keep reading...
31 Mar 2011
Revisiting: "Welcome to Dynamics"
This post has me revisiting a post from the past with an update. While working on a performance case recently, I was analysing a Process Monitor log and noticed something interesting. In the log there was an attempt to reference a GPSSystemStart.wav file in the \Windows folder with the result failing...
30 Mar 2010
Blast from the Past - The Inside Track Series Concludes
I hope you have enjoyed the Blast from the Past - The Inside Track Series . To make life simpler, I have attached a zip file with all 10 of the original Inside Track pdf files. To finish off, here are some comments from the original author, Karl Gunderson: “You want to republish what?” was...
19 Jan 2010
Blast from the Past - The Inside Track - October 2001
This is article 10 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in October 2001. The Inside Track Please Step This Way, Part 2 October 2001 As I write this, less than a week has passed since the events in New York, Washington...
17 Jan 2010
Blast from the Past - The Inside Track - August 2001
This is article 9 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in August 2001. The Inside Track Please Step This Way, Part 1 August 2001 As a professional developer for over 20 years now (yikes!) at times I think maybe I...
12 Jan 2010
Blast from the Past - The Inside Track - June 2001
This is article 8 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in June 2001. The Inside Track Representative and Reactionary Programming June 2001 I'm back from my vacation. It was great, I saw many of the great natural...
10 Jan 2010
Blast from the Past - The Inside Track - March 2001
This is article 7 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in March 2001. The Inside Track, March 2001 UML – Understanding Meta Language If you've been around Great Plains for a while, you may have heard of the 3 C's...
5 Jan 2010
Blast from the Past - The Inside Track - February 2001
This is article 6 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in February 2001. The Inside Track "XML Reprise" February 2001 The Federal Trade Commission (FTC) has given the acquisition of Great Plains by Microsoft the...
3 Jan 2010
Blast from the Past - The Inside Track - January 2001
This is article 5 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in January 2001. The Inside Track "COM See, COM Saw" January 2001 If my titles get to be too cute, blast me some e-mail. That said I really like the title this...
29 Dec 2009
Blast from the Past - The Inside Track - December 2000
This is article 4 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in December 2000. The Inside Track "See Farther, See Sharper" [Ed: Should be Further :-) ] December 2000 Do you have a favorite ax? You know, musicians call...
27 Dec 2009
Blast from the Past - The Inside Track - November 2000
This is article 3 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in November 2000. The Inside Track November 2000 Did you see the Blondie comic on September 11, 2000? Check it out on www.blondie.com . In case you don't have...
22 Dec 2009
Blast from the Past - The Inside Track - October 2000
This is article 2 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in October 2000. The Inside Track From Here to There October 2000 In the last edition of The Inside Track, I introduced Microsoft’s .NET, Great Plains Platform...
20 Dec 2009
Blast from the Past - The Inside Track - August 2000
This is article 1 of 10 from the Blast from the Past - The Inside Track Series . This newsletter from Karl Gunderson was sent out in August 2000. The Inside Track August 2000 Welcome to a new column in the Solution Developer newsletter, The Inside Track. First off, let me tell you about...
15 Dec 2009
Blast from the Past - The Inside Track Series
As most of you know, before I worked for Microsoft, I ran Winthrop Dexterity Consultants . Well, I had a look at the old website recently and decided that it really needs to be updated. Since Winthrop sold the Omni Products to Rockton Software over three years ago, this is really long overdue. ...
13 Dec 2009
History of Great Plains and Microsoft Dynamics GP
As a fantastic follow-up to my previous posts about the history of Great Plains, Victoria Yudin and Mohammad Daoud brought to my notice a very detailed Timeline of Dynamics GP (and Doug Burgum) created by the team at DynamicsWorld UK . The timeline shows how Doug and the Burgum family are an integral...
7 Oct 2009
The History of Microsoft and more
For those of you interested in history of computing and Microsoft's involvement, take a look at the series of posts on the Channel 9 blog called the History of Microsoft. This series takes us from Microsoft's beginnings in 1975 through the years toward the current day. At this stage there are posts...
12 Aug 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
Understanding how Microsoft Dynamics GP works with Microsoft SQL Server continued
As a followup to last week's post about Understanding how Microsoft Dynamics GP works with Microsoft SQL Server , I am adding a few more topics about why Microsoft Dynamics GP works the way it does with Microsoft SQL Server. So here goes .... Transactions Since version 6.00, Dexterity (the development...
28 May 2009
Page 1 of 2 (35 items)
Social Media Sharing
© 2014 Microsoft Corporation.
Privacy & Cookies