Share
ReportHi Experts,
I want to make a new cust aging Report can i make it as shown in above excel sheet.
Best Regards,
Shabir
You’re offline. This is a read only version of the page.
3,024
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 André Arnaud de Calavon,
I have also the same requirement adding 7 columns more to the existing Report .
Best Regards,
Shabir Ahmad
Hi Shabir,
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 ,
Thanks for your reply, this requirement from our finance stuff to develop this kind of report that's i am trying.
Best Regards,
Shabir Ahmad
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?!
Best regards,
Ludwig
Hi Shabir,
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?
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.
Best Regards,
Shabir Ahmad
Hi Shabir,
Is the main issue with the standard cust aging report related to the number of aging buckets that you need (10+) ?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (