Working With Format Rules

Format rules affect reconciliation workflow, the requirement for reconciliation attachments, or the value of profile/reconciliation attributes. The rules are displayed on the Profile Rules tab in read-only form.

Rules evaluate transaction conditions only if the accompanying reconciliations already exist.

See Order of Precedence for Auto Reconciliation and Rules.

To work with format rules:

1. From Home, click Application, then Configuration, and then Formats.
2. Double-click a format.
3. On Edit Format, select the Rules tab. You can view the following information:

   • Order—The order of precedence. See Order of Precedence for Auto Reconciliation and Rules

   • Rule—Name of the Rule.

   • Conditions—The choice of what conditions must exist before running the rule.

4. To create, edit, duplicate, delete, or reorder a rule, on the Rules tab, click the appropriate button and, if necessary, update the following:

   • Rule—Select a rule.

   • Description—Optional. Explain why you configured the rule and how the rule should be used.

   • Message (on some rules):

     • Message to Preparer—Define an optional message to the preparer on the prevent reconciliation submission rule and require reconciliation attachment rules.

     • Message to Reviewer—Define an optional message to the preparer on the prevent reconciliation approval rule.

   • Reviewer Level—Select All Levels to apply the rule to all reviewer levels or select specific reviewer levels individually. At least one reviewer level must be selected.

   • Select Create Filter and populate the conditions section or select Use Saved Filter, and then select a filter. The filter you select and configure for the rule determines the conditions that trigger the rule to apply.

   • Condition—

     • If you select Use Saved Filter, the Conditions section displays a read-only version of the conditions associated with the saved filter.

     • If you select Create Filter, the Condition section is enabled.

       Conjunction, Source, Attribute, Operator, and Value behave as they do for the existing advanced filter feature. When creating filters, you can use these attributes:

       • Any Reconciliation or Transaction attribute, including calculated attributes, that are classified as Reconciliation and Transaction attributes

       • Period Frequency

   When a condition includes columns that are based on currencies, and you select All, then all the listed currencies are included in the condition. If you configure additional currencies at a later date, these new currencies are automatically added to the condition.

   In Reconciliation Compliance, when a reconciliation is claimed and manually submitted by a Preparer, the Auto Approve Reconciliation rule is automatically run. If you want the Auto Approve Reconciliation rule to be run only when a reconciliation is automatically submitted, create an additional filter in the Auto Approve Reconciliation rule with the condition Auto Submit = Yes.

   Note:

   When you make changes to a rule definition, the additional information is added to the audit log. You can view the changes both in the History tab as well as the Audit Report.

   To watch a video about using formats with rules, click this link: