Show TOC

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

 

Use this window to specify matching criteria for reconciling sales and purchasing documents with their respective payments.

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

You can set a combination of up to three rules for each round. Each rule can consider one of the parameters described below.

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 dropdown lists of the other rules.

End of the note.
Matching Criteria - Documents - 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 defined as 3. The due date of a specific invoice is 01.05.2007, and there is a payment for the exact amount with a posting date of 03.05.2007. The difference is two days. In this case reconciliation takes place.

End of the example.
Balance Amount

Selecting this parameter:

  • Lets you reconcile documents according to their totals

  • Displays the Matching Difference field

    Specify the amount (in local currency) that SAP Business One should tolerate as a legitimate difference between the amount below which a reconciliation takes place, and the amount above which a reconciliation does not take place. The smaller the amount defined in this field, the higher the level of accuracy of the reconciliation.

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.
Document Number

Select this parameter to reconcile documents and payments with identical document numbers.

Customer/Vendor Name

Select this parameter to reconcile documents while comparing the value set in the Name field in sales or purchasing documents with the value set in the bank statement line.

Selecting this field displays the Relate to XXX Last Characters field.

Specify a number to define a corresponding (lower/higher) level of accuracy of this parameter. SAP Business One checks the defined number of characters, starting from the right.

Note Note

Leaving this field empty prompts SAP Business One to look for a complete match of customer or vendor name.

End of the note.
BP Bank Code + Account

SAP Business One uses the values defined in the Bank Code and Account No. fields in the Business Partner Bank Accounts – Setup window.

To view the window, from the SAP Business One Main Menu, choose   Business Partners   Business Partner Master Data   Payment Terms   tab, and choose Choose from List (Choose from List) next to the Bank Country field.

Note Note

This match works only if both the Bank Code and the Account No. fields in the Business Partner Bank Accounts – Setup window are populated.

End of the note.

Note Note

In the Netherlands, the bank code is not sent, and so it is possible to search by bank account number only.

End of the note.
IBAN

Selecting this parameter prompts SAP Business One to reconcile bank statement rows with documents according to the value set in column BP IBAN of the Business Partner Details section in the bank statement, with documents posted to business partners with matching value set in the IBAN field in   Business Partners   Business Partner Master Data   Payment Terms   tab.

When selected, the field Relate to XXX Last Characters appears. Specify a number to define the level of accuracy of this parameter. Lower number indicates low level of accuracy, while high number indicates high level of accuracy. SAP Business One checks the defined number of characters starting from the right.

BP BIC/SWIFT Code + Bank Account

SAP Business One uses the values defined in the BIC/SWIFT Code and Account No. fields in the Business Partner Bank Accounts – Setup window.

To view the window, from the SAP Business One Main Menu, choose   Business Partners   Business Partner Master Data   Payment Terms   tab, and choose Choose from List (Choose from List) next to the Bank Country field.

Note Note

This match works only if both the BIC/SWIFT Code and the Account No. fields in the Business Partner Bank Accounts – Setup window are populated.

End of the note.

Note Note

In the Netherlands, the bank code is not sent, and so it is possible to search by bank account number only.

End of the note.
BP Reference No.

Select this parameter to reconcile documents while comparing the value in Customer Ref. No. or Vendor Ref. No. in sales and purchasing documents, with the value in the Reference field in payment documents.

Selecting this field displays the Relate to XXX Last Characters field. Specify a number to define a corresponding (low/high) level of accuracy of this parameter. SAP Business One checks the defined number of characters, starting from the right.

Note Note

If you leave this field empty, SAP Business One looks for a complete match of BP reference numbers.

End of the note.

Example Example

The Customer Ref. No. in A/R Invoice No. 100 is CR123456. The value set in Relate to XXX Last Characters is 1. SAP Business One looks for incoming payments whose reference number ends with the character 6. In this case, there may be many that comply with this criteria. If the value set in Relate to XXX Last Characters is 3, SAP Business One looks for all incoming payments whose reference number ends in 456. The number of incoming payments ending in 456 is much smaller than those ending in 6, raising the accuracy of this criteria.

End of the example.