Show/Hide All

Note This topic does not apply to Sage 100 Premium.

The following information applies only to import jobs for the Material Requirements Planning and Work Order modules.

Refer to the sections below for information about the types of validation performed on the Import Job Maintenance Validation tab.

 Expression Validation

Certain data items are validated using validation expression unique to that field. Standard validation expression logic is assigned automatically and should not be changed. A new validation expression can be added to a field that does not already have a standard expression logic assigned.

The expression must evaluate true (a nonzero value) in order for the field to be validated. An expression that evaluates to false (a zero value) fails the validation. For example: {AR.HIST:SALES1} > 1000 will return true (1) if AR.HIST:SALES1 is greater than 1000 and returns false (0) if it is equal to or less than 1000.

The Expression Builder can be used to create a logical expression comparing the value of one field to another field or constant value.

Any data item with standard validation expression will display EXPRESSION in the VALIDATION column of the Data Dictionary Listing. The actual logic used to validate the field is not provided on the Data Dictionary Listing. For more information, see Calculation Expressions.

 

 File Validation

Certain data items are validated against another data file to ensure that they represent an existing record in that file. For example, the salesperson code must represent a valid salesperson record in the Salesperson file. If a valid entry does not exist, the data item is considered invalid and will not be imported.

The file validation information can be printed using the Data Dictionary Listing. Any data item requiring file validation displays FILE in the VALIDATION column, and the name of the file used to validate the field in the FILE/STRING column. If file validation is not performed for a blank data item (that is, a blank item is considered a valid entry), YES appears in the SKIP BLANK column.

 

 List Validation

Import fields can be validated against a list of values. The import data must match one of the values in a list specified in the Validation Properties window, accessed from the Import Job Maintenance Validation tab. For example, the STATE field must match one of the values in the list (CA, NV, AZ, NY, etc.). The list can contain any number of values.

 

 Program Validation

The Program validation feature can be used to perform complex logic to validate data. This feature is provided for use by a qualified development partner.

 

 Range Validation

Import fields can be validated against a range of values. The starting and ending values for the validation can be specified in the Validation Properties window, accessed by double-clicking a validation field on the Import Job Maintenance Validation tab. For example, the CREDIT_LIMIT field must be a value between 0 and 100,000.00 inclusive. Both string-type and numeric-type fields can use the Range validation feature.

 

 String Validation

Certain string-type data items are validated against a list of characters. The data being imported must match one of the character sets specified for the field. For example, the Product Type field in the Inventory file must be one of the following letters: F, R, D, M, B, or K.

The string validation information can be printed using the Data Dictionary Listing. Any data item requiring string validation displays STRING in the VALIDATION column and the string characters used to validate the field in the FILE/STRING column. If string validation is not performed for a blank data item (that is, a blank item is considered a valid entry), YES appears in the SKIP BLANK column.

The validation string will display as a continuous list of characters. For string fields that have a length of only one character, the string will be a list of the allowable characters. For string fields that have a length of two or more characters, the string will list the valid character sets.

 

 Uppercase String Validation

Uppercase string validation is similar to string validation, except that all data must be uppercase, as well as match the validation string. If a validation string is not specified, the input field must be uppercase.