Microsoft – Page 2 – Winthrop Development Consultants Blog

#MySummitNA See you soon at Community Summit 2025 in Orlando

Posted on 10 October 2025 Posted in Conference, Dynamics, GP, GPUG, Microsoft Tagged with Application, Community Summit 2025, Conference, GPUG

Today, I am off on my way to Orlando, Florida, USA for the Community Summit 2025 conference. With a 12 hour time difference between Perth and Orlando and an almost equal distance from the equator, I will truly be going halfway around the globe with my Friday lasting 36 hours.

I will be presenting a 5 day Dexterity class and a 1 day GP Power Tools class and then being involved with and presenting at least seven sessions. I will also be taking advantage of a number of “Advanced Networking Opportunities” including being a sponsor of the PowerGP Online party on Wednesday night.

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

Posted on 8 October 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with Development, Dexterity, GP Power Tools, GPPT, SQL

Welcome 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:

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

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.

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

Posted on 6 October 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with Development, Dexterity, GP Power Tools, GPPT, SQL

Welcome 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:

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

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

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

Posted on 3 October 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with Development, Dexterity, GP Power Tools, GPPT, SQL

Welcome 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:

#GPPT Beginner’s Guide to Adding Custom Fields – Introduction

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

#MSDynGP Microsoft Dynamics GP 18.8 – October 2025 has released

Posted on 1 October 2025 Posted in Batch Posting Service Toolkit, Conference, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training, Visual Studio Integration Toolkit Tagged with Batch Posting Service Toolkit, BPST, Community Summit 2022, Conference, GP Power Tools, GPPT, GPUG, Training, User Group Summit North America, Visual Studio Integration Toolkit, VSIT

The 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:

#MSDynGP Microsoft Dynamics GP v18.8 ISV Pre-release installers now available

#GPPT Adding Virtual Fields to Item Maintenance Version 2

Posted on 29 September 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, Virtual Fields

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

#GPPT Last Chance to register for GP Power Tools Workshop 2025

Posted on 24 September 2025 Posted in Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Training Tagged with Community Summit 2025, Conference, GP Power Tools, GPPT, Training

Are 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 19^th October.

#Dexterity Last Chance to register for GP Dexterity Bootcamp 2025

Posted on 23 September 2025 Posted in Conference, Development, Dexterity, Dynamics, GP, Microsoft, Training Tagged with Community Summit 2025, Conference, Development, Dexterity, Training

Are 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 13^th to Friday 17^thOctober.

#MySummitNA Dynamic Communities Summit MVP Insights Podcast

Posted on 1 September 2025 Posted in Business, Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Training Tagged with Community Summit 2025, Conference, Development, Dexterity, GP Power Tools, GPPT, GPUG, Training

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

#MySummitNA Winthrop Development Consultants at Community Summit Orlando 2025

Posted on 29 August 2025 Posted in Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training, Visual Studio Integration Toolkit Tagged with Community Summit 2025, Conference, Dexterity, GP Power Tools, GPPT, GPUG, Training

In 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 13^th to Friday 17^th October 2025), I will be running Dexterity Fundamentals training at the Gaylord Palms Resort and Convention Center in Kissimmee. Then on Sunday 19^th 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.

#GPPT Using .Net Math Functions from Microsoft Dynamics GP

Posted on 25 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Visual Studio Integration Toolkit Tagged with Application, Custom Forms, Development, Dexterity, GP Power Tools, GPPT, Virtual Fields, Visual Studio Integration Toolkit, VSIT

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

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

Posted on 22 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with Application, Development, Dexterity, GP Power Tools, GPPT

This 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:

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

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.

#GPPT Making Salesperson ID on Sales Customer Detail Entry Required

Posted on 21 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with Application, Development, Dexterity, GP Power Tools, GPPT

This 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:

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

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.

#GPPT Making Substitute Item 1 on Item Maintenance Options Required

Posted on 20 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with Application, Development, Dexterity, GP Power Tools, GPPT

This 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:

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

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

#GPPT Making Tax Registration Number on Vendor Maintenance Options Required

Posted on 19 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with Application, Development, Dexterity, GP Power Tools, GPPT

This 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:

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

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

#GPPT Making Tax Registration Number on Customer Maintenance Options Required

Posted on 18 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with Application, Development, Dexterity, GP Power Tools, GPPT

This 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:

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

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

#MSDynGP Microsoft Dynamics GP v18.8 ISV Pre-release installers now available

Posted on 16 August 2025 Posted in Batch Posting Service Toolkit, Dynamics, GP, GP Power Tools, Microsoft, News, Products, Visual Studio Integration Toolkit Tagged with Application, Batch Posting Service Toolkit, BPST, Dynamics GP, GP Power Tools, GPPT, News, Visual Studio Integration Toolkit, VSIT

Good News for the Microsoft Dynamics GP Community.

Friday morning (Perth Time) I had an email from Terry Heley from Microsoft with a link to a pre-release (ISV Drop) of the upcoming Microsoft Dynamics GP version 18.8 (October 2025) release. This download is provided to the ISV community to help them prepare for the final code when it is released.

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

Posted on 15 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products Tagged with Application, Development, Dexterity, GP Power Tools, GPPT

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

#GPPT Tracking changes to Item Cards Version 5

Posted on 13 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL

This is yet another update to the previous version of the change tracking project for Item cards:

#GPPT Tracking changes to Item Cards Version 4

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.

#GPPT Tracking changes to Customer and Vendor Cards Version 6

Posted on 11 August 2025 Posted in Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server Tagged with Application, Development, Dexterity, GP Power Tools, GPPT, SQL

This is yet another update to the previous versions of the change tracking projects for Customer and Vendor cards:

#GPPT Tracking changes to Customer and Vendor Cards Version 5

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.

Category: Microsoft