Open topic with navigation

Select Custom Office Main menu > User-Defined Field and Table Maintenance. Select the table to edit advanced field settings for, and then click the Advanced Field Settings button. In the Advanced Field Settings window, click the Add button or the Edit button.

This task is available only for tables in modules other than Job Cost, Material Requirements Planning, Payroll, TimeCard, and Work Order. This task is not available for work tables.

Use Advanced Field Settings - Add/Edit Field to create or edit advanced settings for a standard Sage 100 field, including the uppercase attribute, required attribute, and validation criteria. When setting entry validation, you can define a list of acceptable values, specify a default value, or validate the field against a user-defined table (UDT). You can create multiple settings for a field. Advanced field settings can be defined by user and company, allowing you to create settings for all users, all companies, specific users and/or specific companies.

For user-defined fields (UDFs), this window allows you to define advanced settings only for individual users and/or companies. You can define UDF settings for all users and all companies in User-Defined Fields.

You can edit advanced settings for all fields except primary key fields and read-only fields. In addition, some Sage 100 fields are shipped with pre-defined default settings, default field entry values, and/or existing validations against another table that cannot be modified. A lock button appearing next to a field indicates that the setting cannot be modified based on the restrictions of the field, user, or company selected. Clicking this button allows you to view information about the restrictions for that field attribute.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks