Definition

User-defined rules can be created in order to have a benefit calculated only for certain groups of employees or the rates/fixed values ​​based on various criteria.

To define the rule, the desired query can be put together using various WHERE, AND, OR operators.  All tables and fields can be selected. One table can be selected for each rule and the query can be defined based on the available fields.  Date formulas can also be used to define time-dependent rules.
The formulas that can also be set as filter criteria in the default Business Central views are available. The placeholders below are also available:

– Date of resignation: RD or resignationdate
– Settlement date: PD or paydate

A possible formula would be, for example:

>pd-cm-70Y

Different queries can be combined and grouped accordingly within a rule.
Different rules can also be used together in one rule. For example, age limit rule in combination with gender rule.

Note: at the moment, these functions are only available for table 3009080 Personnel.