SBO Aging Report characteristic

[Former Member]

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

[Former Member · Accepted solution]

Which date have you selected for aging? Comparing the detail records between two reports to see which records got different period with system record to find the reason.

Thanks,

Gordon

[Former Member · Accepted solution]

Dear Gordon,

Thank you for your reply.

I specified the report Aging date as 30/6/2009 and aging report based on Posting Date.

I have found a document posting date dated 1/April/2009. In my crystal report, this document is shown under the 31 - 60 days, but in the system report, this document is shown under 61-90 days.

Please help advice.

Warmest Regards,

Chinho

[Former Member · Accepted solution]

There is 31 days in May. So your calculation is wrong.