Overlapping ranges within a rule

Example 1

You define a cross validation rule with two elements:

Line	Rule Type	From Ledger Account	ToLedger Account	From Cost Center	To Cost Center	From Project	To Project
1	Include	41000	42000	100	200	P01	P99
2	Include	41500	41500	100	100	P02	P10

Upon specifying the second line, LN will display an error or warning message. Because of the wider ledger account range in the first line, the second line makes no sense.

In this case, you can use a rule similar to the following:

Line	Rule Type	From Ledger Account	ToLedger Account	From Cost Center	To Cost Center	From Project	To Project
1	Include	41000	41499	100	200	P01	P99
2	Include	41500	41500	100	100	P02	P10
3	Include	41501	42000	100	200	P01	P99

Example 2

Line	Rule Type	From Ledger Account	ToLedger Account	From Cost Center	To Cost Center	From Project	To Project
1	Include	43000	43000		ZZZZ	P01	P10
2	Include	43000	43000		ZZZZ	P20	P30
3	Include	43000	43000	100	100		ZZZZ

This setup is illogical: when a user specifies cost center 100 for ledger account 43000, they can enter any project. If, however, a different cost center is specified, only P01 - P10 and P20 - P30 are valid projects.

In this case, you can use a rule similar to the following:

Line	Rule Type	From Ledger Account	ToLedger Account	From Cost Center	To Cost Center	From Project	To Project
1	Include	43000	43000	100	100	P01	P10
2	Include	43000	43000	100	100	P20	P30

Alternatively, the same result could be achieved by moving the third line to another rule.