SAP Knowledge Base Article - Public

3583520 - Invoices Not Automatically Cleared in Bank Statement Although Clearing Strategy Allows Automatic Clearing

Symptom

For customer account XYZ 4 open customer invoices exist over 61.20 EUR each. 
These shall be cleared in a bank statement ABC where 4 transactions over 61.20 EUR each refer to these 4 invoices.
Customer XYZ is identified via a Rule for Analyzing Memo Lines, Rule Type: 4 - Customer.
The applicable Clearing Strategy implies the option to 'Allow Automatic Clearing If No or Incorrect Reference Number'.
Hence you expect that all 4 invoices totalling 244.80 EUR are automatically cleared against all 4 bank statement transactions over the same total of 244.8 EUR.

All bank statement transactions, however, remain in Postprocessing Status 'Required'. Candidate invoices are not cleared but merely 4 on-account clearings are posted.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Open the Bank Statements view.
  3. Navigate to the relevant bank statement ABC and Edit.
  4. Select relevant bank statement transactions.
  5. Follow the Postprocessing: 'Required' link to access the relevant on-account clearing.

Cause

The bank statement clearing run processes every bank statement transaction sequentially and individually.

Here we have the situation that 4 bank statement transactions ABC/1, ABC/2, ABC/3, ABC/4 over 61.20 EUR relate to one customer account XYZ.

Customer Account XYZ is identified via a rule of Rule Type:'4 - Customer' - and consequently 4 on-account payments are created.

On the other side 4 corresponding customer invoices exist which are not identified via unique identifier, for example External Reference.

The option to 'Allow Automatic Clearing If No or Incorrect Reference Number' - takes effect when we see a 1:1 relationship between to due-times, here payment and customer invoice.

If only one customer invoice over 61.20 EUR would exist - an automatic clearing  would be created. Here, however, a single bank transaction over 61.20 would relate to 4 invoices over a total of 244.80 EUR. 

Resolution

In the here present scenario 2 alternatives apply if your aim is an automatic clearing.

  1. Employ the 'Receivables - Clearing Run'. All 4 On-Account Payments from Bank Statement would clear against all 4 corresponding invoices of similar character and same amount. - Or:
  2. Provision of External Receivable Reference in each bank statement transaction and clearing via Rule for Analyzing Memo Lines (Rule Type: 13 - Open Receivable External Reference).

Keywords

Rules for Analyzing Memo Lines  Invoice Clearing  Clearing Strategies , KBA , SRD-FIN-MOP , Payment Management , Problem

Product

SAP Business ByDesign all versions