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.

replied

Hi Victor,

You will have to create 3 formulas to get this :

Formula1

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

Then

amt3:=amt3+

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

You will get the values as you desired

Thanks,

Sastry

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