Advanced Field Settings - Add/Edit Field

 

Window Details

 

How Do I...

Navigation

 

Create or Maintain Advanced Field Settings

Overview

 

Validate a Standard Field Against a User-Defined Table

Fields

 

 

 

 

Related Topics

 

 

Advanced Field Settings

Customizing Advanced Field Settings

User-Defined Fields

Customizer FAQs

 

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 not available for work tables.

Overview

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.

Fields

 

Field

User

Field Description

Company

 

 

1. Attributes

 

Uppercase

Required

 

 

2. Validation

 

Default Value

Validation