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 it is a system error.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Receivables Work Center > Balance Confirmation view
- Select Balance Confirmation XXX
- 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
- Open Receivables Work Center
- Go to Reports - List and select the Report Aging List for Receivables
- Enter the key date of the Customer Statement as Cut-Off Date
- Enter the Customer ID
- Run the Report
- 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 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.
Resolution
The System Behavior is correct.
Keywords
balance confirmation, receivables, customer statement , KBA , SRD-FIN-ACR , Receivables , How To