SQL

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 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, 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 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 →

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 →

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

#GPPT Tracking changes to Item Cards Version 5

David Meego - Click for blog homepageThis is yet another update to the previous version of the change tracking project for Item cards:

Based on the version 4 project, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Continue reading →

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

#GPPT Tracking changes to Customer and Vendor Cards Version 6

David Meego - Click for blog homepageThis is yet another update to the previous versions of the change tracking projects for Customer and Vendor cards:

Based on the version 5 projects, this update for GP Power Tools Build 32 or later adds support for the Accounts window. Note it does require Build 32 or later to work.

Continue reading →

1 Comment Posted on by WinthropDC Development, Dynamics, GP, Microsoft, SQL Server

#MSDynGP Checking which Products have been used in Dynamics GP

David Meego - Click for blog homepageThis article is designed to help you perform a system audit on your Microsoft Dynamics GP system and is used as part of my Microsoft Dynamics GP Systems Audit session in the first week of the Dynamics GP Strategic Planning Digital Summit being held each Wednesday for the next 5 weeks.

Identifying the installed products in the system is fairly easy as you can look at the Dynamics.set launch file to see all the Dexterity product dictionaries loaded.

However, having a product loaded in a system does not necessarily mean that it has been used.

Continue reading →

5 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Item Cards Version 4

David Meego - Click for blog homepageThis is another update to the previous version of the change tracking project for Item cards:

Based on the version 3 project, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.

Continue reading →

5 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Customer and Vendor Cards Version 5

David Meego - Click for blog homepageThis is another update to the previous versions of the change tracking projects for Customer and Vendor cards:

Based on the version 4 projects, this update for GP Power Tools Build 32 changes the project to use a Custom Table and Custom Table Buffer calls rather than SQL Scripts and Parameter Lists. So, it does require Build 32 or later to work.

Continue reading →

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

#GPPT SQL Server Version Requirement Warning

David Meego - Click for blog homepageGP Power Tools build 30.2 added a feature to check the installed SQL Server version against the minimum supported version, as per the published System Requirements for Microsoft Dynamics GP, and will warn on login if the version of SQL Server does not meet the minimum system requirements.

Continue reading →

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

#GPPT Importing User Emails via Clipboard

David Meego - Click for blog homepageGP Power Tools has the ability to recreate user SQL logins after a server migration using the Database Validation window, or reset multiple user logins using the SQL Login Maintenance window. Both of these methods can use fixed or randomly generated passwords and have the ability to send emails to users with their new password. Also, changing the user’s password from the User Setup window can send an email.

The wording and formatting of these Password Reset emails can be defined in GP Power Tools by your system administrator. You can even use HTML to format the emails as described in the article below:

To be able to send emails to your users, you need to ensure that GP Power Tools knows the email addresses of the users. They are entered into the User Setup Additional Information window which can be opened from the User Setup window (if it is not set to automatically open). The sample code in this project shows how you can take the data from an Excel spreadsheet with the User ID and Emails of the users and import it from the clipboard directly into GP Power Tools.

Continue reading →

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

#GPPT Preventing Invalid Characters in Customer, Vendor and Item IDs

David Meego - Click for blog homepageThis is another “Must Have” free customization example for you Microsoft Dynamics GP system when you have GP Power Tools – Developer Tools module.

When creating new Customer, Vendor and Item cards, it is possible to include certain characters in the ID fields which can cause issues with Microsoft Dynamics GP, its ISV products and integrating products.

Continue reading →

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

#GPPT You do not have permission to run FN_TRACE_GETINFO

David Meego - Click for blog homepageGP Power Tools has the ability to capture SQL Profile Traces as one of the five different types of logs it can generate from Microsoft Dynamics GP.

To achieve this, GP Power Tools needs to change some permissions on the SQL Server so that it can both generate the Trace programmatically and also copy the resulting files to the shared Logging Folder.

Continue reading →

4 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Item Cards Version 3

David Meego - Click for blog homepageThis is a further update to the previous version of the change tracking project for Item Cards:

Based on the version 2 project, this update adds optional emailing of the changes made to a specified address.

Continue reading →

6 Comments Posted on by WinthropDC Development, Dexterity, Dynamics, GP, GP Power Tools, Microsoft, Products, SQL Server

#GPPT Tracking changes to Customer and Vendor Cards Version 4

David Meego - Click for blog homepageThis is another update to the previous versions of the change tracking projects for Customer and Vendor cards:

Based on the version 3 projects, this update adds optional emailing of the changes made to a specified address.

Continue reading →