Skip to Content
Actions

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

Aged Balance

This question is answered

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.

October 01, 2008 at 16:46 PM
0 Likes
Correct Answer
replied
October 01, 2008 at 16:46 PM

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 Likes 0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question

3 replies