Mandatory Fields

Mandatory Fields makes sure master data is complete before it is used. You choose a table and define which fields must be filled in. As long as a mandatory field is empty, the record is blocked, so incomplete customers, vendors or items cannot cause errors later in sales, purchasing or posting.

Setup is done by the users. Select a table, pick the Boolean or Option field used to block the record and the value to use while fields are missing, and then add the mandatory fields for that table. Several setups can be created for the same table using setup codes, for example different requirements for EU and non-EU customers, and each setup can be switched on or off.

On the customer, vendor and item cards, a FactBox shows which fields are still missing. When the last one is filled in, the app removes the block it set. Blocks set manually are left alone. Text, code, number, date and time fields can be mandatory. The check runs on the database triggers, so it works with any table in Business Central, including custom tables and tables introduced by other apps, and applies in every page and process.