Multiple validation rules

Example

This example shows how multiple rules supplement each other.

Rule Line Rule Type From Ledger Account To Ledger Account From Cost Center To Cost Center From Project To Project From Region To Region
A 1 Include   ZZZZZ   ZZZZ P01 P10 EMEA EMEA
A 2 Include   ZZZZZ   ZZZZ P11 P20 APAC APAC
B 1 Include 45000 46000 100 110   ZZZZ   ZZZZ

If ledger account 45000 and cost center 200 are specified, LN will display an error message because rule B is violated. Specifying ledger account 45000 and cost center 100 will not correct this error.

If ledger account 46000, cost center 110 and project P33 are specified, LN will display an error message because there is no applicable line in rule A. Ledger account 46000, cost center 110, project P11 and region APAC, would be valid input.

Override general rule – I

For ledger account range 45000 - 46000, users must be able to specify any project and region combination. To achieve this, add the following line to rule A:

Rule Line Rule Type From Ledger Account To Ledger Account From Cost Center To Cost Center From Project To Project From Region To Region
A 3 Include 45000 46000   ZZZZ   ZZZZ   ZZZZ

Override general rule – II

For ledger account range 45000 - 46000, users must be able to specify only project P05 and region EMEA. To achieve this, modify line 1 of rule B:

Rule Line Rule Type From Ledger Account To Ledger Account From Cost Center To Cost Center From Project To Project From Region To Region
B 1 Include 45000 46000 100 110 P05 P05 EMEA EMEA

To achieve the same result by using rule A, define the following lines:

Rule Line Rule Type From Ledger Account To Ledger Account From Cost Center To Cost Center From Project To Project From Region To Region
A 1 Include   ZZZZZ   ZZZZ P01 P10 EMEA EMEA
A 2 Include   ZZZZZ   ZZZZ P11 P20 APAC APAC
A 3 Exclude 45000 46000   ZZZZ P01 P04   ZZZZ
A 4 Exclude 45000 46000   ZZZZ P06 ZZZZ*   ZZZZ
B 1 Include 45000 46000 100 110   ZZZZ   ZZZZ

* Can also be P20.

Override general rule – III

For ledger account range 45000 - 46000, users must be able to specify only project P05 and region APAC. To achieve this, modify both rules A and B:

Rule Line Rule Type From Ledger Account To Ledger Account From Cost Center To Cost Center From Project To Project From Region To Region
A 1 Include   ZZZZZ   ZZZZ P01 P10 EMEA EMEA
A 2 Include   ZZZZZ   ZZZZ P11 P20 APAC APAC
A 3 Include 45000 46000   ZZZZ P05 P05 APAC APAC
B 1 Include 45000 46000 100 110 P05 P05 APAC APAC

If you prefer to not modify rule B, define the following lines:

Rule Line Rule Type From Ledger Account To Ledger Account From Cost Center To Cost Center From Project To Project From Region To Region
A 1 Include   ZZZZZ   ZZZZ P01 P10 EMEA EMEA
A 2 Include   ZZZZZ   ZZZZ P11 P20 APAC APAC
A 3 Include 45000 46000   ZZZZ P05 P05 APAC APAC
A 4 Exclude 45000 46000   ZZZZ P01 P04   ZZZZ
A 5 Exclude 45000 46000   ZZZZ P06 ZZZZ*   ZZZZ
B 1 Include 45000 46000 100 110   ZZZZ   ZZZZ

* Can also be P20.