Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Is there a way to modify aging buckets on Historical Aged Trial Balance, based on Payment Terms? (AR/Sales)

Posted on by 235

Our Historical Aged Trial Balance ages amounts based on days from invoice date:  

0-30 days

31-60 days

61-90

91 and over

Total

However, not all of our customers have 30 day terms.  Some have 35, 45, and even 60 day terms.  I would like the aging to be based on the terms, so that the aging buckets reflect the current or past due status of the invoice, not how many days old it is. 

Current

1-30 Days Past Due

31-60 Days Past Due

61+ Days Past Due

Total

Is there somewhere that I can change this? 

Thank you.

Categories:
  • PattiK323 Profile Picture
    PattiK323 235 on at
    RE: Is there a way to modify aging buckets on Historical Aged Trial Balance, based on Payment Terms? (AR/Sales)

    Thank you. But, I actually found my answer right after I posted the question and thought I deleted the forum question.  All you need to is going into Tools>Setup>Sales>Receivables and change Aging Periods from Document Date to Due Date.Screenshot-2023_2D00_03_2D00_10-122856.png

  • DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Is there a way to modify aging buckets on Historical Aged Trial Balance, based on Payment Terms? (AR/Sales)

    hi

    Yes, you can change the aging periods in Dynamics GP to reflect the terms on the customer record.

    To do this, go to the 'Sales' module and select 'Aging' from the Reports menu. In the 'Aging Periods' window, you can adjust the aging periods to match the customer terms.

    For example, if you have a customer with 35 day terms, you can add an additional aging period for 31-35 days past due.

    Once you have adjusted the aging periods, you can run the Historical Aged Trial Balance report and the aging buckets will reflect the current or past due status of the invoice based on the customer terms.

    Daniele

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans