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

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 it is a system error.

SAP Business ByDesign

1. Go to Receivables Work Center > Balance Confirmation view
2. Select Balance Confirmation XXX
3. Click 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 Statement 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

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 subtracts 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.

The System Behavior is correct.

balance confirmation, receivables, customer statement , KBA , SRD-FIN-ACR , Receivables , How To