Everyone wants extra user defined fields on their Microsoft Dynamics GP windows. In the previous articles we showed how easy it is to add, modify and format the layout of extra fields using GP Power Tools with the new Custom Fields feature.

• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 1
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 2
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 3

Now we have one final request…. The HR Team want to have the custom fields displayed on the Employee Inquiry window.

Custom Fields combines the Custom Tables functionality (added in Build 32) and the Virtual Fields functionality (added in Build 31) and provides a simple configuration to add any field from a Custom Table, onto any window, in any product dictionary of Microsoft Dynamics GP, without needing any scripting, or any changes to the window with Modifier.

Final Requirement

The HR Team would also like to see the custom fields added to the Employee Maintenance window on the Employee Inquiry window as read only fields.

Final Implementation

Project Setup

To avoid changing the projects from the previous articles, it has been duplicated from EMP_CUSTOM_FIELDS3 into a new EMP_CUSTOM_FIELDS4 project, the Custom Table and Custom Field resources were automatically renamed to match. Also make the following changes:

1. Project Description: Replace the word “Again” with “Final”.
2. Make this project the Current Project.

NOTE: This duplication step is only necessary if you want to keep the previous iterations of the project. Don’t forget to disable the EMP_CUSTOM_FIELDS3 project.

Custom Table Setup

On the EMP_CUSTOM_FIELDS4 custom table the following changes have been made:

1. Table Description: Replace the word “Again” with “Final”.
2. The Technical Name: Change number “3” to “4”
3. Physical Name: Change number “3” to “4” and respond “Create New” to the dialog. This will create a new table, so that the original table is not renamed.
   
4. Click Save and acknowledge the warning that this table is used by Custom Fields, then close the window.

Custom Field Setup

On the EMP_CUSTOM_FIELDS4 custom field the following changes have been made:

1. Field Description: Replace the word “Again” with “Final”.
   
2. Click Duplicate Button and select Duplicate Custom Field and enter EMP_CUSTOM_FIELDS4_INQ for the new name.
3. Change the Field Description: Employee Inquiry Custom Fields Extended Final.
4. Use the Menu Explorer and change the Form Name to Employee Inquiry (UPR_Inquiry_Employee). The Window will populate automatically and the Read Only checkbox will be selected automatically.
   
5. Now click on the Form Name hyperlinked prompt on the Custom Fields Setup window to save and open the Employee Inquiry window.

The Fields have been added as read only, but the prompt spacing is a little small. This is because the prompt for Employee ID (the first editable field) is short. A quick edit of the Custom Fields Setup window to add an optional Horizontal Position shift of +3G (grids) will help.

Now click on the Form Name hyperlinked prompt on the Custom Fields Setup window to save and open the Employee Inquiry window.

Final Solution

You will now see that custom fields are displayed with better spacing on the Employee Inquiry window.

This concludes the introduction series for Custom Fields. As you can see, the options are endless and limited only by your imagination and we used no code and no Modifier.

Downloading and Installing

Download the example code, import using the Project Setup window (requires at least build 33 as it uses Custom SQL Tables and Custom Fields):

• GP Power Tools Settings Emp_custom_fields4.dbg.zip

The custom fields will be active immediately.

More Information

Here are all the parts of the series (available once published):

• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 1
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 2
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 3
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 4
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 5 (publishing 04-May-2026)

For more information see:

• GP Power Tools Portal: https://winthropdc.com/GPPT
• GP Power Tools Samples: https://winthropdc.com/GPPT/Samples
• GP Power Tools Videos: https://winthropdc.com/GPPT/Videos

If you are interested getting early access to the Custom Fields functionality and Build 33 of GP Power Tools, please contact us. As always, your feedback will help improve the product and its features.

To stay informed for more details and release notices, please subscribe to this blog and our Newsletter mailing list.

Tell us in the comments how you would use this great new feature.

Thanks

David

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