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
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
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
Fun
General
GP 2010
History
Hybrid
Inside Track
Integration
Integration Manager
Karl Gunderson
Language
Modifier
News
Newsgroups
Pages
Performance
Quick Tips
Report Writer
RW Functions
Security
Service Packs
SmartList Builder
SQL
Support
Support Debugging Tool
Tools
Training
Translation
VB
VBA
Visual Studio Tools
Web Services
Windows 7
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.
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
Newsgroups & Forums Links
Microsoft Dynamics GP Community Forum
Great Plains Tek Tips Forum
Microsoft Dynamics GP Partner Forum
Microsoft Dynamics GP Blogs at Dynamics Communities
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
Archives
Archives
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)
July, 2008
MSDN Blogs
>
Developing for Dynamics GP
>
July, 2008
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Developing for Dynamics GP
Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0
Posted
over 4 years ago
by
David Musgrave
25
Comments
Great News for Visual Studio developers working with Microsoft Dynamics GP 10.0. The Issue As I worked more with the Developer Toolkit and in particular Visual Studio Tools for Microsoft Dynamics GP, I found that the main support issue being seen...
Developing for Dynamics GP
Support Debugging Tool for Microsoft Dynamics GP
Posted
over 4 years ago
by
David Musgrave
49
Comments
You may have heard about the Support Debugging Tool for Microsoft Dynamics GP. A sneak preview of the tool was shown at the Microsoft Dynamics GP Technical Airlift 2008 in May and it was extremely well received. The demo was a little premature as the...
Developing for Dynamics GP
GP Logos through the years
Posted
over 4 years ago
by
David Musgrave
35
Comments
I thought that I would have a little fun and be nostalgic for a bit. I have been working with Great Plains Dynamics since version 2.00 in 1994. The company I was with did look at version 1.00, but decided not to become a reseller at that time. Instead...
Developing for Dynamics GP
Hybrid - Clearing the Last User on a Terminal Server Example
Posted
over 4 years ago
by
David Musgrave
5
Comments
Microsoft Dynamics GP remembers the last user to use the application and defaults the User ID into the login window next time the application is loaded. This is useful when only a single user uses the specific workstation install. In a Terminal Server...
Developing for Dynamics GP
VBA - Running VBA scripts after Login or before Logout Example
Posted
over 4 years ago
by
David Musgrave
4
Comments
Sometimes you need to run VBA (Visual Basic for Applications) scripts after a successful login attempt. Using the OK Button on the Company Selection window does not always work as the login could still fail. For example, the user is already logged into...
Developing for Dynamics GP
SnapShot for Microsoft Dynamics GP
Posted
over 4 years ago
by
David Musgrave
18
Comments
Not long after I joined Microsoft in May 2001, I found myself working as part of a global development team for Asia Pacific. The team was based in Manila in the Philippines and was involved in a regional research project to check the feasibility of releasing...
Developing for Dynamics GP
Report Writer and Developer Toolkit Articles & Links Pages
Posted
over 4 years ago
by
David Musgrave
0
Comments
The Report Writer Articles & Links page and the Developer Toolkit Article & Links page have been updated with links to useful Knowledge Base (KB) articles and training materials. Also included are links to the download pages for the various...
Developing for Dynamics GP
Modifier - Extending the length of a Field Example
Posted
over 4 years ago
by
David Musgrave
17
Comments
The following VBA example extends the Reference field on the GL Transaction Entry window from string field of 30 characters to a text field of 200 characters. The first 30 characters of the text field are populated into the original string field so it...
Developing for Dynamics GP
Hybrid - Dynamically Populating a Modifier Added List Example
Posted
over 4 years ago
by
David Musgrave
11
Comments
When using the Modifier to add a list field (drop down list, button drop down list, listbox, multi-select list box) to a window as a local field, the only option available to populate the list was to add static values. This is because there is no functionality...
Developing for Dynamics GP
BlackBox - The First Dexterity Game
Posted
over 4 years ago
by
David Musgrave
2
Comments
Back in my past, when I ran Winthrop Dexterity Consultants , I wrote a game in Dexterity (approx 1999). This game is called BlackBox and is based on the original board game by Eric Solomon . The concept of the game is to find the location of a number...
Developing for Dynamics GP
Cross Dictionary Dexterity Development
Posted
over 4 years ago
by
David Musgrave
19
Comments
Back in 1998, when I was working with Sequel Technology (the Western Australian partner for Great Plains), we were implementing Great Plains Dynamics 4.0 for a couple of sites and were using add-on products for Service Management and Job Costing. My...
Developing for Dynamics GP
Modifier & VBA and Dexterity Articles & Links Pages
Posted
over 4 years ago
by
David Musgrave
0
Comments
The Modifier & VBA Articles & Links page and the Dexterity Articles & Links page have been updated with links to useful Knowledge Base (KB) articles and training materials. This includes many of the articles I have created to help developers...
Developing for Dynamics GP
Hybrid - Changing Screen Colours Depending on Company Example
Posted
over 4 years ago
by
David Musgrave
12
Comments
This is one of my favourite examples mainly because it achieves something that most people thought was not possible with VBA. To be honest, it still is not possible with VBA alone. This hybrid code uses the unsupported method of calling Dexterity sanScript...
Developing for Dynamics GP
RW - Adding Line Numbers to SOP Documents Example
Posted
over 4 years ago
by
David Musgrave
5
Comments
The following example shows how easy it is to use VBA to add a line number to a SOP Document. There is a Knowledge Base (KB) article 857285 which uses the Line Item Sequence field and dividing its value by 16384 to obtain a line number. This works...
Developing for Dynamics GP
Modifying Reports which use Temporary Tables
Posted
over 4 years ago
by
David Musgrave
4
Comments
I often get told that it is impossible to customize a report which uses a temporary table, and in particular a temporary table which uses single fields for multiple purposes. While I admit that these reports are more challenging to customize they are...
Developing for Dynamics GP
RW - Accessing any SQL data from a Report Example
Posted
over 4 years ago
by
David Musgrave
13
Comments
The following Report Writer and VBA example demonstrates how data from any SQL table can pulled into a report regardless of the product the table is related to. This technique can also be used when it is not possible to create the table relationship needed...
Developing for Dynamics GP
Company Logos on Reports
Posted
over 4 years ago
by
David Musgrave
2
Comments
I have been asked many times how to have different company logos and details on invoice documents depending on the company you are logged into. Changing company details is easy as they are stored as Global fields and can be added to a report from the...
Developing for Dynamics GP
General and Developer Articles & Links Pages
Posted
over 4 years ago
by
David Musgrave
0
Comments
The General Articles & Links page and the Developer Article & Links page have been updated with links to useful Knowledge Base (KB) articles. This includes some of my favourite non-development related subjects, such as Security (Advanced Security...
Developing for Dynamics GP
RW - Conditional Logos Example
Posted
over 4 years ago
by
David Musgrave
4
Comments
The following Report Writer example demonstrates how it is possible to show different logo images on a report based on a defined condition. The Report Writer was used to create a custom report which has two logos on it. Then each logo covered with...
Developing for Dynamics GP
Modifier - Sales Prospect DUOS Example
Posted
over 4 years ago
by
David Musgrave
7
Comments
The following VBA example adds two additional fields to the Sales Prospect Maintenance window and Sales Prospect Report. The Modifier was used to add the additional local fields, and then VBA code added. The code uses the DUOS (Dynamics User Object...
Developing for Dynamics GP
Microsoft Dynamics GP Technical Airlift 2008
Posted
over 4 years ago
by
David Musgrave
10
Comments
In May, I was invited to be a guest presenter at the Microsoft Dynamics GP Technical Airlift 2008 held in Fargo, North Dakota, USA on the 28th and 29th of May 2008. I was asked to co-present two sessions with Mike LoPatriello from Luna Development...
Developing for Dynamics GP
VBA - Screen Size and Position Example
Posted
over 4 years ago
by
David Musgrave
0
Comments
The following VBA example allows a window to remember its size and position the next time it is opened. This is really handy for transaction windows that you would like to see more lines at one time. The code uses the DUOS (Dynamics User Object Store...
Developing for Dynamics GP
Welcome to the Developing for Dynamics GP blog
Posted
over 4 years ago
by
David Musgrave
6
Comments
I have finally succumbed and joined the blogsphere. I plan to use this blog as a reference site containing sample code, sample applications and articles that I have created. First, though, I need to work out how to set everything up. Slowly working...
Page 1 of 1 (23 items)