Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Historical Aged Debts

Historical Aged Debts

Historical Aged Debts


I've recently inherited a Great Plains system following a company merger and have basically been left in the lurch with it. I've figured out some, but I'm trying to recreate an aged debtors report as at a specific period.
For example we are currently in period 1 in 2013, but I need to run an aged debt from period 8 in 2012.
Is this possible and how would I go about it?

Please treat me as a newbie to GP in your response.


RE: Historical Aged Debts


It sounds like you are looking for the Receivables Historical Aged Trial Balance (HATB). Navigate to Reports | Sales | Trial Balance and select Historical Aged Trial Balance from the drop down at the top left. Click New at the bottom left, then fill in the options you want. If you click F1 or the Help Button you can then choose Fields and it will explain every option in detail. Here is a link to a screenshot with the typical options: http://victoriayudin.files.wordpress.com/2013/04/h.... Once you have selected all your options, click the Print at the top of the window.

Victoria Yudin
Dynamics GP MVP 2005 - 2013
Use Crystal Reports and SSRS with GP:
blog: http://victoriayudin.com

RE: Historical Aged Debts

That worked, very slow and formatted in a ridiculous way, but seems to be the norm for Great Plains. Thank you, I'd have never found that by myself.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close