Customer ageing on balance confirmation

[SAPSupport]

Dear All,

We're encountering issues with incorrect ageing on our Balance Confirmation Run statements, as shown in the attached samples. Specifically, when a month has 31 days, transactions dated the 1st are being incorrectly aged as 30 days instead of being reflected in the current period. Although the system uses a 30-day cycle for ageing, the Age Analysis report ages the transactions correctly. We're seeking a solution to align the ageing on the Balance Confirmation Run with the actual period, rather than the 30-day cycle.

Thank you.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear All,

Currently, the system uses the following logic for the Customer Statements:

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.

Refer to the KBA 2044437 - Customer Statement And Report Aging List For Receivables Show Different Results For The Same Customer Invoice https://me.sap.com/notes/2044437 for additional details, please.

If you would like to request a system improvement, consider to create an Idea in our Influence Channel (https://influence.sap.com/sap/ino/#/campaign/886 ), please.

Requests need 20 votes of different customers/partners to qualify for review. Reviews will happen on a regular basis twice a year, with the results being communicated in the corresponding review blog post. The ideas can be voted by other customers and partners and the most voted ones might be collected to the product backlog for future versions.

Thank you.

Regards,
Anderson
SAP Support