Multiple validation rules

Example

This example shows how multiple rules supplement each other.

Rule	Line	Rule Type	From Ledger Account	ToLedger 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	ToLedger 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	ToLedger 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	ToLedger 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	ToLedger 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	ToLedger 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.