#GPPT Ensuring GL Accounts are entered on Purchase Orders

David Meego - Click for blog homepageA recent GP Power Tools customization project for Microsoft Dynamics GP which I assisted a customer to create, ensures that a GL Account Number is entered on each line of a Purchase Order Transaction.

The customer for which this project created for has allowed it to be published on the blog to benefit anyone else who would like similar functionality.

Continue reading

#GPPT Hiding Windows During Automations

David Meego - Click for blog homepageUsing the GP Power Tools – Developer Tools module for customization is a great method of automating processes in Microsoft Dynamics GP as well as customizing behavior to meet the requirements of your business.

Many customers are also using GP Power Tools to replace Visual Basic for Applications now that it is “End of Life” and unsupported.

I was recently asked how to hide a window opened and closed as part of an automation using GP Power Tools. This article explains the techniques you can use to open a window as hidden.

Continue reading

#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

#GPPT GP Power Tools Build 31.4 hotfix released

David Meego - Click for blog homepageBuild 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.

Continue reading

#GPPT Enhancing the Apply Sales Documents Window with Virtual Fields

David Meego - Click for blog homepageThis example adds filtering on an amount and/or a document number to the Apply Sales Document window when the Find window is used. as well as sorting the documents by date. The additional functionality can make it much quicker to find the correct document for a payment to be applied to, by its amount or by any part of its document number.

This customization also demonstrates some very useful techniques including:

  • using Virtual Fields instead of Modifier to add the extra fields we need,
  • using Triggers to capture a table reference to a temporary table,
  • applying a where clause to that temporary table,
  • using a where clause that involves more than one table,
  • adding virtual keys to the temporary table,
  • and manipulating the contents of the temporary table.

Continue reading

#GPPT Form Control Adding a Customer Status Virtual Field everywhere in GP

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding (or with some additional scripts).

Here is an example showing how you can quickly use Form Control to add a Virtual Field to display the Customer Status to every window in the entire Microsoft Dynamics GP application where a Customer ID is displayed, without needing Modified or Alternate windows.

Continue reading

#GPPT Adding Virtual Fields to Item Maintenance

David Meego - Click for blog homepageGP Power Tools Build 31 added Virtual Fields as a feature to the Developer Tools module. Virtual Fields allow additional fields to be added to windows without needing Modified or Alternate windows.

Virtual Fields are implemented using a series of Helper Functions which allow windows to be expanded, Virtual Fields to be added and then triggers and scripts applied to use the new fields.

Continue reading

#GPPT Form Control Conditional Control of Window Fields

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding (or with a small conditional script).

Here is an example showing how you can quickly use Form Control to conditionally control the User Defined fields on the Account Maintenance window.

Continue reading

#GPPT Form Control Setting Default Values when a Window opens

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to set default values on a window when it opens.

Continue reading

#GPPT Form Control Adding Autocomplete, Formatting and Validation to Fields

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to add formatting, validation and even Autocomplete to a field to ensure it is entered from a list of desired values.

Continue reading

#GPPT Form Control Changing Window Titles and Field Captions

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to change the window titles and field captions.

Continue reading

Updated Product Introduction Videos and Form Control Video

David Meego - Click for blog homepageWinthrop Development Consultants is a proud member of the Microsoft Dynamics GP community and we continue to invest in the community we love by being a sponsor at three upcoming conferences, the first starting in a week’s time:

  • Sponsor for the Microsoft Dynamics GP focused GPUC 24 conference (18th to 22nd November 2024) in Fargo, ND, USA in-person and virtually, hosted by Implementation Specialists.

In preparation for these conferences, we have used the great video creation tool, Renderforest, to update our product introduction videos for our latest builds and create a video for the amazing new GP Power ToolsForm Control module.

Continue reading

#GPPT Form Control Adding “Save and Continue” to Sales Transaction Entry

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to add menus with shortcut keys to run any script on a window (usually a button).

Continue reading

#GPPT GP Power Tools Build 31.3 hotfix released

David Meego - Click for blog homepageBuild 31.3 of GP Power Tools was released on 01-Oct-2024. This build consolidates the fixes and enhancements made to the product since Build 31 was released, including compatibility with Microsoft Dynamics GP version 18.7.

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.

Continue reading

#MSDynGP Microsoft Dynamics GP 18.7 – October 2024 has released

David Meego - Click for blog homepageThe latest and greatest version of Microsoft Dynamics GP has been released, and it contains many new features and bug fixes.

Winthrop Development Consultants has already updated its products for this Microsoft Dynamics GP 18.7 – October 2024 release. They are now built against the final build and so are no longer beta builds.

Check out the previous article for more information:

Continue reading

#GPPT Form Control Masking or Hiding Item Costs on Item Maintenance

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to mask or hide the Item Cost fields on the Item Maintenance window. A masked field is unreadable unless it has the keyboard focus.

Continue reading

#GPPT Form Control Automatically Set Posting Type on Account Maintenance

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding (or with a small conditional script).

Here is a real-life example showing how you can quickly use Form Control to automatically set the Posting Type to the correct value when the Account Number is entered on the Account Maintenance window.

Continue reading

#GPPT Form Control Prevent changing of Journal Entry Numbers

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to prevent users changing the Journal Entry number on the General Ledger Transaction Entry window.

Continue reading

#GPPT Form Control Preventing Shipment/Invoices on Receivings Transaction Entry

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to prevent entering Shipment/Invoices on the Receivings Transaction Entry window.

Continue reading

#GPPT Form Control Working with Phone and Fax Numbers including Conditional Formats

David Meego - Click for blog homepageGP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding (or with a small conditional script).

Here is a real-life example showing how you can quickly use Form Control to control phone and fax numbers in Microsoft Dynamics GP throughout the whole product.

Continue reading