Solution Properties
Solution ID:
224924750069424
Last Modified Date:
Thu Aug 06 00:30:34 UTC 2026
Taxonomy Path:
Category//Data//Data management
Author:
legacyauthor
Create and Maintain User-Defined Tables in Custom Office
Description
Cause
Resolution

Before you begin

[BCB:503:3rd party, customizations, etc:ECB]  

NOTE:

This process involves customization. The Custom Office module requires experience and familiarity with customization tools. Sage 100 Customer Support doesn't assist with creating customizations and can't resolve every issue that results from customizations or custom scripts. If issues occur, you'll need to remove the customization and recreate it. You can also obtain assistance from your Sage business partner or a qualified consultant. Training is available through Sage University at www.sageu.com.

 

About user-defined tables

Use Customizer to create User-Defined Tables (UDTs). UDTs store custom information for Sage 100 modules. You can also use them to expand validation lists and dropdown lists used by User-Defined Fields (UDFs).

Create a user-defined table

  1. Open Custom Office, Main, User-Defined Field and Table Maintenance.
  2. Add a user-defined table using one of these methods:
    • Right-click a module folder, such as Accounts Payable or Sales Order, and select Add a User-Defined Table.
    • Select a module folder and click Add a User-Defined Table.
  3. In Table Name, enter a short, unique table name.
    • Sage 100 automatically adds the prefix XX_UDT_.
    • Example: Entering Test creates AP_UDT_TEST.
  4. In Description, enter a description for the table.
  5. Enter the key field information:
    • Key Field Name
    • Key Field Description
    • Key Field Length
  6. Click OK.
  7. In the User-Defined Fields window, add any additional UDFs.
    • Note: See the related solution below for UDF creation instructions.
  8. Click OK in the User-Defined Fields window.
  9. Click OK when Sage 100 prompts you to update the data dictionary and UDF data files.
  10. Click Close to exit User-Defined Field and Table Maintenance.

Maintain user-defined table data

  1. Open Custom Office, Main, User-Defined Field and Table Maintenance.
  2. Expand the module folder that contains the UDT.
  3. Right-click the UDT.
  4. Select Maintain UDT Data.
  5. Enter or update the key field value and any additional column values.
  6. Add multiple rows as needed.
  7. Click Accept to save the data.
  8. Click Close to exit User-Defined Field and Table Maintenance.
Steps to duplicate
Related Solutions