Skip to Content
0
Former Member
Jul 19, 2009 at 07:08 AM

SBO Aging Report characteristic

17 Views

Dear Experts,

I had tried to create a Crystal Report that mimicks the SBO's aging report. I got the Grand Total for the Aging Amount correct... however I got the Sub Total for the Aging Amount in the duration of 0-30days, 31to60days, 61-90days..etc wrong.

For Eg.

SBO Aging Report shows:

0 - 30 days 31- 60 days 61- 90 days 91- 120 days Over 120 days Total

SGD 0.00 SGD 1000.00 SGD 1500.00 SGD 2000.00 SGD 500.00 SGD 5000.00

My Aging Report shows:

0 - 30 days 31- 60 days 61- 90 days 91- 120 days Over 120 days Total

SGD 0.00 SGD 500.00 SGD 2000.00 SGD 2000.00 SGD 500.00 SGD 5000.00

I have already maDe my Crystal Report aging amount filter by aging duration as 0-30days, 31-60 days... etc but I still get the above incorrect sum allocation as compared to the System's aging sum allocation.

Can anyone please help advice on this?

Much Thanks!

Warmest Regards,

Chinho