Symptom
You are running the Payment Statistics - Customer report and noticed that the keyfigure Average Number of Days Until Due Date does not calculate the expected average.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Open Payment Statistics - Customer report.
- Execute the report for a given customer ID and posting period.
The report shows and unexpected Average Number of Days Until Net Due Date.
Cause
The Average Number of Days Until Net Due Date key figure picks the maximum value of the difference between invoice and payment date for a given customer account.
Resolution
To get the exact average, you have to add to the report the Customer Invoice ID characteristic to the rows. Once this characteristic is added, the average is calculated.
Keywords
Payment Statistics, Receivables, Payables, Clearing. , KBA , AP-ACC , Business ByDesign: Financial Accounting , How To