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],,,,,,,,,,,,,,,,|