SAP Knowledge Base Article - Public

3319719 - Due Days in Aging List for Receivables by Document Date Report

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

  1. Go to Business Analytics work center. 
  2. Click on Design Reports view. 
  3. Search for the Report - Aging List for Receivables by Document Date.
  4. Execute the Report.
  5. 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

Product

SAP Business ByDesign all versions