RE: aged and historical

[Charles Allen]

To reconcile AP to GL, you should use the historical aged trial balance. The
other aged trial balance reports do not give you the ability to go back in
time. Additionally, you can select to run the historical version using the GL
posting date instead of the document date.

If the report is as far off as you say, then it's not necessarily the report
having a problem. You need to make sure no transactions are being posted to
the AP control account outside of Purchasing. Make sure that Receiving
transactions are updating an accrued purchase account, not the AP account.

You need to determine what is wrong with the report. Are the balances
incorrect?

You need to go back in time to see if AP and GL ever matched.
--
Charles Allen, MVP

"kym" wrote:

> anyone there can tell me the difference between Aged payables and historical
> aged payables ?
> how am i supposed to reconcile my payables to GL ?
> I have tried both reports for different clients....but they never come up
> with the right figures even though i have used the correct age as of date.
> I had the same problem with receivables aged and historical Trial balance.
> most clients think that these two reports are buggy because they have done
> manual calculation for receivables or payables and the result was far away
> from historical aged trial balance.
>
> so can anyone tell me the golden rule for using these reports ?
>
> thanks
>
>
>
>
>
>
>

[Dukester]

what i would suggest is track the difference on a daily basis. if the
difference increases or decreases then do an audit-trail in the system to
find where is this happening. its easier to resolve things this way specially
if you don't know where the difference is coming from.
--
Microsoft Dynamics GP MVP
http://ddelprado.blogspot.com

[Victoria [MVP]]

Kym,

Just my 2 cents, but what you're saying is not typical in my personal
experience, nor in what my clients have experienced.

To reconcile to the GL you have to use the historical report. In fact, I
usually tell users to not even bother with the other one and always use the
historical report. And make sure when you're printing the historical report
that you choose to use the GL date. If everything is entered correctly,
this WILL match your GL. Of course there is always human error, import
issues, upgrade issues, etc., but I have been using GP for 14 years and
supporting clients on it for 8 years, and have not had a case where we could
not figure out where the difference came from. Typically it's one of 2
things:

1. Something was entered outside of the Payables or Receivables modules
directly against a control account.
2. When entering something in Payables or Receivables the control account
was changed (or another account was changed to the control account).

These can sometimes take time to find, especially if it's the 2nd one, but
the historical aged trial balance reports are pretty solid. Have you talked
to GP support about the problems you're finding to see if they can provide
some solutions in your specific cases?

--
Victoria Yudin
Dynamics GP MVP

"kym" <k...@gmail.com> wrote in message
news:eym9Gbcs...@TK2MSFTNGP03.phx.gbl...
> Thanks...but i think no one has addressed my problem till now.
> as i said before we have done ***manual calculation ***for receivables for
> one month and it was far away from the historical aged receivables report.
> I found some transactions appearing on the aged trial balance and others
> that appear on the historical aged trial balance for the same period using
> the same date.
> I have about 10 clients,none of them has accepted the results of those
> reports.
> personally i don't trust these two reports in payables and receivables,I
> wish that anyone could prove me along with these 10 clients wrong.
>
>
> "Dukester" <duke...@discussions.microsoft.com.> wrote in message
> news:1680ACAB-445D-46D5...@microsoft.com...

[Sally]

Victoria,I do agree with Kym...there is a confusion regarding theses two
reports...so could you tell us when does a transaction appear on the Aged
payables report and when does it appear on the historical aged trial
balance?becasue sometimes you can see the same transaction appearing on the
two reports.I am sure that you have been asked this kind of question by
your clients..

what are the conditions or parameters used to

"Victoria [MVP]" <vict...@flex-solutions.com> wrote in message
news:uVzRLHMt...@TK2MSFTNGP06.phx.gbl...

[Victoria [MVP]]

Sally,

Here is the official explanation:

The Historical Aged Trial Balance is for previous periods, and the Aged
Trial Balance will include everything that has been posted but unapplied or
partially applied.

The Print/Age as of option in the Aged Trial Balance is used to select how
you want to age the documents included on the report. The date you enter in
the field will be the date that the report is aged as of. (Not the payables
subledger balance as of that date!!!!!)

The Aged Trial Balance includes all Open documents aged according to the
Print/Age as of date. The Historical Trial Balance also includes all Open
documents and it also includes all Historical Transactions within the
Print/Age as of date, and is aged according to this date as well.

For example, an open document dated 7/15/01 will be included in the Current
Column on the Aged Trial Balance report if it is Age as of 6/30/01. If you
print the same report and change the Aged as of Date to 8/30/01, the
document will appear in the 31-60 Days Column (depending how you are aging
in the PM Setup). The same document will not be included on the Historical
Aged Trial Balance if you have your Age as of date set to 6/30/01 and the
document date is 7/15/01.

My take on it:

I try to keep it very simple - I don't see any reason to use both of these
reports. I have never had a customer ask me for a report that shows how old
only their current unpaid payables were (or will be) as of a particular
date. Never. Even if they want to see the actual aging buckets as of a
particular date, they wouldn't want paid transactions excluded.... And
that's pretty much the only thing the Aged Trial Balance is good for. So my
personal opinion, and the advice I give to my clients, is that you should
always use the historical report, even if you run it as of the current date.

A few things that I have seen in the past that are important when you're
running the historical aged trial balance report:
1. If you are reconciling to the GL, make sure that you run the report using
the GL Posting Date.
2. If you are reconciling to the GL, make sure the Aging date you're
entering is the last date of the GL period. For example, if you're
reconciling to the July calendar month, use 7/31 as the aging date. Even
though you may think you have not entered anything into August, do not use
the current date, because then you're potentially not comparing the same
data.
3. Make sure everything is posted before you reconcile.

Hope that helps.

--
Victoria Yudin
Dynamics GP MVP

"Sally" <Sa...@united.com> wrote in message
news:uOSGxlA...@TK2MSFTNGP06.phx.gbl...