1,750
I would like to include on the AP Historical Aged TB Report, additional credit days ( 91 – 120 Days and 121 Days and over, etc)
Does anyone knows how this is done?
Please let me know.
Thank you,
*This post is locked for comments
The report, by default, just lists the first 4 ageing buckets. If you have more than 4 ageing buckes (and in your case you do), you will need to add each of these to the report using the report writer. Open the report in report writer, double click one of the ageing fields to find ot what it is called and what table it is in. Find this field in the report resources and drag it out onto the report. When you drop the field, you willbe asked for a sequence number, for the 5th ageing bucket type in '5' and so on.
You will need to reduce the length of the existing ageing bucket fields, so that you have room for the new buckets.
Also, the sae fields are used to sum at thebottom of the report, but their properties are set to 'sum' rather than data.
Hello,
I assume that you have Ageing for 91-20 and 121 Day etc in your setup. Print Report-->Clicked on Modified , For Detail Historical Aged Trial Balance report Aging Bucket Field name is : End Amount-Aging Period on PM Aged Trial Balance table, drag and drop field in report area and give the Next Index No. in your case it may be 5, 6, 7 .
Hope above solution will help you to resolve your problem.
Thanks
Sandip Jadhav
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (