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.
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.
Recently, Mike from Thybar Corporation contacted me about an issue he was seeing in Microsoft Dynamics GP v18.7 with General Journal document attachments.
Journal Entry attachments that had been added before upgrading Microsoft Dynamics GP to v18.7 could no longer be viewed from the Journal Entry Inquiry window after the upgrade.
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.
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:
As much as I love and use Microsoft Products, they sometimes make bad decisions or introduce very annoying bugs. This article addresses a bug introduced on 16-Dec-2025 in Microsoft Outlook Version 2512 (Build 19530.20038 Click-to-Run) Current Channel.
The issue is that email signatures using a table will now have the border showing by default regardless of whether it was showing before the update.
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.
I am finally getting back to work after travelling and presenting at Community Summit 2025 in Orlando and visiting family in the UK. Still got lots of tasks to catch up on but I wanted to write about the Knights of GP.
The Knights of GP is planned to be a community based co-op of customers, consultants, Independent Software Developers (ISVs) and partners who will work together after Microsoft stops supporting Microsoft Dynamics GP to allow the product to remain supported by the community who use and love it. Join us for the tomorrow’s Fireside Chat…
This is an article I wrote for the recently released Fido magazine. The magazine was published in time for Community Summit 2025 in Orlando by Fidesic, who offer Payables Automation solutions for Microsoft Dynamics GP and Microsoft Dynamics 365 Business Central. Go visit them at booth 1545 for the full magazine.
Thanks to Carl Robinette from Fidesic who reached out and offered the opportunity to write an article for the magazine, and to my wife, Jennifer, who helped me with multiple rewrites. 🙂
Continue reading
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.
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).
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:
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).
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:
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.