Data Validation Rules

WATCH THE VIDEO

As a user of Microsoft Dynamics 365 for Finance and Operations you can manage data validation directly in the system.

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

To open the Data validation rules form, click: Webshop > Setup > Data validation rules.

To add a data validation rule, create a new record in the Data validation rules form.

The table below provides the description of the fields.

Field

Description

Table ID

The table for which data validation rules should be set. All existing in the database tables are available.

Table name

The table name which is selected in the Table ID dropdown.

Modified by

NOTE

Applies to: Sana Commerce Cloud 10.0.70 and higher in Microsoft Dynamics 365 for Finance and Operations.

Use these fields to see who and when changed a certain rule. If a data validation rule has been changed and it affects some functionality or operation of the webstore, you can check when and by whom this change was made.

Modified date and time

Active

Use this checkbox to enable or disable data validation rules of the related table.

Field ID

The related table field for which a data validation rule should be set. All fields of the related table are available.

Field name

The field name which is selected in the Field ID dropdown.

Criteria operator

An operator that indicates a specific data validation expression.
The combination of criteria operator and value defines the validation rule for the related table field.

Value

The available filed values.

Error message

The error message of the related validation rule which will be shown if some data does not pass validation.

The error messages are predefined, but it is possible to overwrite them.

The following error messages are also used to show the non-orderable reason of a product in the Webshop Catalog Overview form.

NOTE

There is the Custom function criteria operator. Using this criteria operator, you can create more complex data validation rules. The lookup values for Custom function are formed from the class SC_AXDataServiceClient_Common with the correct signature and prefix vr_.

Use Defaults for the current table or Reset all to defaults for all tables to restore the default data validation rules.