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

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....
pstreAsked:
Who is Participating?
 
Victoria YudinConnect With a Mentor Owner / Dynamics GP ConsultantCommented:
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.
0
 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
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.
0
 
pstreAuthor Commented:
Thank you!!  That helps!!
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
pstreAuthor Commented:
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...
0
 
pstreAuthor Commented:
Victoria, you rock:)
0
 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Awww - thanks :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.