See how Field Validation works
Click a topic and Controlly explains how Field Validation works.
With the type Warning the user sees what is wrong, but the change is still saved. That way you introduce a new rule gently.
Result for you
Users learn the rule without their work coming to a halt.
See it in action
Watch this 5 minute demo: warn or block while users work, clean up existing data with Check Table and validate a sales order when it is released.
Bad data is cheap at entry and expensive afterwards.
Posting groups, payment terms, document numbers and ship-to addresses can be empty or wrong until it hurts. Standard Business Central checks only a fixed set of fields, and often only at posting.
A missing posting group or wrong payment term only stands out when the process gets stuck.
Standard checks often come at the last moment, when the error has already moved through the process.
A new check says nothing about the records that are already in the database.
Define what a valid record looks like
With Compliance Field Validation, data owners define per table which requirements the fields must meet, without code. The app checks this at the moment that counts: when a user changes a field and when a document is released. Per validation you choose whether the user gets a warning or the change is stopped.
- Preventive: warn or block while users work
- Detective: find existing errors with Check Table
- Scoped per company, permission set and period
How it works
Field Validation works inside Business Central, online and on-premises. By default a validation applies to all companies and all users with the permission set of the app.
Install the app from Microsoft Marketplace and register it. This starts a free 30-day trial.
Choose the table, add a rule per field and choose between warning or error. The wizard gets you started.
Validations are loaded when a user signs in. After the next sign-in they are active.
Everything you need for better data quality
Preventive and detective checks in one app, set up inside Business Central.
Warning or error
You choose how strict
A warning informs the user, an error reverses the change until the data is correct.
Your own messages
Users know what to do
The message is your own text, so users see right away what to fix.
Seven rule types
Every check you need
Mandatory, filter, length, regular expression, calculated, related field and related number of records.
Dimension rules
Default dimensions enforced
Check a record against the default dimension settings of the table, such as a mandatory department on the customer.
Check Table
Find existing errors
See which records already break an active rule and open them directly to correct them.
Conditions
Checks at the right moment
Let rules run only under conditions, for example when an order is released or a card is not blocked.
Copilot
Regular expressions made easy
Let Copilot propose a regular expression for a pattern, such as a document number or postal code.
Scope
Per company and permission set
Limit a validation to certain companies or permission sets, with a starting and ending date.
Wizard
A first rule in no time
With the wizard a simple validation is ready in a few steps.
What is in it for you?
Reliable data for reporting and compliance.
- Posting groups and payment terms always filled in
- Errors found before an order moves on
- Fewer corrections afterwards
Data quality without customization.
- Set up validation rules without code
- New rules as a warning first, then as an error
- Check Table to clean up existing data
Cleaner data in your implementations.
- Master data right from the start of the project
- Rules the customer can manage themselves
- Works online and on-premises
Good to know
Start with a warning
Set a new rule to warning first, review the findings with Check Table, clean up the data and then switch the rule to error.
Validations apply after signing in again
Validations are loaded when a user signs in. After a new or changed validation, users first need to sign out and in again.
Trial or license
Registration starts a free 30-day trial. After that the app stays installed, but you need a license to keep using it.
Start improving your data quality today.
- Checks at the moment of entry
- Existing errors in view with Check Table
- Start with a free 30-day trial
Built by 2-Controlware, specialists in authorization management for Microsoft Dynamics.
Frequently asked questions
Discover our complete package
In addition to Field Validation, we offer the Authorization Box, Field Security, Advanced Permissions Management and the Advanced Permissions Recorder to help you set up, manage and monitor your authorizations.
Authorization Box
Assign, manage, and monitor authorizations
The authorization solution for Microsoft Dynamics, for a more manageable and controllable environment.
Field Security
Authorize on field and dataset level
Optimize the standard permissions structure at field, filter and action level.
Advanced Permissions Management
Track, review and roll back permission changes
See every permission set change, who made it and when, and undo a mistake in a few steps.
Advanced Permissions Recorder
Record, clean up and target permissions
Record the permissions of other users in a few clicks and clean up unnecessary entries automatically.
