Show TOC

Object documentationMatching Criteria Locate this document in the navigation structure

 

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 (  Administration   Setup   Banking   Bank Statement Processing   Internal Bank Operation Codes  ) or in the bank statement row of the Bank Statement Details window.

  • Documents - 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   Administration   Setup   Banking   House Bank Accounts – Setup   G/L Interim Account   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 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

End of the note.