Development

Development related Posts

Leave a comment Posted on by WinthropDC Dynamics, GP, Microsoft, SQL Server

#MSDynGP SQL Server 2025 Default Password Verifiers Causing Slow Microsoft Dynamics GP Performance

David Meego - Click for blog homepageAfter the release of Microsoft SQL Server 2025, we are now starting to see customer sites implementing the new version in their Microsoft Dynamics GP environments.

So far, I have been notified by two customers, that I work closely with, that they are having issues with Dynamics GP performance being slower on the SQL Server 2025 than their previous SQL Server version.

The following information on the issue and a solution has been provided by my colleague and friend, Arthur Achilleos, with a call out to Rob Farley MVP (who assisted Arthur’s troubleshooting).

Continue reading →

Leave a comment Posted on by WinthropDC Robocup Junior, Robotics, Spike Prime

#Robotics Programming a Spike Prime Line Following Robot – Part 3

David Meego - Click for blog homepageAt the end of the second article in this series, I mentioned some additional line following methods. In this article I will explain the theory and initial code to get a Lego Spike Prime robot following a line.

Disclaimer: This article will use Robocup Junior Australia‘s Rescue (Line) Challenge with a Lego Spike Prime robot as an example.

If you have not read the previous articles, please do so before continuing:

Continue reading →

Leave a comment Posted on by WinthropDC Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#MSDynGP A save operation on table ‘XXXX’ (45)

David Meego - Click for blog homepageRecently 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).

Continue reading →

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

#GPPT Making Reason Code on Inventory Transactions Required

David Meego - Click for blog homepageThis 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.

Continue reading →

2 Comments Posted on by WinthropDC Business, Development, Menus for Visual Studio Tools, News, Products, Visual Studio Integration Toolkit

#VSIT Visual Studio Integration Toolkit Subscription Changes for 2027

David Meego - Click for blog homepageVisual 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.

Continue reading →

1 Comment Posted on by WinthropDC Conference, Development, Dexterity, Dynamics, GP, GPUG, Microsoft, Training

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

David Meego - Click for blog homepageDo 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 →

Leave a comment Posted on by WinthropDC Development, Dexterity, Dynamics, GP, Microsoft, SQL Server

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

David Meego - Click for blog homepageRecently, 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.

Continue reading →

2 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, Microsoft

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

David Meego - Click for blog homepageThis 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 by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Adding 6 Additional Item Category Fields Version 2

David Meego - Click for blog homepageHere 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:

  1. 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.
  2. Updating the Report Writer functions with the faster memory-based parameters options.
  3. 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 by WinthropDC Conference, Development, Dexterity, News, Training

#MySummitNA Community Summit 2026 GP Development Training Survey

David Meego - Click for blog homepageCommunity 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.

Continue reading →

2 Comments Posted on by WinthropDC Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

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

David Meego - Click for blog homepageOver 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.

Continue reading →

2 Comments Posted on by WinthropDC Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

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

David Meego - Click for blog homepageOver 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.

Continue reading →

2 Comments Posted on by WinthropDC Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

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

David Meego - Click for blog homepageOver 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.

Continue reading →

Leave a comment Posted on by WinthropDC Development, Dexterity, GP Power Tools, Products, Uncategorized, Visual Studio Integration Toolkit

#GPPT Implementing Custom Forms using GP Power Tools 2

David Meego - Click for blog homepageWhen 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.

Continue reading →

1 Comment Posted on 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

David Meego - Click for blog homepageWelcome 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.

Continue reading →

1 Comment Posted on 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

David Meego - Click for blog homepageWelcome 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).

Continue reading →

2 Comments Posted on 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

David Meego - Click for blog homepageWelcome 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).

Continue reading →

1 Comment Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products

#GPPT Adding Virtual Fields to Item Maintenance Version 2

David Meego - Click for blog homepageGP 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 by WinthropDC Development, Dexterity

Repost: DexSense by Tim Gordon from AlphaSoft

David Meego - Click for blog homepageThis 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

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 →