SAP Knowledge Base Article - Public

1739844 - Payment Allocation from Bank Statements when employing Payment Run

Symptom

You pay open invoices employing the Payment Run, e.g.:  in Work Center Payables. Subsequently you enter bank statements reflecting those payments. This document describes how to allocate those transactions in the resulting payment allocation.

Environment

SAP Business ByDesign

Reproducing the Issue

Payment allocations are created after a bank statement is entered either manually or automatically and posted.
Those can be accessed either via the bank statement itself or in the work center Payment Management.

Liquidity Management:

  1. Go to work center Payment Management.
  2. Select the relevant posted bank statement.
  3. In the column Postprocessing, follow the link Required.

Payment Management:

  1. Go to work center Payment Management.
  2. Navigate to view Payment Allocation.
  3. Select the relevant payment allocation of type 'Bank Statement'.

Cause

In case the invoices have been paid already (e.g.: by executing a payment run and sending a bank file) it has to be avoided to generate a new payment when posting the bank statement. In this case transactions in bank statement lines rather have to be allocated to the corresponding payments already entered in the system. This can be done once a payment generated by a payment run is in status 'In Transfer'. There are several ways to achieve a proper payment allocation depending on the applied business process.

Resolution

Payment Allocation while entering a manual bank statement.

In case bank statements are entered manually you have the possibility to allocate existing payments during the entering process. You can however also access and perform the payment allocation after the relevant statement lines are entered or the statement is posted.

  1. Go to work center Liquidity Management, view Bank Statements.
  2. Via the button New you have the possibility to enter a new bank statement.
  3. In step 2 of the creation wizard you have the option to select relevant existing payments from the list All Not Confirmed Items in Transit.
  4. In step 3 Create and Edit Items those transactions are transferred in the bank statement line for editing.
  5. In case the bank transaction is equal to the selected payment no further post-processing is required and the affected payment will be in status 'confirmed'.

In case automatic bank statements are posted and no automatic payment allocation has been performed you can either enter the payment allocation via the bank statement line itself or in work center Payment Management. The same applies for manual bank statements where a payment allocation hasn't already been performed as outlined above.

  1. Upon entering the payment allocation the tab Payment Assignment is opened by default.
  2. Depending on the specifics of the transaction existing candidate payments in status 'in Transfer' are shown in the grid according to the applied payment method specified in the choose-from-list.
  3. Select the relevant payment and drag it in the grid below using the arrow. (You can un-select the payment by using the opposite arrow).
  4. You can post the payment allocation when the Open Amount is zero.

If necessary you also have the possibility to allocate payment differences or even the entire amount not as Payment Assignment but as payment on account via the tab Customer/Supplier or other allocation via the tabs Bank Charges and Interests or Other Allocation.

 

 

See Also

Kontoauszug; Zahlung; Zahlungszuordnung; Lastschrift; direct debit; payment; payment allocation; bank statement.

Keywords

KBA , payment run , bank statement , payment allocation , AP-PAY , Payment Processing , How To

Product

SAP Business ByDesign all versions