SAP Knowledge Base Article - Public

3562852 - Issue with automatic clearing of Bank Statement with Interpretation Algorithm 019 in SAP S/4HANA Cloud Public Edition

Symptom

  • When loading bank statements, outgoing payment transactions do not get automatically cleared with Interpretation algorithm "019" if more than one line is paid initially, even though the payment file reference number is in the note to payee.
  • In the Reprocess Bank Statement Items app , if the allocation is attempted again with processing instruction 0040 Data Medium Exchange, the expected open items are then correctly retrieved.

Environment

SAP S/4HANA Cloud Public Edition 

Reproducing the Issue

  1. Open the app Reprocess Bank Statement Items.
  2. Select bank statement item to be reprocessed.
  3. Try to allocate open item with processing instruction 0040 Data Medium Exchange.
  4. The expected open items are now selected.

Resolution

  1. Use interpretation algorithm 419 instead of 019 in the configuration of the external transactions. Refer Interpretation Algorithms to know about the interpretation algorithm 419.
  2. Or use the bank statement processing rules with processing instruction 0040 or 0045. Refer Overview on All Predelivered Processing Instructions and Manage Processing Rules - For Bank Statements.

Note: 

  • DME (data medium exchange) reference number can be a primary physical reference number or a secondary logical reference number.
  • Secondary logical reference number is calculated number which equals to DME reference number + 101, For Example - DME Ref number = 1000000000, Secondary logical reference number can be 1000000101, 1000000202, 1000000303 etc (Add multiples of 101 to the primary physical reference number).
  • In standard the values are filled as below:

    • Message Identification (paymentfilemsgidentification) field = primary physical reference number

    • Payment Information Identification (paytinformationidentification) field = Secondary logical reference number

    • End To End Identification (paymentendtoendidentification) field = primary physical or secondary logical reference number 

  • If the bank statement contains the single transactions for the individual invoices with the respective DME reference numbers and there are invoices with the same amount, then it will be difficult for the system to find the right payment document to process the bank statement item.
  • Recommended approach - All the items for a payment medium generated by the payment program are grouped by means of a DME (data medium exchange) reference number.

Keywords

SAP S/4HANA Cloud Public Edition, Finance, Financial Operations, Receivables Management, Accounts Receivable Accounting, Automatic Clearing, Bank Statement, Outgoing Payments, Posting Rule F004, Algorithm 019. , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions