Fields and controls
Allow Blank
Select this option to allow the field to be left blank.
- This option appears only if you select Text or Date in the Type field, and you select the Validate option.
- After you click Save to create a field, you can no longer change the Allow Blank option for the field.
- If you do not allow blank entries for a field, you must specify at least one value in the detail table.
Decimals
Specify the number of digits (from 0 to 9) that appear after the decimal point for values entered in the field.
Note: After you click Save to create a field, you can no longer change the decimals number for the field.
Optional Field Description
Enter a description for the field.
Length
Enter the maximum number of characters that can be entered in the field (up to 60 characters).
- The Length field appears only if you select Text in the Type field.
- After you click Save to create a field, you can no longer change the field length.
Optional Field
Specify a code for the field.
Type
Specify the type of information to be entered in the field:
- Text. Allows entry of textual (alphabetic) characters with a maximum length specified in the Length field.
- Amount. Allows entry of numeric values to 3 decimal places.
- Number. Allows entry of numeric values to a number of decimal places specified in the Decimals field (from 0 to 9).
- Integer. Allows entry of numeric values up to 2,147,483,647.
- Yes/No. Allows entry of Yes or No.
- Date. Allows entry of a date in month/day/year format.
- Time. Allows entry of a time in hour/minute/second format.
Note: After you click Save to create a field, you can no longer change the field type.
Validate
If you select this option, the only values that can be entered in the field are those specified in the detail table. (If you do not select this option, any value can be entered in the field, as long as it is consistent with the field type.)
- For a Text or Date field, you can also select the Allow Blank option to allow the field to be left blank.
-
You cannot change the Validate option after you do one of the following:
- Click Save to create the field.
- Enter a value in the detail table.
- The Validate option does not appear if you select Yes/No in the Type field.
Detail Table
Description
Enter a description for the value.
Value
Enter a value that is consistent with the type of field:
- Text. Enter a text value that does not exceed the number of characters specified in the Length field.
- Amount. Enter a numeric value with up to three characters after the decimal.
- Number. Enter a numeric value with a number of characters after the decimal that does not exceed the number of characters specified in the Decimals field.
- Integer. Enter an integer, up to 2,147,483,647.
- Date. Enter a date in the format of month/day/year.
- Time. Enter a time in the format of hour/minute/second.
Note: You can enter as many values as you want.
Overview
Use the Optional Fields screen to create system-wide optional fields for Sage 300. Once you have created optional fields for your system, you can add them to each of the applications in which you want to use them.
Optional fields let you customize Sage 300 by storing additional information with records and transaction details in any or all of the Sage 300 applications you use.
For example, you could add optional fields that let you specify a Discontinued Date for discontinued items, or a Reviewed By field for transactions that require review.
Note: There is no limit to the number of optional fields you can create. However, using an excessive number of optional fields may slow down your system.