SAP Knowledge Base Article - Public

2041377 - How To Change The Customer ID/Supplier ID On A Bank Statement In Status Posted

Symptom

You have posted a Bank Statement and want to change the Customer/Supplier ID for one particular item.

Reproducing the Issue

  1. Open the Liquidity Management workcenter.
  2. Navigate to Bank Statements.
  3. Select the respective Bank Statement in Status Posted.
  4. Click on View.
  5. Go to Tab Transactions.
  6. Item 123 (where 123 stands for a transaction item) has Customer/Supplier ID XXX (where XXX represents the ID of the customer/supplier).

Cause

To change the Customer/Supplier ID it is not necessary to change the Bank Statement.
The Data can be corrected via the Payment Allocation.

Resolution

  1. Open the Liquidity Management workcenter.
  2. Navigate to Bank Statements.
  3. Select the respective Bank Statement.
  4. Click on the Document Flow tab.

You see that the Payment Allocation ABC (where ABC stands for the Payment Allocation ID) is in Status Posted.

  1. Open the Payment Management workcenter.
  2. Go to Payment Allocations.
  3. Select Payment Allocation ABC.
  4. Click Reverse.

The Message Payment Allocation reversed successfully appears.
Payment Allocation ABC is now is Status Canceled.
A new Payment Allocation DEF for the respective Bank Statement has automatically been created in the ByDesign System.

  1. Open Payment Management workcenter.
  2. Go to Payment Allocations.
  3. Select Show In Preparation Payment Allocation and search for the newly created Payment Allocation DEF.
  4. Click Edit.
  5. Add/Change the Customer/Supplier ID.
  6. Click Actions - Create Proposal.
  7. Confirm with Save and Post.

The Message Payment Allocation posted successfully appears.

If you check the Bank Statement now you see that the initial customer/supplier ID XXX was changed to the new customer/ supplier for Item 123.

Keywords

KBA , bank statement , payment allocation , supplier id , customer id , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions