Everyone wants extra user defined fields on their Microsoft Dynamics GP windows. In the previous articles we showed how easy it is to add and modify 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

Now we have a yet another problem …. “Boss Level Scope Creep”….

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.

Changed Requirements Again

The Boss has seen how easy adding fields is and now wants to add extra information about an employee’s First Aid Certificate status AND also wants to track the last date and time the Employee Maintenance window was saved.

Implementation Updates Again

Project Setup

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

1. Project Description: Add word “Again”.
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_FIELDS2 project.

Custom Table Setup

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

1. Table Description: Add word “Again”.
2. Technical Name: Change number “2” to “3”
3. Physical Name: Change number “2” to “3” and respond “Create New” to the dialog. This will create a new table, so that the original table is not renamed.
4. Add Custom SQL Fields; First Aid Completed as a Boolean, First Aid Trainer as String 30, First Aid Renewal as a Date, and Last Saved as Datetime.
   
5. Click Save and acknowledge the warning that this table is used by Custom Fields, then closed the window.

Custom Field Setup

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

1. Field Description: Add word “Again”. You will notice that the extra fields from the table had been added but need to be enabled.
   
2. Click on two of the Spaces and delete them.
3. Move one of the remaining Spaces to above Pet Types.
4. Move the other remaining Spaces to above Last Saved.
5. Double click on Pet Types and select the Second Column checkbox, enter an Optional Width of +3G (to widen the field so the right edge lines up) and click OK.
6. Click the + sign and add a Heading. Enter the Heading: First Aid Certificate and click OK.
7. Move the Heading to above First Aid Completed.
8. Double click on First Aid Completed, select Use Automatic Field Types, Use Field Type: Checkbox and click OK.
9. Double click on First Aid Trainer, select Use Automatic Field Types, Use Field Type: String and Length 30 and click OK. You could also use a List with Result String and the Expansion Button to add a list of First Aid training providers rather than having free entry text.
10. Double click on First Aid Renewal, select Use Automatic Field Types, Use Field Type: Date with no Result selected and click OK.
11. Double click on Last Saved, select Use Automatic Field Types, Use Field Type: Datetime with Result as Save as Server and click OK. If your system is multinational, you can use Save as UTC for Coordinated Universal Time.
    
12. Click Save and close the window.

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

Newer Solution

You will see that the fields have been laid out with spaces and Headings and the Multi-Select List Box still uses the extra space available in the second column.

Stay tuned for the final article where we get the custom fields displayed on the Employee Inquiry window.

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_fields3.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 (published 24-Apr-2026)
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 2 (publishing 27-Apr-2026)
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 3 (publishing 29-Apr-2026)
• #GPPT Adding Custom Fields to Microsoft Dynamics GP without using Code or Modifier part 4 (publishing 01-May-2026)

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

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 http://www.winthropdc.com/blog.