web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Add Over 90 Day Bucket...
Small and medium business | Business Central, N...
Suggested Answer

Add Over 90 Day Bucket on A/R Aging by Due Date

(0) ShareShare
ReportReport
Posted on by Community Member

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. 

I have the same question (0)
  • Suggested answer
    David Wyke Profile Picture
    David Wyke 126 on at

    Hi Thardy, yes it should be possible. By setting the Aged Receivables parameters as shown below I will have have the following aging buckets:

    • Not Due
    • 1-30 Days
    • 31-60 Days
    • 61-90 Days
    • Before 90 Days i.e. 91 Days +

    AR-Settings.png

    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.
    AR-Report.png

    I hope this helps!

  • Community Member Profile Picture
    Community Member on at

    Hi David,

    It appears we do not have "Heading Type"

    pastedimage1648826134397v1.png

    Could this be a setting that we need to turn on? 

  • Dallefeld Profile Picture
    Dallefeld 229 User Group Leader on at

    David are you using an add-on? Your screen is not standard BC

  • David Wyke Profile Picture
    David Wyke 126 on at

    No, mine is a standard Microsoft CDX demo environment, version 19.5. It's a GB localisation.

  • David Wyke Profile Picture
    David Wyke 126 on at

    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?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,084 Super User 2026 Season 1 on at

    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.

    pastedimage1649039851889v1.png

    Hope this will help.

    Thanks.

    ZHU

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,946 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,177 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans