Symptom
You are executing the Aging List for Receivables by Document Date report and you have observed that the Due Days are calculated based on the Due Date. You are expecting the Due Days should be calculated based on Document Date. Otherwise, there is no difference between Aging List for Receivables and Aging List for Receivables by Document Date.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics work center.
- Click on Design Reports view.
- Search for the Report - Aging List for Receivables by Document Date.
- Execute the Report.
- You can find the Due Days column. The number of days is calculated based on Due Date.
Cause
This Aging List for Receivables by Document Date report displays the data for each customer based on overdue receivables according to a specific Document Date and aging period. However, the logic for Aging List for Receivables by Document Date report and Aging List for Receivables report is same for the calculation of Due Days. The Due Days column display the number of Days based the document Due Date.
Note: The same logic applies to Aging List for Payables & Aging List for Payables by Document Date reports as well.
Resolution
For the report Aging List for Receivables by Document Date its recommended to create new Keyfigure to calculate overdue days based on document date.
Keywords
Aging List for Receivables by Document Date, Aging List for Receivables, Due Days, Aging List for Payables, Aging List for Payables by Document Date , KBA , aging list for receivables by document d , aging list for receivables , due days , aging list for payables , aging list for payables by document date , SRD-FIN-ANA-DUE , Due Management (Reporting) , Problem