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
How to Fix a Setup File is from a later version Error from the Support Debugging Tool when doing a Test Upgrade
This post revisits the issue previously discussed in the blog post: How to Fix a Setup File is from a later version Error from the Support Debugging Tool . The issue is that you receive the error message below from the Support Debugging Tool just after logging into Microsoft Dynamics GP:...
16 Sep 2014
After restarting SQL Server, only 'sa' user can log into Microsoft Dynamics GP
Last week, I resolved a rather bizarre case for a customer. The Situation Each time the customer's SQL Server was restarted for whatever reason, only the 'sa' user was able to log into Microsoft Dynamics GP. Once the 'sa' user had logged into Microsoft Dynamics GP at least once, then all the other...
7 Sep 2014
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
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
Currency ID missing in the Currency Translation Default Exchange Table ID’s section of the Multicurrency Setup window
Hi, my name is Tracy Steere and I work with David Musgrave on the Microsoft Dynamics GP Asia Pacific support team. A bit about myself, I started working with Dynamics GP as an assistant Accountant in 1997 by October 1997 I had become a Dynamics GP Consultant for a company called TWO inc. in Durban...
15 May 2014
Violation of Primary Key constraint. Cannot insert duplicate key in object error when using Item List
Today, I have another blog post based on a recent support case. The partner logged a case with us where the customer was receiving the error "Violation of Primary Key constraint. Cannot insert duplicate key in object" when they used the Item List in Microsoft Dynamics GP. The table referenced in...
12 May 2014
Capture Logins Script from KB 878449 generates Invalid object name error
This week I had an interesting case from a partner trying to use the Capture Logins script from Knowledge Base (KB) article 878449. How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running...
1 May 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
Installing Microsoft Dynamics GP clients using System Center Configuration Manager (SCCM)
This article has its beginnings in a support case for Microsoft Dynamics GP 2013 Word Templates. The problem reported by the customer was that whenever they tried to import a word template back into Dynamics, they would receive the following error: The template you selected cannot be added. ...
25 Mar 2014
Business Portal Requisitions Management Approval Hierarchy List: Server Error in '/' Application
I have seen this error pop up on a few Microsoft Dynamics GP 2013 systems, so I thought I would post some information to help you resolve it. .... Well, at least one possible cause of it. When using Business Portal 6.0 for Microsoft Dynamics GP 2013 and click on the Approval Hierarchy List in Requisition...
29 Jan 2014
SQL Server xact abort setting breaks Microsoft Dynamics GP
Happy New Year. Wishing everyone a very successful 2014. I have been back from leave for two weeks, but have been really busy with support cases. One recent case highlighted a SQL Server setting that I have never used before and the negative consequences of changing the setting from its default...
16 Jan 2014
TCP Chimney Setting and SQL Server Error: TCP Provider: An existing connection was forcibly closed by the remote host
You might have heard me discuss the TCP Chimney settings before. If not, don't worry as this post is here to make sure you know about the setting and make sure it is disabled for all your Microsoft Dynamics GP installs. My earlier post which mentions the TCP Chimney settings, discusses an issue with...
3 Dec 2013
Developers: Microsoft Dynamics GP 2013 Service Pack 2 moves the Vendor and Customer Combiner & Modifier into core code
Now before you ask.... the answer is No, I have not spent all week playing XBox One (as mentioned on the last post ). Yes, we did get one and yes the kids have been using it, but the reason I have not posted on the blog is just that I have been very busy with support cases. Talking of support cases...
2 Dec 2013
Quick Tip: Unusual behaviour when working with SQL Server from Dexterity
Today, I came across an issue where a feature in Microsoft Dynamics GP would work when the workstation had its regional settings set to United States, but would fail to produce any data when the workstation had its regional setting set to Australia, New Zealand, United Kingdom, etc. We have seen related...
4 Nov 2013
Microsoft Dynamics GP 2013 Service Pack 2 fixes Named Printers and Page Orientation settings not being honoured
As mentioned in my post, Microsoft Dynamics GP 2013, Printer Selection, Named Printers, Page Orientation and the System Print Dialog , there was an issue where the feature to allow the printer destination to be changed after the report had been printed to screen did not honour printer setting changes...
6 Oct 2013
Microsoft Dynamics GP 2013 SmartList Export to Excel shows currency values with 5 decimal places
This topic has been in my drafts list for ages after it was mentioned in this partner forum thread: Decimal places in GP2013 - SmartList to Excel . However, I did not want to write it up until I could offer some solutions for it at the same time. Well, I was beaten to it by Cheryl on the Dynamics...
22 Sep 2013
Date Function Errors from SmartList Account Transactions fixed in Microsoft Dynamics GP 2013 Service Pack 2
A little while ago I spent some time in a long screen sharing session to identify the cause of some really unusual errors being generated from SmartList Account Transactions favourite in Microsoft Dynamics GP 2013 Service Pack 1. This issue has now been fixed for Microsoft Dynamics GP 2013 Service Pack...
19 Sep 2013
Adobe X performance issues with Citrix Environment
I had a recent case where a customer was having performance problems with printing to PDF files. If you print a report to the screen and then Send to Mail as PDF it was fast, but if you try to directly email the report as a PDF it would be really slow (minutes rather than seconds). I was not able...
8 Aug 2013
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
Why does SmartList not return all of the expected data for large queries?
Here is another support issue that you might come across. I just closed a case where a SmartList was returning less than the expected number of records. If a SQL Statement was executed via the SQL Server Management Studio, it returned more records than were shown in the SmartList. The system was...
20 Jun 2013
Why does my computer get stuck at Please Wait and fail to boot up?
This issue took me a little while to discover the cause, but now that I understand what was happening I thought I would let you know in case you come across a similar issue. Most of the time I put my work laptop into sleep mode overnight and so I don't reboot my machine very often. However, every...
18 Jun 2013
SmartList not working properly, Search window does not display correctly
Yesterday, I had a support case come in where the customer was complaining that SmartList was not working properly and that the Search window was not being displayed correctly. The Problem During a screen sharing session with the customer, they explained that when they first opened SmartList and...
2 May 2013
Currency Symbol not showing correctly for Users
I resolved an interesting case the other day and thought I would write this one up on the blog. The Problem The customer reported that for a couple of their users, the currency symbol on the GL Transaction Entry window where not matching the symbols as defined by the Currency ID setup. This issue...
30 Apr 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
Australian Goods and Service Tax (GST) Business Activity Statement (BAS) XML File fails to import into the Electronic Commerce Interface (ECI)
Today I am going to discuss a support case where we found an issue with the XML file created when exporting the Business Activity Statement (BAS) tax return report for Australian Goods and Services Tax (GST). So, if you don't have to work with Australian companies and the rest of this article does...
28 Feb 2013
Page 1 of 4 (82 items)
Social Media Sharing
© 2015 Microsoft Corporation.
Privacy & Cookies