Symptom
You are running the Aging List for Receivables report, nevertheless the expected amount is not displayed in the first overdue range [1-30]. Instead, it is displayed as outstanding amount.
Reproducing the Issue
-
Go to Receivables work center.
- Go to Lists view.
- Open the Aging List for Receivables.
- Specify the selection criteria. For illustration purposes, consider Cut Off Date as 31.10.2017
- Run the report.
- Add the Due Date characteristic to the report's row.
You see that the entries with Due Date equal to the Cut Off Date, the related amount is not displayed in the 1st Due Period range. Instead, the amount is shown as Outstanding.
Cause
The aging list report only show in the ranges the amounts that are overdue. If you choose cut off date as 31.10.2017 and the due date of an item is also on 31.10.2017, the due date was not elapsed yet, hence item was not overdue.
The 1st Due Period displays the overdue amount with a due date between 1 and 30 days in the past.
In this example, an item with due date on 30.10.2017 then would be displayed in the first due range.
Resolution
This is the designed system behavior. You may also consider using the Forecast List for Receivables for due items.
Keywords
KBA , SRD-FIN-ACR , Receivables , How To