Matching criteria are rules that enable automatic reconciliations in SAP Business One, as part of bank statement processing.
These matching criteria are based on the posting methods specified in the Posting Method column of the Internal Bank Operation Codes window (Bank Statement Details window.
) or in the bank statement row of theDocuments - matching criteria to be used when the posting method specified is Business Partner from/to Bank Account for reconciling:
Sales – A/R documents, such as A/R invoices issued to customers and the respective incoming payments
Purchasing – A/P documents, such as A/P invoices received from vendors and the respective outgoing payments
BP Journal Entries – matching criteria to be used when the posting method specified is Business Partner from/to Bank Account. Since journal entries have different matching parameters from the matching parameters of sales and purchasing documents, there is a separate set of matching criteria for journal entries.
Interim Account – matching criteria to be used for automatic internal reconciliation of the G/L bank interim account (defined in
column). These matching criteria are used when the selected posting method is Bank Interim Account from/to Bank Account.External Reconciliation – matching criteria to be used for performing automatic external reconciliation, when the specified posting method is External Reconciliation.
Matching criteria consist of three successive rounds. During automatic reconciliation, SAP Business One first reconciles the matched transactions according to the rules defined in round 1; then the transactions that were not compliant with round 1 but comply with round 2; and finally the transactions that comply with the rules defined in round 3 only.
Although it is possible to define three rounds for the matching criteria, you can specify only one or two if required.
Note
Since there is a dependency between the three rounds (round 2 is applied only after round 1 has been applied, and round 3 is applied only after rounds 1 and 2), only the following combinations of rounds are available:
Round 1 + round 2 + round 3
Round 1 + round 2
Round 1
The following combinations are disabled:
Round 1 + round 3
Round 2 + round 3
Round 2
Round 3