Overlapping ranges within a rule

Example 1

You define a cross validation rule with two elements:

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