Winthrop Development Consultants Blog

Dexterity

1 Comment Posted on 25 March 202610 April 2026 by WinthropDC Conference, Development, Dexterity, Dynamics, GP, GPUG, Microsoft, Training

#Dexterity Announcing Dexterity Training before Community Summit 2026 in Nashville, TN, USA

Do you want to customize Microsoft Dynamics GP or have customizations that you want to support into the future? Now is your chance for both customers and partners to get trained in Dexterity, the development environment that Dynamics GP is built on.

Understanding Dexterity will help any developer working with Dynamics GP regardless of the development environment they end up using. This knowledge is vital for developers using Dexterity, Visual Studio Tools (C# or VB.Net), “End of Life” Visual Basic for Applications (VBA) or using the GP Power Tools – Developer Tools module.

I will be running the 5-day Dexterity Fundamentals for Dynamics GP bootcamp training class in the week before the Community Summit conference in Nashville, Tennessee, USA in October. Please register for the training now and plan to be in Nashville for the week before the conference.

Continue reading →

2 Comments Posted on 6 March 20265 March 2026 by WinthropDC Development, Dexterity, Dynamics, GP, Microsoft

Temp Table Errors – An open operation on table ‘MBS_sySecurityView’ failed because the path does not exist

This article is an update to previous articles about errors on temporary tables when using Microsoft Dynamics GP. We have seen a recent increase in issues of this type as well as a misunderstanding of what is happening to cause the issues.

The issue shows as a dialog with a message like:

An open operation on table ‘MBS_sySecurityView’ failed because the path does not exist
An open operation on table ‘WDC_Field_Security_Tag_TEMP’ failed because the path does not exist
An open operation on table ‘IV_Reconcile_PO_TEMP’ has an incorrect record length.

The name of the table can vary but the examples above include a couple of common ones from products I created, being GP Power Tools and Field Level Security (Advanced Security). However, this issue is due to the Windows environment and has nothing to do with the Dexterity product or SQL Server.

Continue reading →

2 Comments Posted on 5 March 202623 March 2026 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Adding 6 Additional Item Category Fields Version 2

Here is an awesome update to the previous sample customization which added 6 Additional Item Category Fields:

#GPPT Adding 6 Additional Item Category Fields

This update makes the following improvements, but does need at least Build 32 of GP Power Tools to work:

Replacing the data storage location with GPPT Custom SQL Tables instead of the DUOS (Dynamic User Object Store) table, including providing a script to move any existing DUOS data to the new tables.
Updating the Report Writer functions with the faster memory-based parameters options.
Adding the 6 additional Item Category fields to the Item Class Setup window, including pulling the fields when a class is added and roll down class level changes.

Continue reading →

3 Comments Posted on 30 January 202624 March 2026 by WinthropDC Conference, Development, Dexterity, News, Training

#MySummitNA Community Summit 2026 GP Development Training Survey

Community Summit 2026 will be held at the Gaylord Opryland Resort in Nashville, Tennessee, USA from 11^th October 2026 to 15^th October 2026. I am again planning to offer Microsoft Dynamics GP Development Training during the week before the conference. Please respond to the survey below to register your interest and preference for what training class should be run.

Update: The 5 day Dexterity I course and the 1 day GP Power Tools workshop have been selected.

Continue reading →

Leave a comment Posted on 13 October 202516 March 2026 by WinthropDC Development, Dexterity, GP Power Tools, Products, Uncategorized, Visual Studio Integration Toolkit

#GPPT Implementing Custom Forms using GP Power Tools 2

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

#GPPT Implementing Custom Forms using GP Power Tools

Continue reading →

1 Comment Posted on 8 October 202516 March 2026 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

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

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.

Continue reading →

1 Comment Posted on 6 October 202516 March 2026 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

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

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

Continue reading →

2 Comments Posted on 3 October 202529 September 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

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

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

Continue reading →

1 Comment Posted on 29 September 202517 March 2026 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Adding Virtual Fields to Item Maintenance Version 2

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.

Continue reading →

2 Comments Posted on 26 September 20251 October 2025 by WinthropDC Development, Dexterity

Repost: DexSense by Tim Gordon from AlphaSoft

This 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

https://www.alphasoft.co.za/pn/index.php/dexsense/ (broken link)

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 →

Leave a comment Posted on 23 September 202523 September 2025 by WinthropDC Conference, Development, Dexterity, Dynamics, GP, Microsoft, Training

#Dexterity Last Chance to register for GP Dexterity Bootcamp 2025

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.

Continue reading →

Leave a comment Posted on 1 September 20251 September 2025 by WinthropDC Business, Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Training

#MySummitNA Dynamic Communities Summit MVP Insights Podcast

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.

Continue reading →

4 Comments Posted on 29 August 202526 October 2025 by WinthropDC Conference, Development, Dexterity, Dynamics, GP, GP Power Tools, GPUG, Microsoft, Products, Training, Visual Studio Integration Toolkit

#MySummitNA Winthrop Development Consultants at Community Summit Orlando 2025

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.

Continue reading →

Leave a comment Posted on 25 August 20258 October 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, Visual Studio Integration Toolkit

#GPPT Using .Net Math Functions from Microsoft Dynamics GP

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.

Continue reading →

Leave a comment Posted on 22 August 202521 August 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

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

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.

Continue reading →

Leave a comment Posted on 21 August 202521 August 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Making Salesperson ID on Sales Customer Detail Entry Required

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.

Continue reading →

Leave a comment Posted on 20 August 202521 August 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Making Substitute Item 1 on Item Maintenance Options Required

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.

Continue reading →

Leave a comment Posted on 19 August 202521 August 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Making Tax Registration Number on Vendor Maintenance Options Required

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.

Continue reading →

Leave a comment Posted on 18 August 202521 August 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Making Tax Registration Number on Customer Maintenance Options Required

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.

Continue reading →

5 Comments Posted on 15 August 202514 August 2025 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

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

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.

Continue reading →