User GuideAX Specific

AX Specific

Sana Commerce 9.1
Your connector

Back Next

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.

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.

Back Next

User GuideAX Specific

Sitemap

Installation

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

Updated: January 2017