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).

Read more →

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).

Read more →

David Meego - Click for blog homepageThe next version of Microsoft Dynamics GP has been released, and it contains more new features and bug fixes.

Winthrop Development Consultants has already updated its products for this Microsoft Dynamics GP 18.8 – October 2025 release. They are now built against the final build and so are no longer beta builds.

Check out the previous article for more information:

Read more →

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.

Read more →

David Meego - Click for blog homepageAre you looking to unlock the full potential of your Dynamics GP system?

Hi, I’m David Musgrave, Managing Director of Winthrop Development Consultants from Perth, Western Australia. I’m thrilled to invite you to the one-day workshop: “Optimizing your system with GP Power Tools” at Summit Academy, on Sunday 19th October.

Read more →

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.

Read more →

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.

Read more →

David Meego - Click for blog homepageIn just over a month’s time my wife, Jennifer, and I will be flying from Perth via Sydney and Dallas/Fort Worth to Orlando, Florida, USA for two weeks at the Community Summit 2025 conference.

During the first week (Monday 13th to Friday 17th October 2025), I will be running Dexterity Fundamentals training at the Gaylord Palms Resort and Convention Center in Kissimmee. Then on Sunday 19th October, I will be running Academy training for GP Power Tools.

Once the conference starts, please come see us at Expo Booth 310. Read on for more information on the two training classes and seven sessions I am presenting or assisting with.

Read more →

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.

Read more →

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.

Read more →