Here is an awesome update to the previous sample customization which added 6 Additional Item Category Fields:

• #GPPT Adding 6 Additional Item Category Fields

This update makes the following improvements, but does need at least Build 32 of GP Power Tools to work:

1. Replacing the data storage location with GPPT Custom SQL Tables instead of the DUOS (Dynamic User Object Store) table, including providing a script to move any existing DUOS data to the new tables.
2. Updating the Report Writer functions with the faster memory-based parameters options.
3. Adding the 6 additional Item Category fields to the Item Class Setup window, including pulling the fields when a class is added and roll down class level changes.

The customization uses Modifier to add the additional fields to the Item Maintenance (IV_Item_Maintenance) window, the Inventory Control Setup (IV_Setup) window and the Item Class Setup (IV_Class_Maintenance) window. The Report Writer has also been used to add the additional category fields to the Item List By User Category report.

As usual, all the resources are gathered together into customization project using the Project Setup window.

The project contains triggers for handling the CRUD (Create, Read, Update & Delete) events for the Item Maintenance, Inventory Control Setup and Item Class Setup windows as well as triggers for the fields and lookup buttons. There are some Runtime Execute scripts used for shared code as well as custom Report Writer functions, SQL Execute scripts for querying the data and moving the Version 1 DUOS data into the Version 2 Custom SQL Tables.

After importing the project and adjusting security to provide access to the modified windows and report, you can go to the Inventory Control Setup window and define the additional six Item Category fields.

Note: If you have previously used Version 1 of this sample with data stored in the DUOS (Dynamic User Object Store) SY90000 table, please use the SQL Execute script IV_CAT2_SQL_MOVE and either remove or disable the old IV CATEGORY project.

Clicking on the Expansion button opens the Item Category Setup window where you can add category values, long descriptions and URL values.

Once the categories are defined, you can use them in the Item Maintenance window on the Options window.

With this new version you can also add the additional Item Category fields to the Item Class Setup window. The fields will also work with the defaulting from Item Class and rolling down changes from Item Class to items of that class.

If you want to display the Item Category fields in a report, you can create calculated fields and use IV_CAT_IV_SETP custom RW function to get the names for the Item Category, the IV_CAT_IV_MNT custom RW function to get the values for the Item Category fields for an item and the IV_CAT_IV_CLAS custom RW function to get the values for the Item Category fields for an item class. This RW function can return the Item Category value, as well as the long description and the URL, however due to the 80 character limitation on string calculated fields in the report writer, it will truncate the long description and URL fields to 80 characters.

If you use the IV_CAT_IV_MNTEX or IV_CAT_IV_CLASEX custom RW functions you can specify a line length (up to 80 characters) and a line number to parse the long description and URL fields into lines.

The Item List By User Category Report has been modified to add the additional Item Category fields to the report.

If you want to view all the Item Categories for a range of Items,  you use the IV_CAT2_SQL_TEST SQL Execute script.

Downloading and Installing

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

• GP Power Tools Settings Iv Category2.dbg.zip

WARNING: Installing the modified forms and reports will overwrite any existing changes to those forms or reports. Make sure you also change the Alternate Modified ID to use the modified windows and reports.

The code will be active on next login or after switching companies, or you can use start the triggers manually from the Project Setup window.

Note: If you have previously used Version 1 of this sample with data stored in the DUOS (Dynamic User Object Store) SY90000 table, please use the SQL Execute script IV_CAT2_SQL_MOVE and either remove or disable the old IV CATEGORY project.

[Edit] If you are using the Import CSV Data example below, please also update to the newer version of the code which can handle the use of the Custom Table instead of the DUOS table for importing data.

• #GPPT Importing CSV Data using GP Power Tools

More Information

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

David

14-Mar-2026: Updated Project to fix the SQL Execute script IV_CAT2_SQL_MOVE. It now will only move data that has not already been moved and only delete data that has been moved.
16-Mar-2026: Added note about removing or disabling the old IV CATEGORY project.
23-Mar-2026: Updated Item Import example project to allow use of Custom Table instead of DUOS table for additional Item Categories.

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