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
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.
16-May-2014: First Post by Tracy Steere.
30-May-2014: First Post by Kevin Racer.
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 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
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
Browse by Tags
Developing for Dynamics GP
Tagged Content List
Dynamics GP Developer Insights: .NET Interop
Alice Newsam (Msft)
Hello, my name is Alice Newsam and I am software engineer on the Dynamics GP team focusing on Dexterity and I have a question for you: Have you ever thought to yourself while working in Dexterity “I know there’s a .NET class that does this. It would be handy to access that right about...
8 Jul 2014
Import and Export for Office in GP 2013
A customer ran across an interesting issue with Excel Based Budgeting after they upgraded to GP 2013. They had been using Excel Based Budgeting in GP 2010 successfully - mostly to import/update existing budgets based on their existing spreadsheets. What was successful in GP 2010, wasn't working...
29 Apr 2014
Display Specific Line in Sales Order Processing
This will be a 2-for-1 post today as the example given solves a frequently asked question and was used to solve a customer issue. The question I've seen a number of times before and been meaning to write about is: "How can I fill the Sales Order Processing scrolling window to a specific line?". With...
19 Feb 2014
Dynamics GP Crashes After Installing Addin
One thing we've noticed recently is an uptick of cases involving Visual Studio Tools assemblies causing Dynamics GP to crash after being installed. While I don't think this has anything to do with GP 2013, it does seem to happen on that version. Perhaps everyone is just going to the new version and...
6 Feb 2014
Developing with the Microsoft Dynamics GP 2013 Named System Database
Microsoft Dynamics GP 2013 introduced another long sought after feature.... The Named System Database. Instead of the System database being hardcoded to DYNAMICS, a different name can be selected when installing GP. So what does that mean? Well, it means that more than one Dynamics GP system can...
25 Jul 2013
How to create Dexterity Cross Dictionary Lookups
As you may know, I was one of the pioneers of Cross Dictionary Dexterity Development and have posted about it a number of times (also see Can I customise a 3rd party form with Dexterity? and Understanding Cross Dictionary Dexterity Development ). I am currently involved as a technical advisor on a...
16 Dec 2012
Quick Tip: Capturing the Save Event with Visual Studio Tools
I recently responded to a community post which was asking how to ensure that all save events from the Item Maintenance window were captured using Visual Studio Tools. The aim was to make sure that the additional fields added to the window with Modifier were saved when the item data in the window was...
7 Aug 2012
Using a GP Web Service Extension in the Connector for Microsoft Dynamics GP
The Connector for Microsoft Dynamics provides a powerful integration platform that can be customized and extended with the CRM Connector SDK and Web Services for Microsoft Dynamics GP SDK tool sets. The CRM Connector for Microsoft Dynamics GP page in PartnerSource has various downloads to get you started...
21 Jun 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
Quick Tip: Solving Dexterity Trigger Clashes
In a recent support case, I had the rare situation where Dexterity Triggers clashed. Dexterity allows third party developers to create triggers against various events and scripts in a Dexterity application (like Microsoft Dynamics GP). There are times where more than one third party product registers...
31 Jan 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
Quick Tip: Passing Parameters to Background Processes in Dexterity
A couple months ago there was a post on the Partner Forum about Dexterity Oddities . One of the points raised in the post was about passing a text datatype parameter to a procedure called in the background and the fact that the contents of the text variable are lost. The same code called in the foreground...
13 Oct 2011
Quick Tip: Hidden Forms, Command Forms and Dictionary Context issues
This quick tip follows on from my previous post: Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles . There are times when there is a requirement to have some fields on a hidden form (a form with non of the windows set to AutoOpen). One example is when you...
11 Oct 2011
Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles
Another Quick Tip for Dexterity developers. This one discusses what changes need to be made to an integrating Dexterity application when upgrading from pre version 10.0 code to version 10.0 or GP 2010 to handle the changes in the security model. When version 10.0 was released it changed the security...
25 Sep 2011
Quick Tip: Best Practice for Dexterity Version and Build Numbers
A common question that new Dexterity developers have is what should they use for the version and build numbers when creating a chunk dictionary for distribution. This post discusses how those numbers are used and what the best practice for setting their values is. The following Knowledge Base (KB...
9 Aug 2011
Quick Tip: Creating Dexterity System Variables
Hi everyone. This is another Quick Tip post for Dexterity developers. Vaidy's recent post: "Illegal Address Field" Error while accessing a Global , raised the issue and so I thought I would respond with an explanation. The issue is when you create a System Variable (global variable) from an existing...
1 Aug 2011
DayONE Encore Microsoft Dynamics GP Development Tools
If you missed the DayONE session presented by Mariano Gomez and I, now is your chance to catch up again - please come! It was standing room only!!! Wondering about whether to develop in Modifier with VBA, Dexterity, or Visual Studio Tools? Not sure which one might be the best fit for your development...
20 Jun 2011
Microsoft Dynamics Convergence 2011 Atlanta Sessions
Mariano also posted that the Microsoft Dynamics Convergence 2011 sessions are now out! . In case you missed his post, I wanted to make sure you have the details for the sessions that Mariano and I will be presenting. This year we are presenting a concurrent session for adminstrators, consultants and...
27 Jan 2011
Microsoft Dynamics GP Technical Conference 2011 Sessions
If you did not see Mariano's post, Microsoft Dynamics GP Technical Conference 2011 sessions now out! , I wanted to let you know that the Technical Conference sessions are now available and provide the details of the sessions I will be presenting with Mariano Gomez and Patrick Roth. This time around...
26 Jan 2011
Quick Tip: Account Number Not Fully Displayed In Custom Window
Depending on your customization, you might need to use Account Number fields. The field works OK but you notice that the account segments don't seem to fit correctly and are cut off. This could be an issue with the Account Format Setup in Dynamics GP to allow for "wide" account segment values such...
31 Dec 2010
IMHO: Why you should care about Microsoft Dexterity
Mariano Gomez, the Dynamics GP Blogster has written a great new article for IMHO With The Dynamics GP Blogster column on the Dynamics Community website. His article: Why you should care about Microsoft Dexterity discusses some of the history of development environments for financial software systems...
28 Oct 2010
Writing to An Event Log in a Visual Studio Tools Customization
So you are writing your top notch, one-of-a-kind Visual Studio Tools for Microsoft Dynamics GP customization. You've covered all the bases for any potential errors and just in case you miss any and an exception is thrown, you are catching the exception to write into an event log. This works great...
14 Oct 2010
Quick Tip: Changing Dexterity Script Debugger Context
This post is the first of a new style of blog post. The idea is to publish the response to a question that I have been asked as a "Quick Tip" so that others can benefit from the information. Over time we should end up with a few real gems of information... You never know, I could present 50 of them in...
13 Oct 2010
Windows Phone 7 Development Tools and Training
Last time I posted some articles about Windows Phone 7, Mariano (The Dynamics GP Blogster) jokingly asked if this blog had changed its focus to Windows Phone 7. Well, while Windows Phone 7 is not the primary subject matter for this blog, it is really cool and it is coming very soon and development...
29 Sep 2010
SQL Server Express Failing To Start Revisited
David Musgrave posted an interesting article a few days ago where compressed SQL Server database files caused the SQL Server service not to start. Happily, the event log message tells us exactly the issue and solution and when I read this I noted that this was SQL Server Express being used by the...
26 Sep 2010
Page 1 of 2 (34 items)
Social Media Sharing
© 2014 Microsoft Corporation.
Privacy & Cookies