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
VBA: DUOS data stored in the wrong database after switching companies
A while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation. Everything worked fine until the users switched companies. After switching company the VBA customisation would still be connected to the...
31 Aug 2014
Microsoft Dynamics GP 2013 R2: VBA and the Action Pane
Hello! I just want to first take a second to introduce myself since this is my first post on the Developing for Dynamics GP blog. My name is Lucas Miller and I've been supporting Microsoft Dynamics GP since 2005. Like much of the team I'm based out of Fargo, ND, USA. I've been married for almost 2...
17 Aug 2014
Customising the Company Login window series Part 2 - Visual Basic for Applications
Following on from my previous post: Customising the Company Login window series Part 1 - Introduction , here is the method to create a solution using Visual Basic for Applications (VBA). As discussed in the earlier post, the problem we are trying to overcome is that the company drop down list on the...
20 Jul 2014
Customising the Company Login window series Part 1 - Introduction
Recently a comment from David M (not me) was posted on the Support Debugging Tool Portal ( http://aka.ms/SDT ) page asking: "We have some fairly long names for our GP companies. Well, when logging onto GP, the second "Company Login" screen cuts off the company names too short for us. The entry field...
22 Jun 2014
More on SQL Server Connection issues with Microsoft Dynamics GP
I have been working on a recent support case that had a situation that makes me want to raise this topic again. In the past, I have posted a number of articles discussing reasons for connections to SQL Server to be lost. When Microsoft Dynamics GP loses its connection to SQL Server, the Dexterity...
22 Apr 2014
All About Listbox, Button Drop Lists, and Drop Down Lists
It seems like a trivial subject for our dedicated readers but we had a new customer who is just learning Dexterity and he was having trouble recently trying to select items out of a ListBox. And just today the issue came up about Drop Down Lists (DDL) and getting the value selected using VBA in a different...
29 Oct 2013
Quick Tip: Where does that customisation come from?
I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots. The answer to the question is that the method to change the URL depends on what tool was...
20 Oct 2013
Quick Tip: VBA ADO Connection Run-time error '3709'
It has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while. When using VBA on a window with ActiveX Data Object (ADO) to connect to SQL Server to read and/or write data to tables, the best practice is to...
10 Apr 2013
MVP updates: Victoria Yudin's MVP status renewed and Leslie Vail's Developing Microsoft GP Business Applications book
I am still on leave for another week, but thought I would post about some updates from our Most Valuable Professional (MVP) community. Victoria Yudin has been awarded MVP status for the ninth consecutive year. Well done on the fantastic achievement. Have a look at her article below: Happy New...
6 Jan 2013
Quick Tip: Using fields named as reserved words with Visual Basic for Applications
I had a case today that raised an issue that I have seen before which has a simple solution. The Problem In summary, when you add a field to Visual Basic from Microsoft Dynamics GP, the name of the field is set to the text in the the linked prompt for that field (or the caption text for buttons...
9 Sep 2012
Quick Tip: Working with VBA, Extender and Sales Transaction Entry
I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server . The...
23 Dec 2011
Quick Tip: Passing Date and Time Variables to SQL Server
As a follow on from yesterday's post, Quick Tip: Passing Variables to SQL Server , I wanted to discuss the related topic about passing of date and time variables. There are two main issues we see with passing Dates and Times and both can cause SQL Server to throw the following exception: /* Date...
15 Dec 2011
Quick Tip: Passing Variables to SQL Server
Wow, the week is almost over and I am yet to post something. This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows...
15 Dec 2011
Microsoft Convergence 2011 Atlanta - Day 2
Today was the first "Official" day of the Convergence conference. After meeting Leslie and Sheila for breakfast, we went to the Open Keynote: Winning with Microsoft Dynamics . The session is now available from Virtual Convergence , please use this link: Winning with Microsoft Dynamics . The session...
12 Apr 2011
Customizations to the Cash Receipts (RM_Cash_Receipts) window failing for GP 2010
I have had a number of support cases and newsgroup posts recently about Customization to the Cash Receipts (RM_Cash_Receipts) window failing to work for Microsoft Dynamics GP 2010 when they worked for previous versions. The problem is that the code appears to work, but the Document Number field is...
17 Mar 2011
Dexterity Training in Orlando (May 16th to 20th 2011)
Finally, you have another opportunity to learn the foundations of Developing for Dynamics GP using Dexterity. The Microsoft Dynamics GP client application is developed using Dexterity. Many of the features of the Dynamics GP interface are the way they are because of the how Dexterity works. Having...
22 Feb 2011
Dynamics Report Writer is the Best Report Writer in the World cont.
This is a follow up post to my earlier post , which demonstrated how Report Writer when combined with the power of Visual Basic for Applications (VBA) was able to create a customisation that would not have been possible with Report Writer alone. In fact, I would be fairly surprised if any report writer...
5 Dec 2010
Using Barcodes from the Dynamics GP Report Writer
A few months ago, I worked on a support case where we needed to add a barcode to a Sales Order Processing transaction print out. We were able to achieve what we needed using Visual Basic for Applications (VBA) to handle some of the scripting for us. I have been meaning to write a blog post on how to...
23 Nov 2010
Dynamics Report Writer is the Best Report Writer in the World
Alright, maybe I am stretching the truth a little, but I do get frustrated when people discount the Dynamics Report Writer as a useful tool. [Edit] I am not biased at all.... honest. I recently worked on a support case where the partner had spent a significant amount of time trying to get Report Writer...
22 Nov 2010
File not found: VBA6.dll error occurs or GP crashes
This is a follow up to my previous post on the VBA6.dll not found error (for 64-bit). I have found this can occur on 32-bit computers and Microsoft Dynamics GP 10.0 and GP 2010. [Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6...
15 Nov 2010
Quick Tip: Solving "Do you want to Save?" dialog appearing after VBA customization
Have you ever used Modifier and Visual Basic for Applications (VBA) to add an additional field to a window? Have you then had the issue when navigating through records on that window, it keeps coming up and asking " Do you want to Save, Discard or Cancel? " or " Do you want to Save, Delete or Cancel...
18 Oct 2010
File not found: VBA6.dll error occurs or GP crashes and creates a Watson fault bucket 1474386816
We have been running into a few different issues with Microsoft Dynamics GP 10.0 and GP 2010 when you have Office 2010 installed. [Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6.DLL, VBE.DLL, VBA7.DLL and VBE7.DLL errors. Please...
26 Aug 2010
Dynamics GP Customizations Summary
First Jivtesh Singh creates the awesome portal site GPWindow.com and now he starts using it to gather all the best posts together. His latest blog post covers Microsoft Dynamics GP Customization with its many tools and methods and highlights a large number of fantastic posts from around the community...
23 Aug 2010
Currency values returned by VBA to a report are multiplied by 10 or 100 with Multicurrency
Last week, I discussed an issue where Currency values returned by VBA to a report are multiplied by 10 or 100 . To workaround the issue we used string calculated fields rather than currency calculated fields on the report and formatted our values with the FormatCurrency() or FormatNumber() functions...
8 Aug 2010
Currency values returned by VBA to a report are multiplied by 10 or 100
Today, I wanted to highlight an issue that you might see when working with Visual Basic for Applications (VBA) and Report Writer. The issue occurs when using VBA code to return a currency value to be displayed on the report and it appears to be randomly multiplied by 10 or 100. This is a known issue...
3 Aug 2010
Page 1 of 5 (102 items)
Social Media Sharing
© 2014 Microsoft Corporation.
Privacy & Cookies