SAP Knowledge Base Article - Public

2908893 - Incoming Bank Payment Posted on Account

Symptom

Incoming bank payment is directly allocated to customer/supplier account.

You expected the incoming bank statement to confirm an already In Transfer payment in the Payment Monitor.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements  view.
  3. Search for Bank statement ABC (ABC is the bank statement ID) and select it.

The Post Processing status is Required.

  1. Click View.

Generated: Automatically.

File ID: DEF (DEF is the inbound file ID).

Bank Statement Format: for example MT940 DE.

  1. Navigate to the Transactions tab.
  2. For all Items the Payment Method is Incoming Bank Transfer.
  3. Select Item ID ABC-NN (ABC-NN is the bank statement item ID).
  4. Click Required to open the clearing.

This opens the Clearing Overview ABC/NN (ABC/NN is the clearing overview ID).

The Clearing Status is Paid on Account.

The transaction amount is AA,AA (AA,AA is the exact transaction amount).

According to the Memo lines, the related Invoice is NOP (NOP is the invoice ID).

There is an open task: "Review and Clear Bank Statement ABC/NN."

  1. Click View All.

The status is Paid on Account.

  1. Opens the Manual Payment Clearing ABC/NN.
  2. Go back to the Bank statement item ABC/NN.
  3. For the Item ABC/NN, navigate to the Document Flow subtab.

The payment has a Payment Allocation HIJ (HIJ is the payment allocation ID).

  1. Click open the Paymetn Allocation HIJ and then View All.

Document ID:KLM (KLM is the payment/ document ID).

External Transaction Code: XYZ (XYZ is the external transaction code).

The Payment Allocation has been posted to the Customer Account.

  1. Go to the Customer Invoicing work center.
  2. Go to the Invoice Documents view.
  3. Search and select Invoice NOP.
  4. Click Edit, then View All.
  5. Navigate to the Document Flow tab.

The related Payment Order is QRS (QRS is the payment ID).

  1. Go to the Payment Monitor view.

There is a confirmed Payment with Document ID KLM and Post Processing Required status.

  1. Open PostProcessing Required to open the Clearing ABC/NN.
  2. Go back to the Payment Monitor view.
  3. Search and select the Payment Order QRS.

The status is In Transfer.

The Payment method is Incoming Direct Debit.

  1. Click Edit.

Payment Amount in Transaction Currency: AA,AA

Payment Medium Format Code: SEPA Direct Debit

The Memo Line contains invoice NOP.

You expected the incoming bank statement ID ABC/NN to directly confirm the Payment QRS for the invoice NOP. Instead, an account payment KLM was created and confirmed in the Payment Monitor.

Cause

Self-initiated payments, like incoming Direct Debit, are not intended to be posted against the Business Partner Account since the actual payments are expected to be recorded in the system. Instead, the bank transactions should be matched and allocated against those candidate payments in the Payment Allocation.

If the payment method is Incoming Direct Debit and there is a Payment with status In Transfer (with matching IBAN and transaction amount), the payment gets automatically confirmed.

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Search and select the Automatically Generated Bank Statements activity.
  4. Click Change Immediately.
  5. Click Edit import formats for automatic generated bank statements.
  6. Select Import Format MT940 DE.
  7. Navigate to the External transaction Codes section.
  8. Filter for External Transaction Code XYZ.

The description is SEPA direct debit deposit.

The Payment method is Payment Processing - Of Incoming Bank Transfer.

The payment method Incoming or Outgoing Bank Transfer would mean that the bank statement item has to be either assigned to an open invoice or paid on account.

You need to change the payment method to Payment Processing - Of Incoming Direct Debit.

Resolution

To solve the issue, change the payment method for the external transaction code XYZ of the import format for example MT940 DE.

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Search and select the Automatically Generated Bank Statements activity.
  4. Click Change Immediately.
  5. Click Edit import formats for automatic generated bank statements.
  6. Select Import Format MT940 DE.
  7. Navigate to the External transaction Codes section.
  8. Filter for External Transaction Code XYZ.
  9. The Payment method is Payment Processing - Of Incoming Bank Transfer.
  10. Change the payment method to Payment Processing - Of Incoming Direct Debit.
  11. Click Save.

If you leave the payment method blank, no automatic payment allocation would happen. The PostProcessing status of the bank statement would be Required and nothing would be allocated. The payment method would be other incoming methods in the payment allocation of the bank statement item.

Keywords

incoming bank payment; Paid on account; Akonto Zahlung; Eingehende Banküberwiesung; SEPA- Lastschrift; SEPA Direct Debit , KBA , SRD-FIN-MOP , Payment Management , How To

Product

SAP Business ByDesign all versions