GP 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.
In Microsoft Dynamics GP, the Standard Cost and Current Cost fields are shown on the Item Maintenance window. Some businesses like to control which users can view the item costs and want them hidden entirely or unreadable unless being edited.
The business requirement to hide the fields is very simple, but we also have the option to mask them. Masking the fields makes them unreadable until the field has focus. This can prevent the fields from being read over a user’s shoulder while the window is open.
These requirements can be created with the Form Control module in a few minutes.
Masking the Item Cost fields
The FORM CONTROL ITEM COST Form Control ID is limited by the Base Settings Resource Filter to exactly the IV_Item_Maintenance form in the core dictionary (0).
The Mask Field Value rule is limited to fields ending with Cost. No other settings are required. The masking makes the fields black.
Adding a Password
Adding a Password Field Before rule to the same item cost fields will prevent access to the fields unless the associated password is known. This will prevent the masking from being removed unless the user enters the password required for access.
The only setting needed is the Password ID field which will define the password, and the messages used on the dialogs.
The Password Setup window allows for messages in different languages to be entered on a multi-lingual Microsoft Dynamics GP system.
Hiding the Item Cost fields
If you want, you can hide the fields instead of masking them (and adding an optional password).
The Hide Field rule is limited to fields ending with Cost. No other settings are required. The fields will then be hidden from the window.
Downloading and Installing
Download the example settings, import using the Project Setup window (without any project showing, select the path to the xml file and click Import):
The Form Controls will be active immediately when the affected windows are next opened.
More Information
For an introduction series for Form Control with step-by-step instructions see:
For more information see:
- GP Power Tools Portal: http://winthropdc.com/GPPT
- GP Power Tools Samples: http://winthropdc.com/GPPT/Samples
- GP Power Tools Videos: http://winthropdc.com/GPPT/Videos
Hope you find this example useful.
David
This article was originally posted on http://www.winthropdc.com/blog.