#GPPT GP Power Tools Build 31.4 hotfix released

Build 31.4 of GP Power Tools was released on 06-Dec-2024. This build fixes and enhances some features from the Build 31.3 release.

We strongly encourage all our customers to stay updated with the latest builds of our products for their version of Microsoft Dynamics GP. We always want our customers on the latest code to get the best experience with all the new features and fixes, but we have also discontinued old builds primarily because of the Security Vulnerability discovered and fixed in August 2022.

Build 31.4 hotfix of GP Power Tools is available for the following Microsoft Dynamics GP versions:

Microsoft Dynamics GP Modern Lifecycle (v18.2)
Microsoft Dynamics GP Modern Lifecycle (v18.3)
Microsoft Dynamics GP Modern Lifecycle (v18.4)
Microsoft Dynamics GP Modern Lifecycle (v18.5)
Microsoft Dynamics GP Modern Lifecycle (v18.6)
Microsoft Dynamics GP Modern Lifecycle (v18.7)

The build 31.4 hotfix includes the following changes in detail:

System Module

Updated multiple windows and scripts to add Machine ID into all exported files and Logs.

Administrator Tools Module

Fixed issue where entering a Message ID of 32768 or higher generated an error on Resource Information window.
Updated Security Information window to allow suppression of the Security Tasks and Security Roles from the Security Information report.

Developer Tools Module

Fixed Field Context Menu trigger to return focus to the field after pulling focus from the window using Window_SetFocus() rather than Focus command.
Updated Project Lookup window to show the Project Disabled checkbox.
Updated Trigger Setup window with extra dialogs to prevent accidental overwriting of the Clipboard window contents.
Updated Runtime Execute Setup window with extra dialogs to prevent accidental overwriting of the Clipboard window contents.
Updated SQL Execute Setup window with extra dialogs to prevent accidental overwriting of the Clipboard window contents.
Updated .Net Execute Setup window with extra dialogs to prevent accidental overwriting of the Clipboard window contents.
Updated Snippet Setup window with extra dialogs to prevent accidental overwriting of the Clipboard window contents.

Database Tools Module

Fixed Note Fix Utility “Invalid length parameter passed to the LEFT or SUBSTRING function” error caused by Document Numbers of less than 3 characters.

See the SQL script below to identify if your system has this issue.

select CUSTNMBR, DOCNUMBR, DEX_ROW_ID from RM20101 where LEN(DOCNUMBR)&lt; 3
select CUSTNMBR, DOCNUMBR, DEX_ROW_ID from RM30101 where LEN(DOCNUMBR)&lt; 3
select VENDORID, VCHRNMBR, DEX_ROW_ID from PM20000 where LEN(VCHRNMBR)&lt; 3
select VENDORID, VCHRNMBR, DEX_ROW_ID from PM30200 where LEN(VCHRNMBR)&lt; 3
select DOCNUMBR, DEX_ROW_ID from IV30200 where LEN(DOCNUMBR)&lt; 3

Please download this new build and update your systems. You can just install over the top of the existing installation but must update all workstations and servers which have Dynamics GP installed at the same time.

Check out these articles and links: