ERP User GuideMicrosoft Dynamics 365 for Finance and Operations, Enterprise Edition

Microsoft Dynamics 365 for Finance and Operations, Enterprise Edition

Sana Commerce 9.2
Your connector

Data Validation Rules



As a user of Dynamics 365 Enterprise Edition 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 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.
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 current table methods 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.

ERP User GuideMicrosoft Dynamics 365 for Finance and Operations, Enterprise Edition