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
Blog Home
About
Email Blog Author
Tags
ADO
Advanced Topic
Alice Newsam
APAC
Application
April Fool
Articles
Automated Solutions
Best Practice
BlackBox
Blogsphere
Business Portal
C#
Cakes
Cloud
Community
Conference
Cross Dictionary
Crystal Reports
Customizations
Developer Insights
Developer Toolkit
Development Tools
Dex.ini
Dexterity
Discussions
Double Byte
Downloads
DUOS
eConnect
Encryption
Enhancements
Exception
Extender
Fargo Flood
Fonts
Formats
Forums
Fun
Games
General
GP "12"
GP 2010
GP 2010 R2
GP 2013
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
Synchronise
System Requirements
Testing
Tools
Training
Translation
Triggers
Upgrade
VB
VBA
Visual Studio Tools
Web Client
Web Services
Windows 7
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.
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
June 2012
(1)
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
>
hybrid
Tagged Content List
Blog Post:
Why making the Dex.ini file read only is evil
David Musgrave
Time and time again I have heard consultants say that the solution to stopping Microsoft Dynamics GP remembering the last user on a Terminal Server or Citrix installation is to make the Dex.ini file read-only. There was even a Knowledge Base (KB) article that suggested clearing the SQLLastUser setting...
on
27 Jun 2010
Blog Post:
Menus for Visual Studio Tools Build 9 Released
David Musgrave
Well, it has taken a little longer than orginally planned, but I am pleased to announce that Menus for Visual Studio Tools build 9 has now been released for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010 (v11.0). When Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 was first...
on
24 Jun 2010
Blog Post:
VBA - Adding Extender Windows to GL Transaction Entry Lines
David Musgrave
Last week I had an interesting support case that I thought I would share with you. The customer had created an Extender window to capture additional information for distribution lines on the General Ledger Journal Entry (GL_Transaction_Entry) window. The unique identifier for a distribution line is...
on
8 Jun 2010
Blog Post:
VBA - Calling a Report using Visual Basic for Applications
David Musgrave
I was recently asked about a forum post of mine from a few years ago. It was about how to call a Dexterity report from Visual Basic for Applications (VBA). I checked the blog and could not find a post that showed the code in its simplest form. So here one is... This technique used the unsupported...
on
13 Apr 2010
Blog Post:
Automating or Customizing the Report Destination Window
David Musgrave
I have seen this issue come up a number of times. Trying to automate processes which involve reports and wanting to automate the Report Destination window. Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA. This...
on
3 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:
Dexterity Training in Orlando (Oct 5th to 9th 2009)
David Musgrave
Now is your chance. If you have not attended a Dexterity Training class and are either new to Dexterity or want to get started with Dexterity, this is an opportunity that should not be missed. My good friend, Leslie Vail, will be training the 5 day Dexterity I (also known as Dexterity Fundamentals...
on
27 Sep 2009
Blog Post:
Using Integration Manager with Analytical Accounting
David Musgrave
When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where...
on
8 Sep 2009
Blog Post:
Developing Outside of the Box
David Musgrave
Recently I responded to a question on a newsgroup asking how to minimise a window from VBA (Visual Basic for Applications). The short answer is that it is not possible. But just because a Microsoft Dynamics GP window VBA object does not expose any methods or properties for the window state does not...
on
8 Mar 2009
Blog Post:
Hybrid - Adding Named Printers control to Reports using VBA
David Musgrave
Named Printers is a module to allow controlling of the printer and settings used when printing reports. It was originally developed for v3.00 by me while I was working for Sequel Technology (that's why the tables and calls are prefixed with ST). Later it was purchased by Great Plains for v5.50 and included...
on
13 Jan 2009
Blog Post:
Can I customise a 3rd party form with Dexterity?
David Musgrave
Over the last few weeks I have been asked a number of times about methods of customising a 3rd party form. This purpose of this post is to clarify what can and cannot be achieved with Dexterity. Usually, the developer has created a combined dictionary as per the instructions in the Integrating with...
on
9 Nov 2008
Blog Post:
Developer Documentation for Microsoft Dynamics GP
David Musgrave
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 to white papers comparing the tools and the architecture...
on
30 Oct 2008
Blog Post:
Hybrid - Using Menus for Visual Studio Tools from VBA Example
David Musgrave
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 approach that would expose the Menus for Visual Studio...
on
13 Oct 2008
Blog Post:
Hybrid - Purchasing Terms & Conditions Example
David Musgrave
This example shows how you can call a Dexterity report from Visual Basic for Applications (VBA). The report can be either a built in report or a custom report. If a built in report is used security will define whether the original, modified, alternate or modified alternate version will be printed. ...
on
29 Sep 2008
Blog Post:
Hybrid - Cheque Amount in Words Example
David Musgrave
One of the Report Writer functions added to v7.00 onwards (see Using the built-in Report Writer Functions ) was the RW_ConvertToWordsAndNumbers() function to convert a currency amount into words. After the code was added, it was realised that Report Writer calculated fields of return type string are...
on
29 Sep 2008
Blog Post:
Menus for Visual Studio Tools - The wait is over
David Musgrave
Some brilliant news for Microsoft Visual Studio developers who use Visual Studio Tools to integrate with Microsoft Dynamics GP 10.0. Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 has now been released on PartnerSource and CustomerSource . While I was in Fargo, ND for the Microsoft...
on
23 Sep 2008
Blog Post:
Hybrid - Adding Record Notes to a window Example
David Musgrave
I spent this morning discussing a very interesting customisation with my good friend Mariano Gomez . We had both seen a newsgroup posting asking if it was possible to add access to the Item Master's record note from the Item Inquiry window using VBA. Mariano had told me that he wanted to see if he could...
on
11 Sep 2008
Blog Post:
Hybrid - Running a macro to automatically close GP Example
David Musgrave
The following VBA example shows how a macro file can be started from VBA. This particular example will close Microsoft Dynamics GP when the Check Links window closes. As macros wait for background processes to complete, the macro will not start until the Check Links process and report have completed...
on
10 Sep 2008
Blog Post:
Choosing a Development Tool
David Musgrave
One of the great things about Microsoft Dynamics GP is the fact that there so many options available to integrate with or customise the application. There is a range from full development environments, to tools for consultants to utilities for the end user. The list includes Dexterity, Modifier...
on
10 Aug 2008
Blog Post:
Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0
David Musgrave
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 was that it is not possible to add menu entries...
on
29 Jul 2008
Blog Post:
Hybrid - Clearing the Last User on a Terminal Server Example
David Musgrave
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 or Citrix environment, multiple users use a single...
on
28 Jul 2008
Blog Post:
Hybrid - Dynamically Populating a Modifier Added List Example
David Musgrave
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 available in VBA to add items to a Dexterity...
on
24 Jul 2008
Blog Post:
Hybrid - Changing Screen Colours Depending on Company Example
David Musgrave
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 from VBA to use the Dexterity commands to select...
on
21 Jul 2008
Blog Post:
Modifier & VBA Samples
David Musgrave
This page contains a summary list of the Modifier & VBA samples that have been posted. Official Samples from CustomerSource/PartnerSource Modifier/VBA Samples for Great Plains 8.0 (CustomerSource) Modifier/VBA Samples for Great Plains 8.0 (PartnerSource) Modifier/VBA Samples for Microsoft...
on
10 Jul 2008
Page 1 of 1 (25 items)
Social Media Sharing