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
Blog Home
About
Email Blog Author
Tags
Aaron Donat
ADO
Advanced Topic
Alice Newsam
Application
April Fool
Articles
Automated Solutions
Best Practice
Blogsphere
Business Portal
C#
Cakes
Cloud
Community
Conference
Cross Dictionary
Customizations
Developer Insights
Developer Toolkit
Development Tools
Dex.ini
Dexterity
Discussions
Downloads
DUOS
eConnect
Encryption
Exception
Extender
Fargo Flood
Featured
Fonts
Formats
Forums
FOTD
Fun
Games
General
GP "12"
GP 2010
GP 2010 R2
GP 2013
GPUG
History
Hobbies
Hybrid
Inside Track
Integration
Integration Manager
Karl Gunderson
Language
Logo
Macro
Menus for Visual Studio Tools
Modifier
Named Printers
News
Newsgroups
Notes & OLE Attachments
Pages
Passwords
Performance
PSTL
Quick Tips
Report Writer
Row Level Filtering
RW Functions
Samples
SDK
Search
Security
Service Packs
Smartlist
SmartList Builder
SnapShot
Source Code Control
Source Code Program
SQL
Suggestions
Support
Support Debugging Tool
Surface
Synchronise
System Requirements
Tools
Training
Translation
Triggers
Upgrade
VB
VBA
Visual Studio Tools
Web Client
Web Services
Windows 7
Windows 8
Windows Phone
Word Templates
XML
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
May 2013
(7)
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)
Browse by Tags
MSDN Blogs
>
Developing for Dynamics GP
>
All Tags
>
modifier
Tagged Content List
Blog Post:
Quick Tip: VBA ADO Connection Run-time error '3709'
David Musgrave
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...
on
10 Apr 2013
Blog Post:
Edits To Dynamics Launch File Won't Save
Patrick Roth
My blog post today isn't anything earth shattering but something a partner ran into that was unexpected. Logical - but unexpected nonetheless. A recent forum post detailed how the user was trying to set forms & reports dictionary paths using the Edit Launch File window. What they found was that...
on
7 Jan 2011
Blog Post:
Changing the Phone Number Format
David Musgrave
One of the most common customisations outside of North America is changing the Phone Number Format. The North American default format of (XXX) XXX-XXXX Ext. XXXX is not always suitable for other countries. For example: Australia, Singapore and Malaysia now use a domestic format of a 2 digit area code...
on
11 Nov 2010
Blog Post:
Why does Microsoft Dynamics GP 10.0 and later use a Data Folder?
David Musgrave
I recently responded on a forum post which asked why the paths for the custom forms and reports dictionaries in the Dynamics.set launch file where pointing to the Data folder. The post also asked why the application did not complain about the fact that the dictionaries listed in the Dynamics.set did...
on
3 Nov 2010
Blog Post:
Quick Tip: Solving "Do you want to Save?" dialog appearing after VBA customization
David Musgrave
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...
on
18 Oct 2010
Blog Post:
Dynamics GP Customizations Summary
David Musgrave
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...
on
23 Aug 2010
Blog Post:
Avoiding VBA Circular References when using a Dynamics GP Lookup
Patrick Roth
Honestly, I struggled a bit on the title of this article. Is this article to show one way to use a Dynamics GP lookup window in your Modifier/VBA customization? Or is it an article that shows a way to work around the circular reference problem that you can get yourself into when using VBA across projects...
on
9 Jul 2010
Blog Post:
Errors when importing Customization Maintenance Packages
David Musgrave
Today, I had a support case that was asking about errors when importing a package via Customization Maintenance (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance). The partner was unable to find an explanation of the errors on the Internet and so I thought I...
on
9 Jun 2010
Blog Post:
Microsoft Dynamics GP 2010 Technical Web Seminars
David Musgrave
With the release of Microsoft Dynamics GP 2010 this is THE place to get ready to learn about this release, innovative development tools, best practices and more. Help ensure your PEOPLE are your most powerful asset by gaining technical readiness for Microsoft Dynamics GP 2010. Learn about the new...
on
9 May 2010
Blog Post:
Smartlist: Splitter control in Smartlist window doesn't work
Patrick Roth
Last week , I enumerated several questions that I've been asked and have seen posted to the public Dynamics GP newsgroups. These questions are typically of the "Why doesn't Smartlist..?" variety. In this post and a few planned future posts, I'll look at each of these questions individually and give...
on
6 May 2010
Blog Post:
Microsoft Dynamics Convergence Atlanta 2010 Wrap Up
David Musgrave
I am finally back home in Perth and the time has come to wrap up my first Convergence (and my first trip to Atlanta, Georgia, USA). The trip was a great success and Mariano and I will hopefully be given the opportunity to come back and present again. It was worth the 27 hours flying to get to Atlanta...
on
2 May 2010
Blog Post:
Smartlist: Only the data area should grow
Patrick Roth
I've seen several questions over the years on Smartlist of the "Why doesn't it?" variety such as: Why does Smartlist export to Excel so slowly? Because Smartlist exports row by row and sets each cell individually. Why does Smartlist automatically try to display the default Smartlist when...
on
30 Apr 2010
Blog Post:
Checklist for creating a new Dexterity Window
David Musgrave
Today, we go back to basics. It is always good to make sure that we have the foundations handled properly. When I teach the Dexterity, I always go through the standard checklist below for creating (or modifying) Dexterity windows. This checklist is valid for Dexterity when creating new windows or...
on
29 Nov 2009
Blog Post:
Hybrid - Setting a push button to Hyperspace
Patrick Roth
Trivia question for today: Given the following sequence of events: In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in "AARON". The user then presses the associated lookup button. What happens? A. Focus moves to the button causing the field change script...
on
30 Oct 2009
Blog Post:
Hybrid Development and Continuum
David Musgrave
In the past, I was known for my pioneering work with and promotion of Cross Dictionary Dexterity Development . More recently I have been talking up the benefits of Hybrid Development and Developing Outside of the Box . With all the tools available to the Microsoft Dynamics GP developer, and each tool...
on
19 Oct 2009
Blog Post:
Understanding Cross Dictionary Dexterity Development
David Musgrave
A recent newsgroup post has raised the question of whether it is possible to customise an alternate form using Dexterity. This is covered on my earlier blog post: Can I customise a 3rd party form with Dexterity? However, I thought I would try and clarify what can be achieved with Dexterity for each...
on
17 Sep 2009
Blog Post:
Modifier - How to Expand the GL Transaction Entry Scrolling Window Example
David Musgrave
One of the customisations that I have heard requests for a number of times is to open the General Ledger Journal Entry (GL Transaction Entry) window's scrolling window (grid) to its expanded state when the window is opened. The method to make this happen is to use Visual Basic for Applications (VBA...
on
28 Jul 2009
Blog Post:
Removing References to Fields in VBA Revisited
David Musgrave
Michael Johnson (the MBS Guru ) has posted a great article about removing invalid references from a Visual Basic for Applications (VBA) project. This has prompted me to revisit the topic and gather together all the relevant resources from a number of blog authors. A few months back, Mohammad Daoud...
on
22 Jun 2009
Blog Post:
Extender is coming, what now for the other customization tools
David Musgrave
You may has seen that Microsoft Dynamics GP v10.00 Service Pack 4 will include a number of new features to the Extender product. Please see the information on blog posts on the Inside Microsoft Dynamics GP blog and US Microsoft Dynamics GP Field Team blog: Get more out of your existing solution...
on
23 Apr 2009
Blog Post:
What is the Dynamic User Object Store (DUOS)
David Musgrave
The Dynamics GP Blogster , Mariano Gomez, has written a great article on the Dynamic User Object Store (DUOS). One of the great things about the DUOS is that it is a table easily available for a developer to use however they want from Dexterity (table SY_User_Object_Store), from SQL Server (SY90000...
on
6 Apr 2009
Blog Post:
Creating SQL Views of DUOS Data
David Musgrave
Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields. The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in a string field 132 characters long. Below is...
on
10 Mar 2009
Blog Post:
Free Visual Basic for Applications Workshop
David Musgrave
Mariano Gomez aka The Dynamics GP Blogster is running an online (blog based) workshop to show how to use Modifier and VBA (Visual Basic for Applications). Have a look at the introductory post using the link below. It will explain the prerequisites and has the links to the posts for Workshop Days 1...
on
2 Mar 2009
Blog Post:
Handling Translation when Customizing with VBA
David Musgrave
From the Translating Dexterity Applications Series . The final topic in the series is one that was added later after I was asked about how to handle translated applications when writing customizations. Most code would work fine as it is independent of the language. However, it is common in Visual...
on
26 Feb 2009
Blog Post:
Linking Field Prompts and fixing VBA Reference Errors
David Musgrave
The great postings around the blogsphere just keep coming. I am not complaining as the body of knowledge they provide to community is growing all the time. My buddy, Mariano Gomez, who is a wealth of knowledge and is always willing to help on the newsgroups has come with a great article explaining...
on
16 Feb 2009
Blog Post:
Tools Sessions at Convergence 2009
David Musgrave
If you are going to Convergence 2009 in New Orleans between the 10 th and 13 th of March 2009, make sure you attend the various sessions about the Microsoft Dynamics GP development and customization tools. Below are the details of the sessions: GP04 Building Personalized Solutions using Modifier...
on
11 Feb 2009
Page 1 of 2 (47 items)
1
2
Social Media Sharing