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 / Microsoft Dynamics GP (Archived) / Aging (Receivables)
Microsoft Dynamics GP (Archived)

Aging (Receivables)

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I'm using GP for the first time and I have a lot of questions, but right now I need to do an Aging ONLY for 2015. I went to Sales/Reports/Trial Balance w/Options. I put 1/01/15-12/31/15 as a range and it's showing 2016 invoices. Am I missing something here?

Thanks,

Awilda

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    You need to run the Historical Aged Trail Balance report if you want to an aging from a prior period.

  • Community Member Profile Picture
    Community Member on at

    Thank you for your quick response. One more question I need to use the Historical even when 2015 is open? I'm trying to close it.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    The Historical Aged Trail Balance( aka HATB) is date sensitive and is to be used for all aging reports for prior periods. It is irrelevant to this report as to whether or not the prior year or years are closed. It will build temporary tables and then report off these tables. As your data grows this report can put quite a drag on your server so run with caution, especially if your users start to complain about a sluggish response.

  • Suggested answer
    Justin Sutton Profile Picture
    Justin Sutton Microsoft Employee on at

    Hello Awilda,

    Welcome to Great Plains!

    You can use the Historical Aged Trial Balance at any time. This report will show you the results for a specific date. The Aged Trail Balance only shows results as of right now.

    Please let me know if you have any additional questions on this.

     

    Justin Sutton

    ------------------------------------------------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------------------------------------------------

    **This posting is provided 'AS IS' with no warranties and confers no rights.**

  • Community Member Profile Picture
    Community Member on at

    Thank you, but I still having issues with this. I went to Sales/Reports/Trial Balance/Historical Aged Trial Balance, but there are some options and I believed that someone put them there. Monthly AR, Monthly BDS and Todays Historical.  I don't know what's the right one.  I choose Todays Historical for 2015 and the report is in a Summary. Any thoughts?

  • Community Member Profile Picture
    Community Member on at

    Thank you! How do I get this report?

  • Community Member Profile Picture
    Community Member on at

    Thank you guys! I did it!

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans