GP 2010 -- Historical Aged Trial Balance vs Aged Trial Balance with Options.

Posted on 2013-12-05
Last Modified: 2013-12-07
We are really struggling with determining what the difference is between the Historical Aged Trial Balance and the Aged Trial BAlance with Options.  We get the same information from both....
Question by:pstre
  • 3
  • 3
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39699537
It's not exactly the answer to your question, but the way I always explain these is:
The Historical Aged Trial Balance can do everything the others can and more. To make it simpler for users, I recommend always using the Historical Aged Trial Balance and pretending like the others don't exist. :-)

The main difference between the Historical Aged Trial Balance (HATB) and the others is that the HATB will look at transactions in both open and historical tables and allow you to get the information as of a particular date. The others will only look at open tables and, thus, only a subset of your data.

Author Comment

ID: 39699908
Thank you!!  That helps!!

Author Comment

ID: 39702091
What is the difference in open and historical tables?  I know this seems like a silly question but I really don't know what the difference is...
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

LVL 18

Accepted Solution

Victoria Yudin earned 500 total points
ID: 39702174
You know how when you look at the Receivables Transaction Inquiry - Customer window, there is an Origin column at the far left? It will say WORK, OPEN or HIST? Those are stored in 3 different sets of tables. The HATB looks at all 3 sets of tables. The other aging reports only look at WORK and OPEN. Although typically WORK tables are not included in aging reports, since the transactions are not posted yet.

Author Closing Comment

ID: 39702381
Victoria, you rock:)
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39702797
Awww - thanks :-)

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
This collection of functions covers all the normal rounding methods of just about any numeric value.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now