Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Aged Balance

Dear all,

I've been starting to work on a Aged Balanced report for my manager, but I'm stuck on the algorythm to use to calculate and display relevant information.

Basically I would like to display for each customer account the potential "debt" for different periods (< 30 days, <> 90 days, > 90 days).

Has anyone already worked on such a report ? How did you do?

Thanks a lot.

Former Member

Hi Victor,

You will have to create 3 formulas to get this :


Numbervar amt1

If Currentdate - < 30 Then amt1:=amt1+ Formula2 Numbervar amt2 If Currentdate - >30 and

Currentdate - < 90 Then amt2:=amt2+ Formula3 Numbervar amt3 If Currentdate - < 30



Now you place these three fomulas in your report and goup by customer.

You will get the values as you desired



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question