Rule Logic
The Rule Logic column is used to create multidimensional lookups and check rule expressions. Rule Logic columns are processed for reports only in #ModeRule or #ModeList mode. After a rule logic is processed for a rule in the check report, Data Management flags the rule as passing or failing.
Check Rule Condition Expressions
Check rule expressions are used primarily to validate target-system account balances when performing multidimensional lookups. The expressions return a True or False result.
For example, the following returns true (OK) if Cash (a target account) has a positive balance, and false (Error) when it does not:
|,,,YTD,<Entity Currency>,,Cash,[ICP None],[None],[None],[None],[None],,,,,,,,,,,,,,,,|>0
In this example, the check rule expression returns true (OK) when the value of Cash (a target account) plus $1000 is greater or equals the value of AccruedTax (another target account), and false (Error) when it does not:
|,,,YTD,<Entity Currency>,,Cash,[ICP None],[None],[None],[None],[None],,,,,,,,,,,,,,,,|+1000>=|,,,YTD,<Entity Currency>,,AccruedTax,[ICP None],[None],[None],[None],[None],,,,,,,,,,,,,,,,|