Is there a way to add Over 90 day bucket on the A/R aging by Due date. When we run it by "trans date" transaction date it will display the over 90 day bucket. But when we run it by due date it only display Over 60.
Hi, just to add some info, I have confirmed this feature in both BC19.5 w1 and BC20.0 w1 versions. So I think this should not be a GB-specific Localization function. This may be a custom report that duplicates the original report.
Hope this will help.
Thanks.
ZHU
The field Heading Type alters the labels on my headers. I have two options 1) Date Interval - This shows the start and end day of each aging bucket period, 2) Number of Days - This shows the aging bucket in Not Due, 0-30 Days etc.
It's possibly a GB Localisation of the report so may not be available in the local version you are running however the report is in the standard object range (Report ID 120) and not a GB object ID. Can you confirm the Report ID for the report you are running?
No, mine is a standard Microsoft CDX demo environment, version 19.5. It's a GB localisation.
Hi David,
It appears we do not have "Heading Type"
Could this be a setting that we need to turn on?
Hi Thardy, yes it should be possible. By setting the Aged Receivables parameters as shown below I will have have the following aging buckets:
As you can see from the report preview below, I have the desired aging buckets when the report is executed by Due Date. I have chosen period length of 30D to have the buckets in 30 day periods.
I hope this helps!
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 (