We have customer who have thousands of records in a user defined table (UDT). If a record needs to be updated, they have to continuously load more records. This is a very time consuming task to update a record. If the users could have the ability to filter records, it would dramatically reduce the time to manage data in a UDT.
by: Justin R. | over a year ago | General Enhancements
Comments
In User-Defined Table Maintenance use the Select button that is on the right hand side of the screen. This will allow filtering the records that are displayed. The standard operands (All, Begins with, Ends with, Contains, etc.) used throughout Sage 100 for selection criteria can be applied to any or all of the columns defined in the UDT.
I would like to see a single record maintenance screen for UDTs. Why lock the whole table when you can just lock one record. Would be like every other maintenance -- enter or lookup the key. Would also allow add and delete of course.
Also would be nice if we could define multiple fields as the key field. Think of the item_warehouse table: item first then whse. Would need to be able to define the order in which the fields are concatenated to make the key.
This is really needs to be resolved; however, I am concerned 15 votes are not going to prompt action on this.