GP – Page 3 – Winthrop Development Consultants Blog

Batch Posting Service Toolkit, Business, Dynamics, GP, GP Power Tools, Microsoft, News, Products, Public Service Announcement, Visual Studio Integration Toolkit

#MSDynGP The Knights of GP – Commitment beyond 2031

Apr 2, 2026 Tagged with Application, Batch Posting Service Toolkit, BPST, GP Power Tools, GPPT, News, PSA, Visual Studio Integration Toolkit, VSIT No Comments

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.

Conference, Development, Dexterity, Dynamics, GP, GPUG, Microsoft, Training

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

Mar 25, 2026 Tagged with Community Summit 2024, Conference, Dexterity, GPUG, Training No Comments

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.

Development, Dexterity, Dynamics, GP, Microsoft, SQL Server

#MSDynGP Microsoft Dynamics GP v18.7 Document Attach Fix Creates Data Issue

Mar 17, 2026 Tagged with Application, Exception, SQL No Comments

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.

Development, Dexterity, Dynamics, GP, Microsoft

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

Mar 6, 2026 Tagged with Application, Dexterity, Exception No Comments

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.

Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Adding 6 Additional Item Category Fields Version 2

Mar 5, 2026 Tagged with Application, Dexterity, GP Power Tools, GPPT No Comments

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.

Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT #MSDynGP Making your Dynamics GP system faster and decreasing data space Part 3

Dec 19, 2025 Tagged with Application, GP Power Tools, GPPT, SQL No Comments

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.

Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT #MSDynGP Making your Dynamics GP system faster and decreasing data space Part 2

Dec 17, 2025 Tagged with Application, GP Power Tools, GPPT, SQL No Comments

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.

Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT #MSDynGP Making your Dynamics GP system faster and decreasing data space Part 1

Dec 15, 2025 Tagged with Application, GP Power Tools, GPPT, SQL No Comments

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.

Business, Conference, Dynamics, GP, Microsoft, News, Public Service Announcement

#MSDynGP The Knights of GP – Join the Fireside Chat

Nov 10, 2025 Tagged with Application, Conference, Knights of GP, News, PSA No Comments

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…

Business, Conference, Dynamics, GP, Microsoft, News, Public Service Announcement

#MSDynGP Support for Microsoft Dynamics GP is Ending – What now?

Oct 20, 2025 Tagged with Application, Community Summit 2025, Conference, News, PSA No Comments

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