ERP User GuideMicrosoft Dynamics AX

Microsoft Dynamics AX

Sana Commerce 9.3
Your connector

Data Validation Rules



Microsoft Dynamics AX administrators can manage data validation directly in MS Dynamics AX.

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 instance, 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.


Data Validation Rules

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

The following table provides descriptions for the controls in this form:

Field Description
Table ID The table for which the 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 check box to enable/ disable data validation rules of the related table.
Field ID The related table field for which the 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 AX