3.5.1.2 Create Generic Reconciliation Rule Definition

This topic describes the systematic instruction for setting up recon rule for ‘Generic’ reconciliation category.

Specify User ID and Password, and login to Home screen.
  1. On Home screen, click Cash Management. Under Cash Management, click Receivables & Payables.
  2. Under Receivables & Payables, click Maintenance. Under Maintenance, click Reconciliation Rule Definition.
  3. Under Reconciliation Rule Definition, click Create Reconciliation Rule Definition.
    The Create Reconciliation Rule Definition screen displays.

    Figure 3-42 Create Generic Reconciliation Rule Definition



  4. Specify the fields on Create Generic Reconciliation Rule Definition screen.

    Note:

    The fields, which are marked with an asterisk, are mandatory.
    For more information on fields, refer to the field description table.

    Table 3-15 Create Generic Reconciliation Rule Definition - Field Description

    Field Description
    Rule Description Specify the description of recon rule.
    Recon Category Select any one of the below category of recon for which rule is defined.
    • Invoice/Debit Notes to Credit Notes Recon
    • Invoice/Debit Notes to Payment Recon
    • Expected Cashflow To Payment Recon
    • Allocation of Payment to Virtual Accounts
    Recon Type Select Generic as the category of the Recon definition.
    Allocation Basis Select the value to specify whether the allocation should be done based on account or attribute.

Figure 3-43 Generic Recon Rule



  1. In the Generic Recon section, perform the following steps:

    Note:

    The Base Entity is auto-populated based on selected Recon Category.
    1. In the Generic Criteria list, select the generic rule to be defined. viz. FIFO – First In First Out, LIFO – Last In First Out, HAFO – Highest Amount First Out and LAFO – Least Amount First Out.
    2. In the Based On Attribute list, select the entity (invoice/cashflow) attribute on which the rule would be based. The available attributes are based on the combination of selected recon category and generic criteria.
    The Allocation Basis Grid section displays.

    Figure 3-44 Allocation Basis Grid



  2. In the Allocation Basis Grid section, perform the following steps to define account/attribute allocation basis which the allocation would be done and percentage.
    1. Click Add icon to add a new row.
    2. Double click the row to add/edit attribute/account and appropriate percentage.
    3. Repeat the above steps to add more attributes.
    4. Click Delete icon under Action column to remove the allocation row.
  3. Click Save to save the record and send it for authorization.