SAP Knowledge Base Article - Public

2622503 - Not Due Amount in the Aging List for Receivables by Document Date

Symptom

You ran the Aging List for Receivables by Document Date and noticed that for a certain invoice, even though it is due (as per Document Date) and displayed in one of the due ranges (e.g. 1 - 30 Days) the amount is also displayed in the Not Due Amount key figure. Hence, you are not sure if the amount is due or not.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to Receivables work center.
  2. Go to Lists view.
  3. Open the Aging List for Receivables by Document Date
  4. Fill in the required selection parameters.
  5. Bring the Customer Invoice ID, Document Date and Due Date as characteristics in the report.

You notice that for a given invoice, the corresponding amount is shown under a due range, on the Overdue Amount key figure as well as in the Not Due Amount key figure.

The expectation is that if an invoice is overdue, the amount is not displayed as Not Due Amount. The backwards is also true.

Cause

The report you are using is the Aging List based on the Document Date. This report considers the document date in comparison with the Cut Off Date of the selection parameters in order to display the invoice in an overdue range (e.g. 1 - 30 Days) and set the Overdue Amount. Nevertheless, the Not Due Date key figure is based on the Due Date. Therefore, if you have a document date on 01.03.2018, due date on 15.03.2018 but a cut-off date in the report as 08.03.2018, you'll see the document's amount in both the Overdue Amount due to document date and also on the Not Due Amount because of the Due Date.

Resolution

This is the designed system behavior.

Note that in the Aging List for Receivables (not by Document Date) both key figures depend on the Due Date only.

Keywords

Aging List. Payables. Receivables. Due Date. Overdue Amount. Not Due. , KBA , SRD-FIN-GLO-REP , GLO - Statutory Reporting , How To

Product

SAP Business ByDesign all versions