Posted on by WinthropDC GP Power Tools, Products

#GPPT GP Power Tools Build 29.5 hotfix released

David Meego - Click for blog homepageOver the last six months since GP Power Tools Build 29.4 was released, we have been making a concerted effort to get our customers updated onto supported versions of our products. In fact, only the last two builds numbers for each of our products can renew their subscriptions, and any older versions will stop functioning when they expire and cannot be renewed without updating to the current build.

While you are allowed to register the previous build numbers of our products, you will be missing out on over 2 years of development and all the new features and fixes your subscription entitles you to. You will also be subject to the Security Vulnerability discovered. For this reason, we are requesting that all customers ensure they are on the very latest code for their version of Dynamics GP.

Talking of very latest code, today we are releasing GP Power Tools Build 29.5 with lots of enhancements, some new features and a few fixes.

Highlights of build 29.5 include:

  • Enhancements and Fixes to the Resource Explorer windows, including Find and Find Next and Redisplay options, and better support for local fields.
  • Addition of a Table Usage feature to Resource Information and Resource Explorer to show which dictionary forms are using a particular table.
  • Additional Dex.ini settings for working with Integration Manager and maintaining use of the Legacy Print Dialog.
  • Fixes and enhancements to the Company Login Filter to warn if a new user will be denied access to a company when granting access at the Dynamics GP level.
  • Enhanced the automatic activity cleanup functionality to remove transaction level real-time posting and voiding sales batches.
  • Added 8 new Helper functions, including easy access to the GP Power Tools Mail API and functions to retrieve displayed data in a SQL Results window (which can then be emailed).
  • New SQL Goto Scripts which can be executed after a query has been executed and before the window is closed. These can use the new Sort column helper functions to add memory to the sort column used.
  • Updates to Database Validation to enhance account framework fixing for the GL_Account_MSTR table.
  • Database Validation can now recreate logins on a new server with same passwords as old server as long as the server’s name has not changed.
  • Numerous fixes throughout the product.

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

  • Microsoft Dynamics GP 2015 and GP 2015 R2 (v14.0)
  • Microsoft Dynamics GP 2016 and GP 2016 R2 (v16.0)
  • 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)

The build 29.5 hotfix includes the following changes:

  • Updated Resource Explorer Form Explorer window to show control types of local fields if the form containing the local fields is open.
  • Updated Resource Explorer Menu Explorer window to show control types of local fields if the form containing the local fields is open.
  • Added Redisplay function to the Options menu of all windows of the Resource Explorer.
  • Added Find and Find Next functions with settings to control behaviour to the Options menu of all windows of the Resource Explorer.
  • Added Table Usage Lookup window to Resource Explorer to show the dictionary forms and reports a table has been used on.
  • Added Table Usage Button to Resource Information window to open new Table Usage Lookup window and jump to selected form or report.
  • Updated Dex.ini Settings window to add Integration Manager debugging Dex.ini settings: ShowDynamics and DoUIRedraw to Other tab.
  • Updated Dex.ini Settings window to add Legacy Print Dialog registry setting for Windows 11 22H2 or later to Reports tab.
  • Updated Product Version Validation window to make the left hand pane smaller by default.
  • Updated ScreenShot System Status report to include the ODBC Data Source Server Name.
  • Updated Administrator Settings window to set default timeout for Report Writer Screen Output window to 15 minutes rather than 5 minutes.
  • Updated automatic activity cleanup script to remove empty transaction level realtime posting batch headers when the user is not logged in.
  • Added new Company Login Filter Check window which displays what Per User Settings could cause a user to be unable to log into a specific company.
  • Added button to open Company Login Filter Check window from the Company Login Filter window.
  • Added automatic opening of the Company Login Filter Check window when saving from Company Login Filter window, if settings are likely to lock current user out.
  • Added Additional menu to open the Company Login Filter Check window to the User Company Access window.
  • Added automatic opening of the Company Login Filter Check window when adding company access for a user, if there are settings likely to deny access to that user.
  • Fixed Resource Explorer Form Explorer window to show fields not visible in Visual Studio Tools such as Radio Buttons, ListViews and TreeViews.
  • Fixed Resource Explorer Menu Explorer window to show fields not visible in Visual Studio Tools such as Radio Buttons, ListViews and TreeViews.
  • Fixed Additional User Information window so that it recorded the created and last modified audit trail data.
  • Fixed previously applied fix for the Apply button on the User Display Preferences window as Microsoft have fixed the issue with clicking Apply twice in v18.4.
  • Fixed Administrator Settings window where changes to Additional User Information Settings were not getting saved.
  • Fixed Company Login Filter not working correctly when using per User Settings on first login when it works for switching companies. Needed to use User ID from window.
  • Updated Project Setup window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated Trigger Setup window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated Runtime Execute Setup window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated Runtime Executer window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated SQL Execute Setup window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated SQL Executer window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated .Net Execute Setup window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated .Net Executer window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated Parameter List Maintenance window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated Message Setup window to allow ID fields to expand with the window to make it easier to see long ID values.
  • Updated Trigger Setup window to handle when a trigger is loaded for product dictionary that is not currently loaded.
  • Updated Runtime Execute Setup window to handle when a script is loaded for product dictionary that is not currently loaded.
  • Updated Runtime Executer window to handle when a script is loaded for product dictionary that is not currently loaded.
  • Updated Trigger Setup window to automatically enable showing of the runtime engine when a trigger using the runtime is loaded.
  • Updated Runtime Execute Setup window to automatically enable showing of the runtime engine when a script using the runtime is loaded.
  • Added Goto Mode to SQL Execute Setup Window to add ability to run Goto scripts After Query displayed and Before Closing the window instead of from the Goto menu.
  • Updated SQL Execute Setup window to support new After Query and Before Close Goto Script Modes.
  • Updated SQL Executer window to support new After Query and Before Close Goto Script Modes.
  • Updated SQL Results window to support new After Query and Before Close Goto Script Modes.
  • Updated SQL Results 2 window to support new After Query and Before Close Goto Script Modes.
  • Updated Developer Tools maintenance windows to allow for SQL code longer than 32767 characters when checking if object is used by other objects in the system.
  • Added Copy To Trigger Setup option to the Copy Button on the Resource Information window to speed up creation of triggers based on selected resources.
  • Updated Trigger Setup window for Focus Triggers on global fields to not include the if empty() check if the field does not have a value (Push Buttons, ListViews, TreeViews).
  • Updated Trigger Setup window for Focus Triggers on local fields to not include the if empty() check for fields without a value if the form containing the local field is open.
  • Added check for Radio Button fields when selecting fields for Focus Triggers on the Trigger Setup window as triggers cannot be registered against Radio Button, use the Radio Group instead.
  • Updated Project Setup window so that it automatically saves when changing default project, if required fields have are entered.
  • Added Helper Function MBS_subtext to expose custom subtext() function to Developer Tools scripts, a version of substring() that works for text variables and fields.
  • Added RW_GetUserMasterAdditionalPrompts() Report Writer Function to retrieve User Defined Prompts for use with RW_GetUserMasterAdditionalData() Report Writer function.
  • Added MBS_UserAddInfo_Get Helper Function to retrieve data from the Additional User Information window’s table.
  • Added MBS_UserAddInfo_GetPrompt Helper Function to retrieve the prompts for the six user defined fields on the Additional User Information window.
  • Added MBS_UserAddInfo_Set Helper Function to write data to the Additional User Information window’s table.
  • Added MBS_SQL_Sort_Get Helper Function to get the current sort column and mode from a SQL Results data set.
  • Added MBS_SQL_Sort_Set Helper Function to set the current sort column and mode for a SQL Results data set.
  • Added MBS_SQL_Export_Data Helper Function to Export all rows or selected rows from a SQL Results data set to Tab Delimited, Comma Delimited or HTML table text field.
  • Updated Helper Functions window to add support for new MBS_subtext Helper Function.
  • Updated Helper Functions window to add support for existing MBS_Email_API Helper Function to make it easy to find and use from Dexterity, C# and VB.Net scripts.
  • Updated Helper Functions window to add support for new MBS_UserAddInfo_Get Helper Function.
  • Updated Helper Functions window to add support for new MBS_UserAddInfo_GetPrompt Helper Function.
  • Updated Helper Functions window to add support for new MBS_UserAddInfo_Set Helper Function.
  • Updated Helper Functions window to add support for new MBS_SQL_Sort_Get Helper Function.
  • Updated Helper Functions window to add support for new MBS_SQL_Sort_Set Helper Function.
  • Updated Helper Functions window to add support for new MBS_SQL_Export_Data Helper Function.
  • Fixed Reject Script not working for Focus Triggers before original when Modified was marked. This situation is not actually required as Modified should not be marked for an original resource.
  • Fixed Helper Function window so that when it automatically inserts parameter lists, it only includes active parameters.
  • Fixed MBS_Arguments_Set_Value Helper Function where setting a text field which caused it to increase in length from less than 255 characters (string) to more than 255 characters (text).
  • Fixed Project Setup window so that Open Form and Reports button correctly opened the form or report of the selected trigger or resources and not the form specified on the project header.
  • Fixed error when exporting objects with large scripts. Now scripts of maximum length of 32,000 characters can still export to XML successfully.
  • Fixed MBS_SQL_Lookup Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries.
  • Fixed MBS_SQL_Lookup_Parameter Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries.
  • Fixed MBS_Return_By_Field Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries.
  • Fixed MBS_Return_By_Reference Helper function to add workaround for issue with Dexterity return to functionality not working across 3rd party dictionaries.
  • Updated Database Validation to show Account Number Length information on the Fix Account Framework window.
  • Updated Database Validation to show actual used characters for each segment in the account framework of each company on the Fix Account Framework window.
  • Updated Database Validation to add an Edit Account Framework window to the Fix Account Framework window, this can be used to change the system Account Framework settings.
  • Fixed Database Validation to recreate the Dexterity Auto Stored Procedures, re-grant access and re-bind defaults when a table has failed to convert.
  • Fixed Database Validation to handle updating the structure of the GL_Account_MSTR (GL00100) table which needs special handling as it is a filtered table.
  • Fixed Database Validation to drop and recreate additional Auto Stored Procedures relating to filtered tables such as the GL_Account_MSTR (GL00100) table.
  • Added dialog to recommend running the Database Maintenance Utility (DBMaintenance.exe) after the GL_Account_MSTR table has been updated.
  • Fixed Database Validation to ensure that Minimum Segment size is at least 1 character when editing the Account Framework.
  • Added feature to Database Validation Options Menu to create a Password Hash File containing the password hashes from the old server so they can be restored on a new server.
  • Added new option to the Database Validation Fix Users window to load a previously created Password Hash File to so that passwords from the old server can be restored to a new server.

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

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.