SAP Knowledge Base Article - Public

2944006 - Payment Statistics Report Shows Wrong Average Number of Days Until Due Date

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

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Open Payment Statistics - Customer report.
  4. Execute the report for a given customer ID and posting period.

The report shows and unexpected Average Number of Days until Due Date.

Cause

The Average Number of Days until 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

Product

SAP Business ByDesign all versions