Previous Next JavaScript must be enabled to correctly display this content

## 3.9.1.1 Create Exact Reconciliation Rule Definition

This topic describes the systematic instruction for setting up recon rule for Exact reconciliation category.

1. On Home screen, click Receivables and Payables. Under Receivables and Payables, click Maintenance.
2. Under Maintenance, click Reconciliation. Under Reconciliation, click Reconciliation Rule Definition
3. Under Reconciliation Rule Definition, click Create Reconciliation Rule Definition.
   The Create Reconciliation Rule Definition screen displays.

   Figure 3-50 Create Exact Reconciliation Rule Definition

   Description of "Figure 3-50 Create Exact Reconciliation Rule Definition"
4. Specify the fields on Create Exact Reconciliation Rule Definition screen.

   Note:

   The fields marked as Required are mandatory.

   For more information on fields, refer to the field description table.

   Table 3-27 Create Exact Reconciliation Rule Definition - Field Description

   Field | Description
   --- | ---
   Rule Description | Specify the description of recon rule.
   Recon Category | Select any one of the below categories of recon for which rule is defined. Invoice/Debit Notes to Credit Notes Recon Invoice/Debit Notes to Payment Recon Finance Payment Recon Expected Cashflow To Payment Recon Allocation of Payment to Virtual Accounts
   Recon Type | Select Exact as the category of the Recon definition. Note: When the Reconciliation rule is defined with Recon Type set to Exact and linked to a Rule Decisioning: filter criteria Corporate Based, the rule should not be seen again in the rule ID list when creating Rule Decisioning for any filter criteria. When the Reconciliation rule is defined with Recon Type set to Exact and linked to a Rule Decisioning: filter criteria Corporate Based, the rule should not be seen again in the rule ID list when creating Rule Decisioning for any filter criteria.
   Allocation Details | If allocation required, then select the appropriate value to specify whether the allocation should be done based on the account or attribute of entity like cashflow finance/payment/invoice.

5. In the Exact Recon section, perform the following steps to create conditions or group of conditions:
   1. Click Add Condition to add a single line of condition. Or, click Add Group to add a group of conditions.
   2. Click inside the added container to view buttons for adding condition details.
      The Exact Recon - Condition/Group Details screen displays with the Fixed Value, Text between, Invoice/Payment Attributes, Cashflow/Payment Attributes, or Payment Attributes (depending on the selected recon category).

      Figure 3-51 Exact Recon - Condition/Group Details

      Description of "Figure 3-51 Exact Recon - Condition/Group Details"
   3. Click Fixed Values to define the value to be validated.
   4. Click Text between to define the range of text to be validated.
      The Exact Recon - Text Between screen displays.

      Figure 3-52 Exact Recon - Text Between

      Description of "Figure 3-52 Exact Recon - Text Between"
   5. Select the Case Sensitive as Yes or No to check the case sensitivity of the field value while recon execution.
   6. Click Invoice/Expected Cashflow Attributes Invoice/Finance Attributes to define condition for invoice/cashflow finance details. Or click Payment Attributes to define condition for payment details.
      The Exact Recon - Attributes screen displays.

      Figure 3-53 Exact Recon - Attributes

      Description of "Figure 3-53 Exact Recon - Attributes"

      For more information on the attributes, refer the following attributes table.

      Table 3-28 Exact Recon - Attributes

      Invoice | Credit Note | Finance | Payment
      --- | --- | --- | ---
      Base Invoice Amount | Credit Note Number | Product Code | Payment Date
      Buyer Name | Supplier Code | Supplier Name | Credit Account No.
      Net Invoice Amt. | Credit Note Base Amount | Finance Reference No | Bank
      Supplier Division Code | Buyer Name | Finance Amount | Relationship Code
      Bank | Credit Note Date | Program Code | Virtual Account Owner
      Invoice CCY | Buyer Id | Buyer ID | Entity Ref No.
      Payment Due Date | Net Credit Note Amount | Buyer Name | Branch
      Supplier ID | Supplier Name | Supplier ID | Filler (10 Attributes)
      Branch | Credit Note Number | Finance Start Date | Payment Mode
      Filler (4 attributes) | Supplier Code | Finance Maturity Date | Payment Party Id
      PO No. | Credit Note Base Amount | Finance Status | Instrument Date
      Supplier Name | Buyer Name | Borrower | Virtual Account Flag
      Buyer Code | Credit Note Expiry Date | Delinquency Status | Payment Party Code
      Invoice Date | Supplier Id | Interest Collection Frequency | Counterparty Id
      Repayment Account No. | Buyer Division Code | - | Remarks
      Buyer Division Code | Filler (10 Attributes) | - | Payment Reference No
      Invoice Due Date | Buyer Code | - | Counterparty Code
      BIC/Routing Code | Currency | - | Beneficiary Id
      Buyer ID | Supplier Division Code | - | Payment Currency
      Invoice No. | Remarks | - | Debit-Credit Indicator
      Supplier Code | Program ID | - | Remitter Account No
      Payment Under Approval (PUA) | Indirect Payment Flag | - | Payment Amount
      - | - | - | Interest Refund
      - | - | - | Margin Refund
      - | - | - | Payment Under Approval (PUA)
      - | - | - | Indirect Payment Flag
      - | - | - | Instrument Cleared
      - | - | - | Payment Type
      - | - | - | Program Code

      Table 3-29 Exact Recon - Attributes

      Invoice | Credit Note | Expected Cashflow | Payment
      --- | --- | --- | ---
      Base Invoice Amount | Credit Note Number | External Reference No | Payment Date
      Buyer Name | Supplier Code | Cashflow Type | Credit Account No.
      Net Invoice Amt. | Credit Note Base Amount | Revised Expected Date | Bank
      Supplier Division Code | Buyer Name | Narration/Remarks | Relationship Code
      Bank | Credit Note Date | Corporate ID | Virtual Account Owner
      Invoice CCY | Buyer Id | Bank Account Number | Entity Ref No.
      Payment Due Date | Net Credit Note Amount | Counterparty Name | Branch
      Supplier ID | Supplier Name | Free Field (10 Attributes) | Filler (10 Attributes)
      Branch | Credit Note Number | Code | Payment Mode
      Filler (4 attributes) | Supplier Code | Amount | Payment Party Id
      PO No. | Credit Note Base Amount | Counterparty Id | Instrument Date
      Supplier Name | Buyer Name | Customer Reference No | Virtual Account Flag
      Buyer Code | Credit Note Expiry Date | Description | Payment Party Code
      Invoice Date | Supplier Id | Expected Date | Counterparty Id
      Repayment Account No. | Buyer Division Code | Virtual Account Number | Remarks
      Buyer Division Code | Filler (10 Attributes) | - | Payment Reference No
      Invoice Due Date | Buyer Code | - | Counterparty Code
      BIC/Routing Code | Currency | - | Beneficiary Id
      Buyer ID | Supplier Division Code | - | Payment Currency
      Invoice No. | Remarks | - | Debit-Credit Indicator
      Supplier Code | - | - | Remitter Account No
      Payment Under Approval (PUA) | - | - | Payment Amount
      - | - | - | Interest Refund
      - | - | - | Margin Refund
      - | - | - | Payment Under Approval (PUA)

   7. Click starts with, ends with and Contains to define the text to be validated based on each selection.
   8. Click Operator to specify how to compare defined values.
   9. Repeat the above steps to add more conditions and/or group of conditions.
   10. Click Delete icon to delete the condition located at the right-bottom of the condition container.
   11. Click AND / OR to define how many conditions or combination of conditions should be matched to execute the recon rule.
   12. Click Validate and Preview to check if the added conditions are valid or not.
       The Allocation Basis Grid displays.

       Figure 3-54 Allocation Basis Grid

       Description of "Figure 3-54 Allocation Basis Grid"

       For more information on fields, refer to the field description table.

       Table 3-30 Allocation Basis Grid - Field Description

       Field | Description
       --- | ---
       Narration | Specify the narration. The narration entered in the Reconciliation Rule Definition will be sent to VAM during the auto-allocation of the payment to the Virtual Account, so it can be recorded in the statement.
       Allocation Account | Click to search and select the Allocation Account from the LOV.
       Real Account Number | Displays the Real Account Number based on the selected Allocation Account.
       Percentage | Specify the percentage of allocation.

6. In the Allocation Basis Grid section, perform the following steps to define percentage of account/attribute allocation:
   1. Click to add a new row.
   2. Double click the row to add/edit attribute and percentage.
   3. Repeat the above steps to add more attributes.
   4. Click under Action column to remove the allocation row.
7. Click Save to save the record and send it for authorization.

Parent topic: Reconciliation Rule Definition