SAP Knowledge Base Article - Public

3780661 - Missing Open Item in Customer Account

Symptom

  • A bank credit advice shows an open payment amount.
  • The remaining amount can be seen on payment monitor, but when navigating to the customer account or creating a new bank payment advice, the expected payment item is not visible.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the Receivables work center.
  2. Go to the Customer Accounts view.
  3. View the relevant customer account.
  4. In Open Items, search for the related bank credit advice or payment reference; the expected payment item is not found even though the bank credit advice shows a remaining amount in the Payment Monitor.

Cause

The remaining amount was cleared by a subsequent clearing document posted after the bank credit advice was created, so the Payment Monitor still shows a remaining amount while the customer account item is already fully cleared.

To verify this:

  1. Go to Payment Management work center.
  2. Open Payment Monitor view and locate the bank credit advice; note the displayed remaining amount and the timestamps.
  3. Open Receivables work center and view Customer Accounts.
  4. Navigate to Open Item and select All Items and search by the related payment reference.
  5. Notice that clearing documents posted after the bank credit advice creation have fully cleared the amount.

Resolution

System is working as expected.

Keywords

bank credit advice, remaining amount, payment monitor, missing payment item, open items, customer account, clearing document, cleared item not visible, payment advice, cash flow, reconciliation, liquidity management , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem

Product

SAP Business ByDesign all versions