Posted on by WinthropDC GP Power Tools, Products

#GPPT GP Power Tools Build 30.3 hotfix released

David Meego - Click for blog homepageToday, we are announcing the release of GP Power Tools Build 30.3. Over the last couple of months, a few issues have been discovered, which have now been fixed. We have also enhanced the functionality of a number of features in the product.

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 and fixed in August 2022.

The release of GP Power Tools Build 30.3 includes a variety of fixed and enhancements throughout the product.

Highlights of build 30.3 include:

  • Fixed of issues discovered with the Note Fix Utility on systems with additional non-Dynamics GP tables or backup tables in their databases.
  • Added checks into Database Validation and Note Fix Utility for tables where DEX_ROW_ID column is not marked as an Identity column.
  • Fixed issue with Focus Field Change Triggers on Modifier Added fields where trigger script was executed when the field gains focus.
  • Fixed issue where SQL Lookups and Form Lookups could execute the change script of the return field twice.
  • Added Support for Message ID Prompts and Helper Functions for accessing Dexterity Dialogs (mainly for C# and VB.Net as Dexterity can access them natively).
  • Miscellaneous fixes throughout the product.

Build 30.3 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.3 hotfix includes the following changes in detail:

System Module

  • Fixed Dexterity Login dialog showing when logging on startup has been enabled with the MBS_Debug_LogOnStartup Dex.ini setting.

Administrator Tools Module

  • Fixed Resource Information when using the Copy Button > To Trigger Setup in Procedure and Function mode to not change when the Trigger Event includes parameters.

Developer Tools Module

  • Fixed Secondary trigger for Field Change Events on Modifier Added fields firing the trigger script delayed when the field gains focus.
  • Fixed SQL Lookup where it could execute the returned field’s change script twice under certain circumstances.
  • Fixed Form Lookup where it could execute the returned field’s change script twice under certain circumstances.
  • Fixed MBS_Return where it could execute the returned field’s change script twice under certain circumstances.
  • Added MBS_SQL_Lookup2, MBS_SQL_Lookup_Parameter2 Helper Functions which use Set Field and Run Script instead of Return Data mode, for when Return mode fails.
  • Added MBS_Form_Lookup2, MBS_Form_Lookup_Parameter2 Helper Functions which use Set Field and Run Script instead of Return Data mode, for when Return mode fails.
  • Added MBS_Return_By_Field2, MBS_Return_By_Reference2 Helper Functions which use Set Field and Run Script instead of Return Data mode, for when Return mode fails.
  • Updated Messages Setup window to allow three warning prompts to be associated with each message for using with the ask() dialog or MBS_Ask and MBS_Ask_Text Helper Functions.
  • Added MBS_Get_Message_Prompts Helper Function to return the warning and warning prompts stored against a Message ID.
  • Added MBS_Show_Dialog and MBS_Show_Dialog_Text Helper Functions to provide easy access to Dexterity system dialogs for .Net Execute scripts.
  • Added MBS_Ask_Dialog and MBS_Ask_Dialog_Text Helper Functions to provide easy access to the Dexterity ask() dialog for .Net Execute scripts.
  • Updated Helper Functions window to allow Return Mode selection for SQL Lookup, Form Lookup and MBS_Return when Return Data mode fails across dictionaries.
  • Updated Helper Functions window to allow inclusion of prompts when using Helper Functions to get the warning from a Message ID.
  • Updated Helper Functions window to support MBS_Show_Dialog, MBS_Show_Dialog_Text, MBS_Ask_Dialog and MBS_Ask_Dialog_Text Helper Functions.

Database Tools Module

  • Updated Database Validation to flag the DEX_ROW_ID column in a table from a Dexterity product dictionary if it is not marked as an identity column.
  • Updated Database Validation to add Mark All and Unmark All buttons to the Database selection pane on the main window.
  • Added warning to Database Validation when selecting more than 3 company Databases that processing and validation can take a long time.
  • Updated Note Fix Utility to exclude database tables that are not from a Dexterity product dictionary, this will avoid it processing backup tables.
  • Updated Note Fix Utility to exclude tables where the DEX_ROW_ID column exists in the table but is not marked as an identity column, fixes duplicate errors.
  • Updated Note Fix Utility to warn if a table from a Dexterity product dictionary has a DEX_ROW_ID column that is not marked as an identity column.

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.