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.