User GuideSAP Business One

SAP Business One

Data Validation Rules

SAP Business One administrators can manage data validation directly in SAP.

Use the Data Validation Rules window to manage validation rules of the appropriate tables and related fields. This window can be used to configure validation rules which affect data retrieving. For instance, you can configure validation rules which define if an item is orderable or a customer is allowed to order. Only data which satisfies the selected criteria can be processed.

In SAP Business One click: Web Store > Setup > Data Validation Rules.

Data Validation Rules

Select the table for which data validation rules should be set. Use the Enabled check box to activate/deactivate data validation rules for the table.

Click this button   to set up data validation rules for the selected table.

Data Validation Rules of the 'OITM' Table

The table below provides description of the fields in the Data Validation Rules window.

Field Description
Field Name The field of the table for which data validation rule should be set.
Method An operator that indicates a specific data validation expression. The combination of the method and value defines the validation rule for the selected table field.
Value The available field values.
Error Text The error message of the related validation rule which is shown if some data does not pass validation. The error messages are predefined but it is possible to overwrite them.
Priority The priority of the validation rules. The fields of the tables are checked in order set by priority.
User GuideSAP Business One