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
Update: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions - RW_CoAddrIDInfo broken
Following on from my post: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions , I have to admit that I made a mistake. The Problem The update to the RW_CoAddrIDInfo() report writer function has broken the code. It works when no Address ID is supplied to return the information from...
21 Aug 2014
Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions
You might remember the story about how I created a suite of Report Writer functions and got them added to the version 7.0 Dynamics.dic core dictionary. The aim for these functions was to make it easier for partner consultants and customers to modify the reports without needing custom scripting in Visual...
8 Jun 2014
Microsoft Dynamics GP 2013, Printer Selection, Named Printers, Page Orientation and the System Print Dialog
Microsoft Dynamics GP 2013 added a long awaited feature, the ability to change the printer selection for a report after it has printed to the screen output. However, this change has introduced some side effects. Microsoft is aware of the side effects and they should be resolved in an upcoming release...
17 Jul 2013
Dynamics Confessor Report Writer Function Series
My great friend, Leslie Vail - The Dynamics Confessor , has released a great series of posts about the Report Writer functions available in Microsoft Dynamics GP. These Report Writer functions are Dexterity global functions which are exposed to the Report Writer so they can be included in calculated...
23 Apr 2013
Copying Report Formats between Reports... and a warning about Word Templates
There is an unsupported method of copying report formats between reports that is very commonly used (and even recommended by me), but we recently had a case that highlighted a problem with the technique. This blog post will discuss the method and the issue we have seen. The Situation The situation...
25 Feb 2013
The Dynamics GP Blogster works with Report Writer and the Support Debugging Tool
My great friend Mariano Gomez, The Dynamics GP Blogster , has been busy recently creating some fantastic step by step posts on customising reports using Report Writer. His first post shows a method to get the Customer Item User Defined fields showing on the SOP Invoice. Mariano discusses the more...
23 May 2012
Getting data from ISV tables onto reports without needing to create alternate reports
As a Dexterity developer, I have written a number of customisations to Microsoft Dynamics GP which add additional fields to the system. These additional fields are often have a relationship to existing data in Dynamics GP. It is quite common to store the additional data in a parallel table (sometimes...
26 Apr 2012
How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool
Here is another support case that was resolved simply and quickly using the Support Debugging Tool . The customer was using Extender to add an additional comment to the inventory stock transfer transaction. They created an Extender ID "ST_COMMENTS" and used the Long String field type in Extender which...
8 Sep 2011
Quick Tip: Table Hierarchy Inconsistency Errors in Runtime Mode
Following on from yesterday's post: Quick Tip: Creating Dexterity System Variables , I want to cover a related issue. This is when a Dexterity developer is creating a report (either new or alternate) which will display data from newly added tables. To get the data to show on the report the developer...
2 Aug 2011
Keeping Word Templates in synch with Report Writer - Video
Hi, I previously published an article on the blog on Keeping Word Templates in synch with Report Writer . Now I have created a video that demonstrates how to do this. You can also view the the video on YouTube published by msdyncomm . Dave 15-Feb-2013: Fixed broken Links to Video and...
29 Jul 2011
Word Template Debugging - Video
Hi, I previously published an article about Debugging Word Templates on this blog. Now I have created a video that demonstrates how to add the debugging and what you get for results. You can also view the the video on YouTube published by msdyncomm . Dave 05-Mar-2014: Fix Link to Video...
22 Jul 2011
How to calculate Aging Buckets based on documents shown on a Receivables Statement
I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by...
12 Jul 2011
Troubleshooting Named Printers Issues
I am working on a Named Printers issue at the moment and thought it would be a good opportunity to put some standard troubleshooting steps on the blog. Quick history: I originally developed Named Printers back on version 3.0 when I worked for the selling ISV partner, Sequel Technology, and later sold...
25 May 2011
How to add Item Category Long Descriptions to reports using the Support Debugging Tool
I am currently working on a support case where the customer is making use of the six user defined categories for items. That in itself is nothing remarkable or worth blogging about. However, they are using Long Description field on the Item Category Setup window and wished to include the data from this...
23 May 2011
Accessing Internet Information from Report Writer
Last week, I had a call from a partner asking how could they access data stored on the Internet Information window. This is the window opened with the little italic i symbol next to the Address ID field for Company, Customer, Employee and Vendor Addresses as well as next to Employee ID and Salesperson...
10 May 2011
Keeping Word Templates in synch with Report Writer
If you are working with a specific report in report writer, and you are also using a word template to print the report, one thing that you have to keep in mind is that the report writer fields have to be in synch with the content controls on the word template. If they are not in synch what happens is...
5 May 2011
Report Prints Incorrectly When Choosing the PDF File Format As The Report Destination
I recently worked on a PDFWriter printing incident with a Customer and we ran into a format problem when choosing the PDF File format. The Problem Since performing an upgrade to Microsoft Dynamics GP 2010, the Customer was having an issue when printing a single page invoice, in this instance, the...
1 May 2011
Word Templates will not print to screen
A common scenario that has been happening more and more is that a customer is trying to print out a word template just to the screen and the template won't print. You will get a window called "Report Processing Status" and the report will be there and it will list a status of "In Progress" and it just...
24 Apr 2011
Word Template Debugging
Recently, I have been looking a lot of Word Template cases - I'm the primary Escalation Engineer on that feature. Since Word Templates are new to GP 2010, I want to get some blog articles written on some of the common issues we are running into. So this will probably be a series of Word Template posts...
5 Apr 2011
Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement
Hi everyone. I wanted to share with you a recent support incident that I worked on. The cause of the issue was one of those weird issues that took a while to track down. The Problem The problem is that the Current Trx Amount (CURTRXAM) field in the RM30702 reprint table is not populated when...
24 Feb 2011
Working with Vertical Lines in Report Writer
If you have ever used the SOP Blank Invoice Form or the POP Purchase Order Blank Form in Microsoft Dynamics GP, you will have seen the vertical lines on the report which make up the boxes around the various sections of the report. This article explains how those vertical lines work and how to easily...
16 Feb 2011
Adding more comments to SOP Documents
In keeping with my recent theme of Microsoft Dynamics GP Report Writer related articles, I thought I would post an example of how to get more comment lines showing a SOP Document. This is a follow on from the Working with Text fields in Report Writer post. There was a Knowledge Base (KB) article on...
2 Feb 2011
Working with Text fields in Report Writer
This post will explain what is and is not possible when working with fields of text datatype in the Microsoft Dynamics GP Report Writer. The text field datatype in Dexterity allows multi-line text to be entered up to a maximum length of 32,000 characters. A shorter keyable length maybe defined when...
13 Jan 2011
Word Templates, Office 2010 and the Maintain Compatibility option
A while ago I posted an article on Modifying Microsoft Dynamics GP 2010 Word Templates which demonstrated the basic methods for customizing word templates for Microsoft Dynamics GP 2010. In that article, I mentioned that if you were using Word 2010 to edit the templates, you would have an option to...
8 Dec 2010
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
Page 1 of 3 (70 items)
Social Media Sharing
© 2015 Microsoft Corporation.
Privacy & Cookies