SAP Knowledge Base Article - Public

2044437 - Customer Statement And Report Aging List For Receivables Show Different Results For The Same Customer Invoice

Symptom

You create a Customer Statement and compare the result for Customer Invoice XXX to the result of the Report Aging List for Receivables.
The results are different and you suspect that this is a system error.

Reproducing the Issue

  1. Open Receivables Work Center
  2. Go to Customers
  3. Navigate to Balance Confirmation
  4. Select Balance Confirmation XXX
  5. Click on Preview - Print

You see that Customer Invoice YYY is being shown under header 30 day*

* This is only one example, the same applies to the fields Current, 30 day, 60 day, 90 day, 120 day

 

  1. Open Receivables Work Center
  2. Go to Reports - List and select the Report Aging List for Receivables
  3. Enter the key date of the Customer Statment as Cut-Off Date
  4. Enter the Customer ID
  5. Run the Report
  6. Move the fields Due Date, Proposed Posting Date and Customer Invoice ID from Not Currently Shown to Rows

You see that Customer Invoice YYY is shown as Not Due Amount

Cause

The Customer Statement and the Report Aging List for Receivables follow different logics.

 

Logic for Customer Statement:

The logic takes the  document date as the reference date and substracts it from the key date.
(This is the date which is shown in column Date in the PDF File Customer Statement.)
If the difference is >= 0 and <= 29, it adds the amount to the value under the column Current.
If the difference is >=30 and <= 59, it adds the amount to the value under the column 30 Day.
If the difference is >=60 and <= 89, it adds the amount to the value under the column 60 Day.
If the difference is >=90 and <= 119, it adds the amount to the value under the column 90 Day.
If the difference is >=120, it adds the amount to the value under the column 120 Day.

 

Logic for Report Aging List for Receivables:

The periods are calculated from the specified Cut-Off Date.
In the default display, the period structure is as follows:
1st Due Period in Days: 30
2nd Due Period in Days: 60
3rd Due Period in Days: 90
4th Due Period in Days: 120

This means, for example, that period 2 displays the overdue Receivables with a Due Date between 31 and 60 days in the past, regardless of whether they are cleared on the current date.

These are the default values and can be changed.

Resolution

The System Behaviour is correct.

Keywords

KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To

Product

SAP Business ByDesign all versions