Microsoft Dynamics 365 Business Central

Data Validation Rules

Administrators can manage data validation directly in Microsoft Dynamics 365 Business Central.

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 by Sana.

To open the Data Validation Rules window choose the Search for Page or Report icon and enter Data Validation Rules.

To add a data validation rule, create a new record in the Data Validation Rules window.

The tables below provide description for the fields in the Data Validation Rule window.

General FastTab

 Lines FastTab

 NOTE

There is the Custom Function method. By registering custom functions in the SC - Validation codeunit, Dynamics 365 Business Central developers can create more complex data validation rules.

 NOTE

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 might 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.