Validate Optional Field in Sage 300 ERP

By | April 26, 2014

Sage 300 ERP provides us a very useful tool of Optional field which can be linked to any modules Transactions at the Header as well as Detail Level. Optional field can also be used to store any additional information for any transaction. There is no limit to the number of optional fields one can create.

One can create the optional field by navigating to Common Services > Optional Fields.

New Stuff: Process IC Adjustments in Sage 300 ERP

While creating the Optional Field we have the option of Validate if one check this option the entry field enables one more option of Allow Blank as highlighted below.


The function of both the options can explained as below.

Validate: One selects the Validate option if one wants to create a list of valid entries for the optional field and restrict users to enter the values other than included in the list.

Allow Blank: One selects this option if one wants to allow blank entries as valid entries for this field, then user will be able to select the optional field and leave the field as blank.

If this option is kept unchecked one would be able to save the Value field without any value in it as can be seen in the below screen highlighted.


After using this option one will be able to restrict the users from doing wrong and blank entries in any of the transactions where these optional fields are linked.

Note: Once this option is selected and the optional field is saved, one would not be able to modify this option.