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.