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.

Product Versions

Links

Sana Commerce does not accept any liability for the content of this website, or for the consequences of any actions taken on the basis of the information provided. The information below should be interpreted as an example. No rights can be derived from this information.
Sana Commerce – the integrated e-Commerce solution for Microsoft Dynamics and SAP