Symptom
The Aging List for Payables report is showing paid invoices for a given key date.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to the Payables work center.
- Go to the Lists view.
- Open the report Aging List for Payables.
- 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 cancellation 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 cancellation. Clearing. Aging Report. , KBA , SRD-FIN-ACP , Payables , How To