3.7.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-44 Create Exact Reconciliation Rule Definition

   
   

   
   Description of "Figure 3-44 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-22 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 Allocation of Payment to Virtual Accounts
   Recon Type	Select Exact as the category of the Recon definition.
   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 /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, or Payment Attributes (depending on the selected recon category).

      Figure 3-45 Exact Recon - Condition/Group Details

      
      

      
      Description of "Figure 3-45 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-46 Exact Recon - Text Between

      
      

      
      Description of "Figure 3-46 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 to define condition for invoice/ details. Or click Payment Attributes to define condition for payment details.
      The Exact Recon - Attributes screen displays.

      Figure 3-47 Exact Recon - Attributes

      
      

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

      
      

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

   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-48 Allocation Basis Grid

       
       

       
       Description of "Figure 3-48 Allocation Basis Grid"

       
       

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

       Table 3-23 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.