Click here to
Subscribe to
our Newsletter
Development related Posts
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).
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.
Visual Studio Integration Toolkit provides Application Programming Interfaces (APIs) to Visual Studio Tools for Microsoft Dynamics GP developers adding functionality that is normally only available to Dexterity developers.
For almost 20 years the application menus feature has been available at no charge as Menus for Visual Studio Tools from Microsoft and later Visual Studio Integration Toolkit from Winthrop Development Consultants. This was David Musgrave’s gift to the Microsoft Dynamics GP community. Sadly, as the cost of maintaining and supporting the product increases, it has become necessary to charge a small fee for subscriptions starting in 2027.
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:
Community Summit 2026 will be held at the Gaylord Opryland Resort in Nashville, Tennessee, USA from 11th October 2026 to 15th 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.
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.