Category: Development

Development related Posts

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with , , , , , No Comments

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 »

Posted on Posted in Development, Dexterity Tagged with , , 2 Comments

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.
Read more »

Posted on Posted in Development, Visual Studio Tagged with , No Comments

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.
Read more »

Posted on Posted in Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Training Tagged with , , , , No Comments

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 »

Posted on Posted in Conference, Development, Dexterity, Dynamics, GP, Microsoft, Training Tagged with , , , , No Comments

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 »

Posted on Posted in Business, Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Training Tagged with , , , , , , , No Comments

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 »

Posted on Posted in Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training, Visual Studio Integration Toolkit Tagged with , , , , , , No Comments

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 »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Visual Studio Integration Toolkit Tagged with , , , , , , , , No Comments

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 »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with , , , , No Comments

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 »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with , , , , No Comments

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.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with , , , , No Comments

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.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with , , , , No Comments

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.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with , , , , No Comments

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.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with , , , , No Comments

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.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with , , , , , No Comments

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.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with , , , , , No Comments

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.

Read more »

Posted on Posted in Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training Tagged with , , , , , , No Comments

David Meego - Click for blog homepageIf you need to customize Microsoft Dynamics GP or maintain existing customizations, David Musgrave from Winthrop Development Consultants will be running two extremely valuable development training courses before Community Summit 2025 and now it is time to register.

The conference will be held on the 19th to 23rd October 2025. There will be pre-conference GP Development training in the week before the conference as well as Academy days before and after the conference itself.

HURRY: LAST DAYS TO REGISTER

Read more »

Posted on Posted in Development, Dynamics, GP, Microsoft, SQL Server Tagged with , 1 Comment

David Meego - Click for blog homepageThis article is designed to help you perform a system audit on your Microsoft Dynamics GP system and is used as part of my Microsoft Dynamics GP Systems Audit session in the first week of the Dynamics GP Strategic Planning Digital Summit being held each Wednesday for the next 5 weeks.

Identifying the installed products in the system is fairly easy as you can look at the Dynamics.set launch file to see all the Dexterity product dictionaries loaded.

However, having a product loaded in a system does not necessarily mean that it has been used.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with , , , , , No Comments

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.

Read more »

Posted on Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with , , , , , No Comments

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

Based on the version 4 projects, 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.

Read more »