Show TOC

Object documentationMatching Criteria - External Reconciliation - Setup Locate this document in the navigation structure

 

Use this window to specify matching criteria for performing external reconciliation.

To open this window, choose   Administration   Setup   Banking   Bank Statement Processing   Matching Criteria - External Reconciliation  .

For each round, you can set a combination of up to three rules. Each rule can consider one of the available parameters.

Note Note

Each parameter can be used for only one rule in a specific round. Once you assign a parameter to a rule, it is removed, for the same round, from the drop-down boxes of the other rules.

End of the note.
Matching Criteria - External Reconciliation - Setup Window Fields
Posting Date

Selecting this parameter:

  • Lets you reconcile documents whose assigned posting dates are a consideration

  • Displays the Variation in Days field

    Specify the number of days to consider as a legitimate difference, below which reconciliation takes place.

    When left empty, this field is considered to have a zero value.

Example Example

The variation in days is defined as 3. The posting date of a specific invoice is 01.05.2007, and there is a payment for the exact amount with the posting date of 06.05.2007. The difference is five days. In this case reconciliation does not take place.

End of the example.
Due Date

Selecting this parameter:

  • Lets you reconcile documents whose assigned due dates are a consideration

  • Displays the Variation in Days field

    Specify the number of days to consider as a legitimate difference, below which reconciliation takes place.

    When left empty, this field is considered to have a zero value.

Example Example

The variation in days is defined as 3. The due date of a specific invoice is 01.05.2007, and there is a payment for the exact amount with the posting date of 06.05.2007. The difference is five days. In this case reconciliation does not take place.

End of the example.
Balance Amount

Selecting this parameter:

  • Lets you reconcile journal entries posted to business partners, using transaction amounts as a matching criterion

  • Displays the Matching Difference field

    Specify the amount SAP Business One should consider as a threshold for the reconciliation. Any difference lower than the specified value is valid and the reconciliation will succeed, while a higher difference is not valid for reconciliation.

    To limit this rule to identical amounts only, leave the Matching Difference field empty.

Example Example

You specify the amount 0.5 as the Matching Difference value. SAP Business One scans the manual journal entries posted to a specific business partner, looking for a transaction to reconcile with a 100.08 debit amount. It finds a transaction with a 100.7 credit amount – a difference of 0.62, and another transaction with a 99.85 credit amount – a difference of 0.23. The first transaction has a higher difference than that defined; it will not be reconciled. The difference in the second transaction is smaller than that defined; the reconciliation will succeed.

End of the example.
Ref. 1, Ref. 2, Ref. 3

Selecting one of these references:

  • Lets you reconcile journal entries posted to business partners, using the value defined in the Ref. 1, Ref. 2, or Ref. 3 fields in the Journal Entry window as a matching criterion

  • Displays the Relate to XXX Last Characters field

    Specify a number higher than 0 to define the level of accuracy of this parameter. The lower the number, the lower the level of accuracy, and vice versa. SAP Business One checks the defined number of characters starting from the right.

Note Note

You can use only one reference as a rule in a given round of reconciling business partner journal entries. When you select one of the references as a rule, the other references are not available for the other rules in the same round.

End of the note.

Example Example

You select Ref. 1 for Rule No. 1 in Round 1. In the Relate to XXX Last Characters field you specify the value 3. When you continue to Rule 2, the options Ref. 2 and Ref. 3 do not appear in the drop-down box. SAP Business One scans the manual journal entries created for a business partner, looking for a match for transaction 96 785.

It finds a journal entry with the value of 4785. Since the last three characters are identical, it can be matched.

End of the example.