Announcements
No record found.
Hi Experts,
I want to make a new cust aging Report can i make it as shown in above excel sheet.
Best Regards,
Shabir
Hi Shabir,
can you tell us why you want to make a new Cust aging report? Why can't you use the existing one? Anyway if you want to do that, you can look how the existing one is developed and use it as an example.
Is the main issue with the standard cust aging report related to the number of aging buckets that you need (10+) ?
Best regards,
Ludwig
The Expression i used in visual studio:
=Sum(iif(DateDiff("d", Fields!DueDate.Value, Parameters!AsDate.Value) >= 0 And DateDiff("d", Fields!DueDate.Value, Parameters!AsDate.Value) <= 30, Fields!AmountCur.Value, 0))
for all the column i used different expression the thing is how i will know the data this report is show accurate and correct.
Last thing Dr Ludwig, yes i want more than 10 columns as i shown in Report and post. In standard aging there is DP class, contract, and controller class but i just made this report simple on query base.
Shabir Ahmad
If the question is if the data on the report is correct or not, you have to compare it with the actual transactions. Personally, I wouldn't use that many columns. When it is already 90 days overdue, there is an issue anyway. What difference in action would there be when there is an amount shown in 241 to 270 or 271 to 300?
Hello Shabir,
I once had a similar requirement where a company needed 10 different aging buckets.
Yet rather than developing a new report, we exported the open transactions to excel in combination with the invoice date and due date.
Based on that, Excel was used doing the grouping into the different aging buckets.
That was quite easy because you need to export a limited number of data only and can save quite some time to develop a report.
Maybe that's an alternative compared to developing a new report?!
Hi André Arnaud de Calavon ,
Thanks for your reply, this requirement from our finance stuff to develop this kind of report that's i am trying.
If you haven't completed this requirement, I would suggest to extend the current report or create a copy and extend it. The temporary table is limited with a fixed number of columns for the report. I thought 6. You can create additional fields and check the logic where it checks for the 6 columns. In the past, one of the implementations I was involved needed to have 8 columns.
Hi André Arnaud de Calavon,
I have also the same requirement adding 7 columns more to the existing Report .
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 699
André Arnaud de Cal... 548 Super User 2026 Season 1
CP04-islander 301
