NAV Specific

Data Validation Rules

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

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.

To open the 'Data Validation Rules' window click: Webshop -> Lists -> Data Validation Rules:

Data Validation Rules

To add a data validation rule create a new record in the 'Data Validation Rules' window:

Data Validation Rules of the 'Item' Table

The tables below provide description for the controls in the 'Data Validation Rule' form.

General FastTab:

Lines FastTab:

There is the 'Custom Function' method. By registering custom functions in the 'SC - Validation' codeunit Microsoft Dynamics NAV developers can create more complex data validation rules.

If the changes made in the 'Data Validation Rules' window influenced the webshop catalog overview, for instance information about items orderability, refreshing of the webshop catalog information may be required. In this case you will see a message.

Use 'Set Defaults' for the current table or 'Set All Rules Defaults' for all tables to restore the default data validation rules.