SAP Knowledge Base Article - Public

1742927 - Bank Statement Clearing - Rules for Analyzing Memo Lines

Symptom

Upon uploading an automatic bank statement no automatic clearings are created.

Although you defined matching rules for External Transaction Codes and Payment Methods in 'Business Configuration / Automatically Generated Bank Statements / Edit import formats for automatic generated bank statements' -Post processing is needed for all transactions lines contained in the affected bank statement.

In the Bank Statement all receivable/payable-transactions are referenced in the respective memo lines.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Navigate to the uploaded bank statement via Bank Statements view.
  3. Go to the column Postprocessing and follow the link Required.
  4. You access the created payment allocation.

Cause

Every bank statement transaction consists of a block describing the values of this transaction.

Following this, a block is usually reserved for memo lines describing other specifics of this transaction, for example: Business Partner, External Document ID of payable/receivable item, note to payee etc.

There are no (or only insufficiently effective) rules set-up to analyze bank statement memo lines. These are crucial for an automatic clearing of open receivables/payables item. By setting up rules for analyzing memo lines the system should be enabled to automatically clear open items at a sufficient rate.

Resolution

  1. Go to the Business Configuration work center.
  2. Go to Overview view.
  3. Open the activity Global Settings for Payment.
  4. Here you find the option Create and edit rules for analyzing memo lines (this is also directly accessible from the payment allocation in status 'In Preparation' resulting from an automatic bank statement.)
  5. Based on the Rule Type (for example, Open Receivable Document ID) you can define rules to filter candidate documents for clearing based on the business needs of a company.

Keywords

 automatic bank statement; upload; memo line; rules , KBA , clearing , bank statement , rules for analyzing memo lines , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions