SAP Knowledge Base Article - Public

3541639 - No Automatic Clearing in Bank Statement Despite Working Rules for Analyzing Memo Lines due to Percentage Clearing Difference Threshold.

Symptom

  • You have defined working Rules for Analyzing Memo Lines identifying payment relevant payables or receivables (for example, Rule Type: 2 - Open Receivable Document ID).
  • Based on provided memo line content open candidate documents are identified unambiguously.
  • Additionally Clearing Strategies have been defined accommodating an automatic clearing for thresholds defined for overpayment or underpayment. 
  • After uploading and posting affected bank statement transactions candidate items are identified, however appear as not cleared (Postprocessing: Required). 

Environment

SAP Business ByDesign

Reproducing the Issue

Affected Payment Allocations can be accessed via:

  1. In the Liquidity Management work center go to Bank Statement view.
  2. Select the relevant posted bank statement transaction.
  3. In the column Postprocessing, follow the link Required.

Alternatively you can find affected Payment Allocations in the Payment Management work center under Payment Allocation view.
Select the relevant open payment allocation of type Bank Statement.

Cause

When a payment difference crosses a percentage threshold of 5% in either direction (overpayment as well as underpayment) a manual clearing is required.
This definition has been introduced as last safeguard for high-volume automatic clearings for payment-relevant documents (for example: customer invoices) when Rules for Analyzing Memo Lines are applied in bank statement processing. 

This definition applies irrespective of and overrules made definitions for Clearing Strategies.

  1. Go to Business Configuration work center.
  2. Edit Clearing Strategies activity and Maintain clearing strategies.
  3. Settings defined for: Payment Tolerance Types, Tolerance for Over Payment, Manual Clearing Tasks.

The 5% threshold can be easily crossed with involved clearing amounts < 1.00 MU (Monetary Unit) where for currency-specific decimal settings applicable amount modifications are limited.

The following table illustrates the application of the 5% Clearing threshold for overpayments as well as underpayments.
Here it is assumed that Rules for Analyzing Memo Lines as well as Clearing Strategies are set up accurately and effectively.

  % Payment DifferenceResult 
    
  Overpayment:  
    
Invoice:€0.10  
Payment in Bank Statement:€0.1110%No automatic Clearing.
    
Invoice:€1.00  
Payment in Bank Statement:€1.066%No automatic Clearing.
    
Invoice:€1.00  
Payment in Bank Statement:€1.055%Automatic Clearing.
    
Invoice:€1.00  
Payment in Bank Statement:€1.044%Automatic Clearing
    
  Underpayment: 
    
Invoice:€1.00  
Payment in Bank Statement:€0.96-4%Automatic Clearing
    
    
Invoice:€1.00  
Payment in Bank Statement:€0.95-5%No automatic Clearing.

Resolution

The system works as designed. 
In case you are seeking a change in functionality or adoption of a new feature we ask to submit your idea in our Influence Platform.
Here requests for enhancements are introduced and evaluated by other customers and our product team.

Keywords

automatic clearing, bank statement, payment difference, payment allocation, clearing strategies , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem

Product

SAP Business ByDesign all versions