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.
David are you using an add-on? Your screen is not standard BC
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.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,302 Most Valuable Professional
nmaenpaa 101,156