2616780 - Past Cleared Invoices are Still Shown in the Aging Report

SAP Knowledge Base Article - Public

2616780 - Past Cleared Invoices are Still Shown in the Aging Report

Symptom

The Aging List for Payables report is showing paid invoices for a given key date.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to Payables work center.
  2. Go to Lists view.
  3. Open the report Aging List for Payables.
  4. Specify the parameters as required.

You see an outstanding amount, which belongs to an invoice and payment. Nevertheless, the invoice was suppose to be cleared at that point in time (Key Date).

Cause

There are some scenarios that lead to this behavior.

Example:

You have the invoice open and paid with an outgoing check with posting date on 01.11.2017. After that, the check was voided on 15.01.2018 and a replacement check was automatically created, which has then been reversed with cancelation on 15.01.0218.

On 01.02.2018 the invoice is cleared again.

Therefore, when checking the Aging List for Payables with key date on 31.12.2017, you expect the invoice and payment to not be shown, since it would had been cleared by the first check.

The Aging list checks the clearing date of the document and displays on the report based on this date. The invoice got cleared again in clearing on 01.02.2018, hence for any date before this the invoice would be shown on the report irrespective of any older clearings that it might have been initially locked in.

Resolution

This is the designed behavior of the report.

Keywords

Aging List for Payables. Payment Cancelation. Clearing. Aging Report. , KBA , SRD-FIN-ACP , Payables , Problem

Product

SAP Business ByDesign all versions