Sign in
Developing for Dynamics GP
by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)
Search Form
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Tags
ADO
Advanced Topic
Application
Best Practice
Blogsphere
C#
Community
Conference
Cross Dictionary
Customizations
Developer Toolkit
Development Tools
Dex.ini
Dexterity
eConnect
Exception
Extender
FOTD
Fun
General
GP "12"
GP 2010
GP 2013
History
Hybrid
Inside Track
Integration Manager
Karl Gunderson
Modifier
News
Newsgroups
Performance
Quick Tips
Report Writer
RW Functions
Security
Service Packs
SQL
Support
Support Debugging Tool
Tools
Training
VB
VBA
Visual Studio Tools
Web Client
Web Services
Windows 7
Windows 8
Windows Phone
News
Dates of Interest
11-Jul-2008: Blog Created by David Musgrave.
03-Oct-2008: Syndicated to the
Dynamics Communities
.
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.
05-Sep-2011: Created
http://aka.ms/Dev4DynGP
and
http://aka.ms/SDT
Shortened URLs.
15-Sep-2012: First Post by Aaron Donat.
27-Sep-2012: First Post by Jason Lech.
Social Networking & Syndication
Follow David Musgrave and the blog on:
This blog at
Dynamics Communities
Shortened URLs
This Blog:
http://aka.ms/Dev4DynGP
SDT Portal:
http://aka.ms/SDT
Menus for VST:
http://aka.ms/MVST
Disclaimer
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
WorldMaps Statistics since 24-Feb-2009:
Click for WorldMaps Stumbler
Translator Tool
Translate this page
Powered by
Microsoft® Translator
Links
Contents
General Articles & Links
Modifier & VBA Articles & Links
Dexterity Articles & Links
Developer Toolkit Articles & Links
Modifier & VBA Samples
Dexterity 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 Partner Forum (Old)
Microsoft Dynamics GP Blogs at Dynamics Communities
Microsoft Dynamics GP Partner Forum
Blog Links
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)
MSDynamicsWorld.com
The Death of Reason (Dwight Specht's Blog)
BlogMS - Official Microsoft Team Blogs
Dynamics GP Land (Christina Phillips, Steve Endow & Lorren Zemke'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)
Njevity'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)
Dynamics Solution Edge (AMLLP Consulting's Blog)
Great Plains Guy (David Patrick's Blog)
Dynamics CPM (Corporate Performance Management)
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)
Resources Links
PartnerSource
CustomerSource
Microsoft Dynamics
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
ISV Central
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
Favourite Posts
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
Archives
Archives
June 2013
(2)
May 2013
(11)
April 2013
(12)
March 2013
(5)
February 2013
(11)
January 2013
(7)
December 2012
(15)
November 2012
(14)
October 2012
(17)
September 2012
(16)
August 2012
(17)
July 2012
(16)
June 2012
(12)
May 2012
(16)
April 2012
(14)
March 2012
(20)
February 2012
(13)
January 2012
(10)
December 2011
(10)
November 2011
(13)
October 2011
(10)
September 2011
(19)
August 2011
(17)
July 2011
(7)
June 2011
(12)
May 2011
(10)
April 2011
(21)
March 2011
(28)
February 2011
(13)
January 2011
(15)
December 2010
(13)
November 2010
(16)
October 2010
(18)
September 2010
(20)
August 2010
(22)
July 2010
(22)
June 2010
(22)
May 2010
(23)
April 2010
(22)
March 2010
(17)
February 2010
(20)
January 2010
(19)
December 2009
(14)
November 2009
(19)
October 2009
(18)
September 2009
(19)
August 2009
(23)
July 2009
(19)
June 2009
(17)
May 2009
(17)
April 2009
(19)
March 2009
(24)
February 2009
(20)
January 2009
(20)
December 2008
(17)
November 2008
(21)
October 2008
(23)
September 2008
(17)
August 2008
(15)
July 2008
(31)
October, 2008
Featured Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
No blog posts have yet been created.
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Developing for Dynamics GP
Statement of Direction for Microsoft Dynamics GP
Posted
over 5 years ago
by
David Musgrave
7
Comments
You might have seen some other posts around that the updated Statement of Direction for Microsoft Dynamics GP documentation has been posted on PartnerSource and CustomerSource. Some points of interest for the developer community are listed below: ...
Developing for Dynamics GP
Developer Documentation for Microsoft Dynamics GP
Posted
over 5 years ago
by
David Musgrave
3
Comments
I found some great reference pages on PartnerSource and CustomerSource today. They are the Developer Documentation pages for Microsoft Dynamics GP 9.0 and 10.0. They contain links to information about every customisation tool available as well as links...
Developing for Dynamics GP
Using ADO with VBA with Report Writer
Posted
over 5 years ago
by
David Musgrave
7
Comments
As a follow on to the Using VBA with Report Writer post, I would like to discuss using ActiveX Data Objects to access data from SQL Server while using the Report Writer. Sometimes it is not possible to use Report Writer to create a table relationship...
Developing for Dynamics GP
Using VBA with Report Writer
Posted
over 5 years ago
by
David Musgrave
24
Comments
Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP forms and the Modifier, but not everyone is aware that VBA can be used with the Report Writer as well. In fact using VBA with the Report Writer can...
Developing for Dynamics GP
How to use Word Mail Merge and Macros to Import Data
Posted
over 5 years ago
by
David Musgrave
7
Comments
This post explains how to use Microsoft Office Word's Mail Merge functionality to Import Data into Microsoft Dynamics GP. This method can be useful when working with master records or transactions not supported by any of the existing tools such as Integration...
Developing for Dynamics GP
Running a SQL Script against all GP Company Databases
Posted
over 5 years ago
by
David Musgrave
5
Comments
While administering a Microsoft Dynamics GP system, there are times when a fix or change needs to be applied to each company in the system at the SQL Server level. On a system with a large number of companies this can be a very time consuming task. ...
Developing for Dynamics GP
Dex - Filtering a Third Party Lookup
Posted
over 5 years ago
by
David Musgrave
7
Comments
When I started this blog, one of my goals was to help developers push the boundaries of what they believe is possible. This was the foundation of the materials presented at conferences by myself and Mark Rockwell. For more information on the conference...
Developing for Dynamics GP
Support Debugging Tool Free Live Meeting Session
Posted
over 5 years ago
by
David Musgrave
2
Comments
Sorry, I posted this too late for most people. I thought I would let you know that I presented a free Live Meeting session about the Support Debugging Tool for Microsoft Dynamics GP on the 22 nd October at 13:00 AEST (GMT+10 + daylight saving). That was...
Developing for Dynamics GP
What Training do you want and where?
Posted
over 5 years ago
by
David Musgrave
45
Comments
Over the years I have had many requests for training on the various tools available for customising or developing with Microsoft Dynamics GP. Training for Microsoft Dynamics GP tools does exist, but it is only run infrequently, in a classroom environment...
Developing for Dynamics GP
Microsoft Dynamics GP 10.0 Service Pack 3
Posted
over 5 years ago
by
David Musgrave
18
Comments
Just a quick post to let you know that Service Pack 3 for Microsoft Dynamics GP version 10.0 has now been released. The link below is the main Service Pack page: Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 10...
Developing for Dynamics GP
Dex - Illegal address for field 'PowerUser' exception
Posted
over 5 years ago
by
David Musgrave
5
Comments
Today I saw another posting on the Microsoft Dynamics GP Community Forum about an error when going into Dexterity test mode after upgrading an application from a previous version to version 10.0. The error message is as follows: Unhandled script...
Developing for Dynamics GP
Where is the DEX.INI file for version 10.0?
Posted
over 5 years ago
by
David Musgrave
1
Comments
Since the release of Microsoft Dynamics GP v10.0 I have seen this question asked many times over on the various newsgroups I monitor (see the Newsgroups Links on the left hand panel of the blog). The quick answer is.... it has moved into the Data subfolder...
Developing for Dynamics GP
Dex - Working with the Action Button on the SOP_Entry form
Posted
over 5 years ago
by
David Musgrave
2
Comments
Time to get into some Dexterity code. I saw a posting today on the Microsoft Dynamics GP community forum. It was asking about the disappearance of the Void Button from the SOP_Entry form and how to work with the new Action Button. In v9.0 and earlier...
Developing for Dynamics GP
What is Column desSPRkmhBBCreh?
Posted
over 5 years ago
by
David Musgrave
9
Comments
If you have ever spent time analysing a DEXSQL.LOG file you might have seen a reference to a table column called desSPRkmhBBCreh. This post explains what this column is used for and why it has the name it does. For example: SELECT desSPRkmhBBCreh...
Developing for Dynamics GP
Hybrid - Using Menus for Visual Studio Tools from VBA Example
Posted
over 5 years ago
by
David Musgrave
3
Comments
After the release of Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 , my good friend Mariano Gomez asked me if it was possible to use the tool to add menus from Visual Basic for Applications (VBA). Mariano was initially working on an...
Developing for Dynamics GP
Unexpected Hidden Talents - Decorating Cakes
Posted
over 5 years ago
by
David Musgrave
13
Comments
I have been involved in the Great Plains world now since 1994. During that time I have become known for my work with development techniques and pushing the boundaries of what is possible. While my passion for my work in the Asia Pacific Microsoft Dynamics...
Developing for Dynamics GP
Providing product feedback using Microsoft Connect
Posted
over 5 years ago
by
Scott Stephenson
7
Comments
Hello Developing for Dynamics GP community. David has been busy posting lots of great information and I thought it was time for my team to start helping contribute. My name is Scott Stephenson and I am the team manager for the Microsoft Dynamics GP Developer...
Developing for Dynamics GP
What do the zDP_ Auto Generated Stored Procedures do?
Posted
over 5 years ago
by
David Musgrave
11
Comments
If you look at a SQL Server installation of Microsoft Dynamics GP, in the Stored Procedures folder underneath the Dynamics system database or a company database you will find a large number of stored procedures starting with the initials"zDP". This article...
Developing for Dynamics GP
Finding Table and Field Information in Microsoft Dynamics GP
Posted
over 5 years ago
by
David Musgrave
12
Comments
This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community website. The links to the original article, as well as the associated Knowledge Base (KB) article are provided at the bottom of this post. The idea...
Developing for Dynamics GP
Visual Studio Tools LineFill Events
Posted
over 5 years ago
by
David Musgrave
4
Comments
Developers using Visual Studio Tools for Microsoft Dynamics GP with forms that contain scrolling windows might have noticed that the LineFill events are missing from v9.0 and v10.0, this posting explains why they were missing and why they have been added...
Developing for Dynamics GP
Why does Microsoft Dynamics GP encrypt passwords?
Posted
over 5 years ago
by
David Musgrave
44
Comments
Why doesn't the password I use for Microsoft Dynamics GP work for me to access the data in SQL from <insert application name here>? Why does my password sometimes fail to work from one workstation when it works from another? Why does the password...
Developing for Dynamics GP
October is the month to attend Developer Training
Posted
over 5 years ago
by
David Musgrave
8
Comments
I am going to get up on my soap box now and do some preaching. <SoapBox mode="with conviction"> To all the managers of development staff who wish to work with Microsoft Dynamics GP: Invest in your teams. Get them trained in the tools they...
Developing for Dynamics GP
Setting up Test and Historical Companies
Posted
over 5 years ago
by
David Musgrave
6
Comments
I did not start this thread, but I thought I would give a bit of insight into the subject. Vaidy Mohan on his blog posted about Test Company Message while logging on to Dynamics GP . I initially thought he was talking about the sample company date...
Page 1 of 1 (23 items)