Posted on by WinthropDC GP Power Tools, Products

#GPPT GP Power Tools Build 30.2 hotfix released

David Meego - Click for blog homepageToday we are pleased to announce the release of GP Power Tools Build 30.2. It has been about six months since GP Power Tools Build 30.1 was released and we have been working on consolidating all the features and functionality of that build as well as fixing some minor bugs.

We have also been encouraging our customers to get updated onto the latest builds of our products for their versions 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 in August 2022.

The release of GP Power Tools Build 30.2 includes lots of enhancements to existing functionality, some new features and a few fixes.

Highlights of build 30.2 include:

  • Replacement of the User Messages dialogs with new Automatic Logout “friendly” dialogs.
  • Fixed Automatic Logout to stop detecting custom background timed processes as activity.
  • Added a SQL Server Version check to watch for old unsupported versions.
  • Improved handling of Scripts and Triggers when the Project they belong to is marked as disabled.
  • Updated all the Developer Tools windows with a Project “soft limit” on the browse buttons when sorting by Project ID.
  • Fixed the Note Fix Utility Fields and Tables windows to allow manual editing to work better and added default business rules for additional ISV products using the Note Index field.
  • Added a Mass Delete button to the Note Fix Utility to remove old Used Duplicate or Orphaned notes by date.
  • Miscellaneous fixes throughout the product.

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

  • Microsoft Dynamics GP 2018 and GP 2018 R2 (v18.0)
  • 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)

The build 30.2 hotfix includes the following changes in detail:

System Module and Installation

  • Updated copyright notices for the year 2024.
  • Fixed installer complaining about DPM.EXE when Dell Peripheral Manager is installed and running.
  • Added MBS_Debug_HideGames Dex.ini seting to allow free games to be hidden from Microsoft Dynamics GP >> Tools >> Customize menu.
  • Updated the fix for Activity_GetBackgroundStatus() so that it can automatically restart the Update_Date Timed process from Professional Services Tools Library (if installed).
  • [Edit] Updated startup code to avoid additional ** End of Log ** being logged when Visual Studio Integration Toolkit menus are being used.

Administrator Tools Module

  • Updated Administrator Settings window to ask if you wish to clear the Security Activity Tracking Log files if the options are disabled and the logs contain data.
  • Updated Administrator Settings window to ask if you wish to clear the User Activity Tracking Log files if the options are disabled and the logs contain data.
  • Added SQL Server Version Check on Login looking for old SQL Server Versions below the system requirements.
  • Updated SQL Server Version Check minimum supported versions based on information from support team and system requirements.
  • Added option to disable SQL Server Version Check to the Administrator Settings window.
  • Added User Message Replacement system to replace User Message System Dialogs with Modal Dialogs so that a User Message does not stop Automatic Logout.
  • Added MBS_Debug_UserMessageReplace Dex.ini setting to allow disabling of the replacement of User Message System Dialogs with Modal Dialogs.
  • Updated Automatic Logout to avoid Timed Triggers or Scheduled Triggers reseting the last activity date and time and preventing Automatic Logout.
  • Updated Automatic Logout to take reserved users into account when checking if the available user count timeout setting should be used.
  • Fixed Login Limits not allowing a user to log back in after an abnormal exit which left an activity record, when the maximum users is reduced by reserved users.
  • Updated Login Limits to correctly handle maximum allowed users when reserved users are specified and the reserved user is already logged in.
  • Fixed Launch File Configuration to stop it writing log entries about launch file changes unless the changes are actually being applied.

Developer Tools Module

  • Fixed Project Setup Status line to show Total first and include Snippets in the counts.
  • Updated Project Setup window to force refresh the cache of Runtime Execute Scripts for the project when Project Disabled checkbox changed.
  • Updated Project Setup window to stop any triggers running for the project when the Project Disabled checkbox is selected.
  • Updated Project Setup window to not ask about starting project triggers when the Project Disabled checkbox is selected.
  • Updated Trigger Setup window so that default trigger Script for FORM POST events do not include a check that the form is open as it is closing.
  • Updated Trigger Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning.
  • Updated Trigger Setup window with warnings about using Focus Event with Table Trigger Type as it can be less reliable than using Focus Event and Helper Functions.
  • Updated Trigger Setup window to recommend against using Focus Event with Table Trigger Type with Scroll Fill Trigger Events as newer method with Focus Event Trigger Type is better.
  • Updated Automatic Trigger Mode to speed up starting Triggers on login by excluding triggers in disabled projects earlier in the trigger starting process.
  • Fixed Focus Change Trigger on Modifier added Button fields reporting a trigger error for the PRE trigger when Minimize Logs is checked.
  • Fixed Timed Trigger Handling to remove trigger from Trigger Status list if background timed process removed via the Process Monitor.
  • Fixed Scheduled Trigger Handling to remove trigger from Trigger Status list if background timed process removed via the Process Monitor.
  • Updated Trigger Handling for Focus Event Trigger Type with Scroll Fill Trigger Event to also copy field from the specified table to the original window when Modified script being executed.
  • Updated Runtime Execute Setup window to add Script Purpose into the available sort orders for the browse buttons.
  • Updated Runtime Execute Lookup window to add Script Purpose into the available sort orders and display Script Purpose on the window.
  • Updated Runtime Execute Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning.
  • Updated Runtime Execute Setup Custom Script Purpose Handlers to be disabled if the script is disabled or the script’s project is disabled.
  • Updated Runtime Execute Setup window to not ask about starting project triggers when the Project Disabled checkbox is selected.
  • Updated SQL Execute Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning.
  • Updated .Net Execute Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning.
  • Updated .Net Execute Setup window to not ask about starting project triggers when the Project Disabled checkbox is selected.
  • Fixed Snippet Setup window so that Sort By drop down list was set correctly when opening the window from the Project Setup window.
  • Updated Snippet Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning.
  • Updated Parameter List Maintenance Window to add a soft limit when using the browse buttons to avoid changing projects without warning.
  • Updated Messages Setup Window to add a soft limit when using the browse buttons to avoid changing projects without warning.
  • Fixed Visual Studio Integration Toolkit Unregister Menu error being logged when the error code was zero meaning no error.
  • [Edit] Fixed timing issue with Visual Studio Integration Toolkit menus failing to register on startup. No need to move VSIT above GPPT in Dynamics.set launch file.
  • [Edit] Fixed timing issue with Visual Studio Integration Toolkit menus failing to register on startup. No need to move GPPT above VSIT in Dynamics.set launch file. Finally fixed in Build 30.2 with Last Modified: 19-Feb-2024.

Database Tools Module

  • Fixed Note Fix Utility so it can work with older SQL Server Versions that don’t understand “drop table if exists” syntax.
  • Updated Note Fix Utility to exclude Collections Management Tables from scanning as they used their own Notes System.
  • Updated Note Fix Utility to exclude Enhanced Notes Tables from scanning as they intentionally have duplicated Note Index values.
  • Fixed Note Fix Utility Exclude Tables window to allow manual entry of table exclusions to be entered successfully.
  • Updated Note Fix Utility Exclude Tables window to allow entry of SQL only Tables and Fields to be excluded from the Note Fix Utility.
  • Added Delete Row button to Scrolling window on the Note Fix Utility Fields window.
  • Added Delete Row button to Scrolling window on the Note Fix Utility Exclude Tables window.
  • Added Mass Delete button and window to remove old Used Duplicate or Orphaned Note Records by date rather than manually identify where they belong.
  • [Edit] Fixed Note Fix Utility to only use Data Compression on Enterprise or Azure SQL Server versions.
  • [Edit] Fixed Note Fix Utility case sensitivity issues on Binary SQL Server Instances.
  • [Edit] Updated Note Fix Utility with additional case sensitivity fixes and fixed a duplicate error when changing checkbox while background processing is running.
  • [Edit] Added Background Processing not available message to Note Fix Utility when Processing or Fixing Notes.
  • [Edit] Fixed Database Validation SQL Error when opening the Fix Users window.

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:

Enjoy

David

19-Feb-2024: Added notes about extra fixes in the 16-Feb-2024 and 19-Feb-2024 build 30.2 releases.

This article was originally posted on http://www.winthropdc.com/blog.

Please post feedback or comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.