Advanced Field Settings - Add/Edit Field Home | FAQs & Troubleshooting

 

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