#VSIT Visual Studio Integration Toolkit Subscription Changes for 2027

David Meego - Click for blog homepageVisual Studio Integration Toolkit provides Application Programming Interfaces (APIs) to Visual Studio Tools for Microsoft Dynamics GP developers adding functionality that is normally only available to Dexterity developers.

For almost 20 years the application menus feature has been available at no charge as Menus for Visual Studio Tools from Microsoft and later Visual Studio Integration Toolkit from Winthrop Development Consultants. This was David Musgrave’s gift to the Microsoft Dynamics GP community. Sadly, as the cost of maintaining and supporting the product increases, it has become necessary to charge a small fee for subscriptions starting in 2027.

Continue reading

#GPPT Implementing Custom Forms using GP Power Tools 2

David Meego - Click for blog homepageWhen GP Power Tools Build 32 was released, it added powerful Custom Table functionality which allows for a developer to create a custom table definition and have that table created in each company automatically. The table can then be used in a similar fashion to a native Dexterity table using a suite of Custom Table Buffer Helper Functions.

This article updates the original article (below), which explained how to create a Custom Forms Module demonstration project, to use Custom Tables instead of SQL Tables for a much faster and simpler implementation.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Update: Using Custom Tables

David Meego - Click for blog homepageWelcome to the eleventh article as an update to the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will show how to use Custom Tables (added in Build 32) to store data rather than the DUOS table. In the previous articles we included the Customization Maintenance packages and showed how to use manual SQL tables.

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Update: Using manual SQL tables

David Meego - Click for blog homepageWelcome to the tenth article as an update to the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will show how to use manual SQL tables to store data rather than the DUOS table. In the previous article we included the Customization Maintenance packages. In the following article we will show how to use GPPT Custom Tables (even better than manual SQL tables).

Continue reading

#GPPT Beginner’s Guide to Adding Custom Fields – Update: Including the Modified Resources

David Meego - Click for blog homepageWelcome to the ninth article as an update to the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.

The series should be read in order starting with the introduction article:

In this article we will provide updates to the project adding the modified window and report to the project. In the following articles we will show how to use manual SQL tables and then GPPT Custom Tables (even better than manual SQL tables).

Continue reading

#GPPT Adding Virtual Fields to Item Maintenance Version 2

David Meego - Click for blog homepageGP Power Tools Build 32 added Custom Tables as a new feature to the Developer Tools module. Custom Tables can automatically create and maintenance SQL tables in company (or system) databases as defined by the definition in the Custom Tables Setup window.

This is an updated version of the #GPPT Adding Virtual Fields to Item Maintenance project which uses a Custom Table to store the data rather than the DUOS. Easy access to the Custom Tables is provided by a series of Custom Table Buffer Helper Functions which replicate how Dexterity table buffers work.

Continue reading

Repost: DexSense by Tim Gordon from AlphaSoft

David Meego - Click for blog homepageThis is a repost of an original article by Tim Gordon October 2017 that I found very useful but is no longer available online. Originally published as

Thanks to the Internet Archive Wayback Machine I was able to recover the last version of the article from June 2021 and am posting it here as a reference.
Continue reading

Repost: Centering a Message Box on the Active Window in C# by Jason Carr

David Meego - Click for blog homepageThis is a repost of an original article by Jason Carr from August 2009 that I found very useful but is no longer available online. Originally published as

Thanks to the Internet Archive Wayback Machine I was able to recover the last version of the article from November 2020 and am posting it here as a reference.
Continue reading

#Dexterity Last Chance to register for GP Dexterity Bootcamp 2025

David Meego - Click for blog homepageAre you ready to take your Dynamics GP skills to the next level?

Hi, I’m David Musgrave, Managing Director at Winthrop Development Consultants from Perth, Western Australia. I’m excited to invite you to the upcoming GP Dexterity Bootcamp, happening in Orlando the week before Community Summit—from Monday 13th to Friday 17th October.

Continue reading

#MySummitNA Dynamic Communities Summit MVP Insights Podcast

David Meego - Click for blog homepageA little while ago I recorded an MVP Insights podcast with Pam Misialek from Dynamic Communities.

We discussed the future of Microsoft Dynamics GP and the Academy training and sessions I am presenting at Community Sumit 2025 in Orlando, Florida, USA.

Continue reading

#GPPT Using .Net Math Functions from Microsoft Dynamics GP

David Meego - Click for blog homepageA recent customization project I was working on using GP Power Tools required the calculation of a square root as part of some number crunching needed to work out material quantities on a Sales Order Processing transaction.

While Dexterity (the language behind Microsoft Dynamics GP) is great at accounting style mathematics (as per a standard calculator), it does not have advanced functions for powers, logs, and trigonometry (as per a scientific calculator). This means that there is no “native” method to calculate a square root.

However, Dexterity (from v14.0 onwards) has a .Net Interop which allows you to import and call .Net libraries directly from your Dexterity scripts. This example shows how to call the System.Math library as well as other advanced techniques, such as Custom Forms and Virtual Fields.

Continue reading

#GPPT Making Tax Registration Number on Purchasing Vendor Detail Entry Required

David Meego - Click for blog homepageThis is the sixth article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Tax Registration Number field on the Purchase Order Entry – Purchasing Vendor Detail Entry sub window (separate form) required.

Continue reading

#GPPT Making Salesperson ID on Sales Customer Detail Entry Required

David Meego - Click for blog homepageThis is the fifth article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Salesperson ID field on the Sales Transaction Entry – Sales Customer Detail Entry sub window (separate form) required.

Continue reading

#GPPT Making Substitute Item 1 on Item Maintenance Options Required

David Meego - Click for blog homepageThis is the fourth article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Substitute Item 1 field on the Item Maintenance Options sub window (same form) required.

Continue reading

#GPPT Making Tax Registration Number on Vendor Maintenance Options Required

David Meego - Click for blog homepageThis is the third article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Tax Registration Number field on the Vendor Maintenance Options sub window (same form) required.

Continue reading

#GPPT Making Tax Registration Number on Customer Maintenance Options Required

David Meego - Click for blog homepageThis is the second article in the series on making window fields required. If you have not yet read the introduction article to the series, please read that first:

This example uses GP Power Tools code to make the Tax Registration Number field on the Customer Maintenance Options sub window (same form) required.

Continue reading

#GPPT Making Window Fields Required and Why It Does Not Always Work

David Meego - Click for blog homepageThis is the first post in a series of six articles discussing making additional Window Fields required and why the standard technique using Modifier does not always work.

For a field to behave as required, there are a number of different factors that must all fall into place. This article will explain the theory and what can go wrong. Links to examples with sample code will be published over the next week.

Continue reading

#GPPT Tracking changes to Item Cards Version 5

David Meego - Click for blog homepageThis is yet another update to the previous version of the change tracking project for Item cards:

Based on the version 4 project, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Continue reading

#GPPT Tracking changes to Customer and Vendor Cards Version 6

David Meego - Click for blog homepageThis is yet another update to the previous versions of the change tracking projects for Customer and Vendor cards:

Based on the version 5 projects, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Continue reading

#GPPT Tracking changes to Item Cards Version 4

David Meego - Click for blog homepageThis is another update to the previous version of the change tracking project for Item cards:

Based on the version 3 project, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.

Continue reading