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.

Read more →

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.

Read more →

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

Read more →

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.

Read more →

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.

Read more →

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.

Read more →

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

Read more →

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

Read more →

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

Read more →

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.

Read more →