Created on 04-06-2017 | Last modified on 11-17-2020


How to Delete existing data in a Custom Office User Defined Table (UDT) usingUser DefinedField and Table Maintenance, in Sage 100.

If bad data was accidentally added to a User Defined Table via entry or import, how do you delete the bad data manually?



Backup Warning

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.


To delete key field information from the UDT (Used Defined Table), select a row using Maintain UDF Data in User Defined Field and Table Maintenance, and select the  Delete Row button/icon.

You may select Show More to display additional records and the Select button to filter the data to specific records to be modified.

From Sage 100 help:

  1. Select Custom Office, Main, User-Defined Field and Table Maintenance
  2. Select the module and UDT to maintain
  3. Click the Maintain UDT Data button on the right
  4. In the User-Defined Table Maintenance window, only the first 100 records in the table are displayed in the grid. To display an additional 100 records, click the Show More button. To select specific records to display, perform the following steps:
    • Click the Select button.
    • In the Selection window, enter a selection of records to display in the User-Defined Table Maintenance window. Click Reset to clear the search criteria entered
    • Click OK
    • The User-Defined Table Maintenance window displays the first 100 records that match the search criteria entered. To display an additional 100 records that match the search criteria, click the Show More button. To refine your selection or enter a new selection, click the Select button
    • Data that has been entered in the key field cannot be modified. To change the key field data, you must delete the row by selecting it and clicking the Delete Row button. Then reenter the correct data.