Recently an issue came up on a customer’s system and today another customer had a similar issue. I thought it would be worth writing it up on the blog to help others who come across it.
The issue is an error when attempting to save data within Microsoft Dynamics GP resulting in a dialog in the form below:
Unhandled database exception: A save operation on table ‘XXXX’ (45).
Build 33.5 of GP Power Tools was released on 13-May-2026. This build consolidates critical fixes and enhances some features from the Build 33.1 release.
We strongly encourage all our customers to stay updated with the latest builds of our products for their version of Microsoft Dynamics GP. We always want our customers on the latest code to get the best experience with all the new features and fixes that their subscription entitles them to.
This is the seventh 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 to make the Reason Code field on the Item Transfer Entry Scrolling window required. This article was prompted by a support request that came in today.
Everyone wants extra user defined fields on their Microsoft Dynamics GP windows. In the previous articles we showed how easy it is to add, modify and format the layout of extra fields using GP Power Tools with the new Custom Fields feature.
We thought we were done, but now the request has come through from the HR team to include the Pet related custom fields on the Employee report.
Winthrop Development Consultants is absolutely thrilled to announce that Build 33 of GP Power Tools (GPPT) for Microsoft Dynamics GP was released yesterday, on 01-May-2026.
This fantastic build includes not one, but two major new features that solve some highly demanded, long awaited functionality requests for Microsoft Dynamics GP. The build also includes many enhancements and improvements to existing functionality across the entire product.
This article provides details on the major new features and enhancements. It doesn’t list everything, but to give you an idea of how much has been added, the user guide manual has grown from 833 pages in build 31 to 882 pages in build 32 to 919 pages in build 33.
Everyone wants extra user defined fields on their Microsoft Dynamics GP windows. In the previous articles we showed how easy it is to add, modify and format the layout of extra fields using GP Power Tools with the new Custom Fields feature.
Now we have one final request…. The HR Team want to have the custom fields displayed on the Employee Inquiry window.
Everyone wants extra user defined fields on their Microsoft Dynamics GP windows. In the previous articles we showed how easy it is to add and modify extra fields using GP Power Tools with the new Custom Fields feature.
Now we have a yet another problem …. “Boss Level Scope Creep”….
Everyone wants extra user defined fields on their Microsoft Dynamics GP windows. In the previous article we showed how easy it is to add extra fields using GP Power Tools and its new Custom Fields feature.
Now we have a new problem …. “Scope Creep”. The HR department has realized that their employees might have more than once pet and so would need allow for multiple types of pets to be selected.
Everyone wants extra user defined fields on their Microsoft Dynamics GP windows. It is possible to add extra fields but there have always been compromises. Either it requires custom development with scripting and modified or alternate windows, or fields are in a separate window or sidebar, and the data is often stored in multiple records across multiple tables.
This year, as we celebrate 20 years of GP Power Tools, the upcoming Build 33 adds Custom Fields. This amazing new feature allows you to add almost any field to any window without any code or using Modifier.
This year GP Power Tools turns 20 years’ old, and we will celebrate by releasing Build 33 with many enhancements and new features and some fixes. The release of GP Power Tools Build 33 for Microsoft Dynamics GP v18.4 or later is planned for mid-year, once all the development and documentation is completed.
We are excited to tell you about one of the major new features … Login Control.
Winthrop Development Consultants is fully committed to the continued support of Microsoft Dynamics GP and its ecosystem. Our ISV products are only compatible with Dynamics GP and have been created to solve pain points and missing features as requested by the GP community.
While Microsoft has stated that they will cease support for Dynamics GP in 2031, it is important to note that “End of Support” does not equate to “End of Life”. There is plenty of life left in the product and, with the support of the community, GP will live on well past the official end of support. A driving force in the community support will be the Knights of GP.
Want to learn how to get the most out of GP Power Tools? Discover all the benefits of each module and how you can employ them in your systems? GP Power Tools is the ultimate suite of tools to get the most out of your Microsoft Dynamics GP system, regardless if you are a user, a system admin, a consultant, a developer or a database administrator.
I am pleased to announce that as well as the Dexterity Training (during the week before the conference), there will also be GP Power Tools training offered at Academy at Summit in the days before Community Summit in Nashville, Tennessee, USA.
There is always lots of new functionality and enhancements to cover with the release the latest builds of GP Power Tools. It has features that will benefit all users of GP regardless of the level of the technical experience.
Here is an awesome update to the previous sample customization which added 6 Additional Item Category Fields:
This update makes the following improvements, but does need at least Build 32 of GP Power Tools to work:
Over time the amount of data stored by your Microsoft Dynamics GP system can get quite large. Without buying new hardware, there is a simple way to make your system faster and decrease the space used to store your databases.
This is where a couple of the features of the Database Module of GP Power Tools come in to help. This is article 3 of 3 in the series.
Over time the amount of data stored by your Microsoft Dynamics GP system can get quite large. Without buying new hardware, there is a simple way to make your system faster and decrease the space used to store your databases.
This is where a couple of the features of the Database Module of GP Power Tools come in to help. This is article 2 of 3 in the series.
Over time the amount of data stored by your Microsoft Dynamics GP system can get quite large. Without buying new hardware, there is a simple way to make your system faster and decrease the space used to store your databases.
This is where a couple of the features of the Database Module of GP Power Tools come in to help. This is article 1 of 3 in the series.
Build 32.2 of GP Power Tools was released on 02-Dec-2025. This build consolidates fixes and enhances some features from the Build 32.1 release.
We strongly encourage all our customers to stay updated with the latest builds of our products for their version of Microsoft Dynamics GP. We always want our customers on the latest code to get the best experience with all the new features and fixes that their subscription entitles them to.
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.
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:
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.
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:
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).