Tom,
I see what you're saying now. I think the original discussion I was
answering was whether the ATB is ever better at anything than the HATB, so
that's kind of what I had in mind when I was answering your post. Now that
you've explained in more detail, I still maintain that the ATB will not do
anything better than the HATB.
However, I do want to address what you're saying. There is really no way to
programmatically keep track of all the unapply/re-apply details without some
kind of GP customization and a lot of custom reporting. In all the years I
have been working with GP this has only been an issue for one customer and
that's because they decided (for valid business reasons) to unapply payments
that were more than 3 years old.
In the scenario you're describing, my recommendation would always be to age
the unapplied credits, in fact, that's what I typically recommend when
asked. What would be the justification not to? This would al least show
the totals consistently in the right aging buckets, no matter whether things
were unapplied afterwards or not. Also, if having the information show the
same as what the customer statement had is this critical, then unapplying
past transactions should either be done extremely carefully, or not allowed.
By not allowed I mean move the fully applied sales transactions to history
when the statements are printed, that way no one can unapply anything. Then
buy the RM Unapply Tool for the times when this is really needed and only
give it to 1 or 2 users who will need a justification before unapplying.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
Post by Tom AI think there is a misunderstanding. I agree that any doc with a 6/1
docdate, GL date and apply date will not show up on a 5/31 HATB.
Assume you have a single Invoice for a customer in the amount of $100 dated
Jan 15.
Enter a Cash Receipt for $50 and apply with docdate, GL date and apply date
of 5/31. That leaves a balance of $50 on the invoice.
On June 30 if you run a HATB as of May 31 and you get exactly what you think
- $50 in the 120 - 180 agining bucket (or whatever bucket you have that
covers that # of days). All is well.
Then "unapply" the cash receipt, leaving an open invoice for $100 and an
unapplied cash receipt of $50.
Run the HATB report again for the same May 31 date and it will show the full
$100 as being in the 120-180 day bucket and a Current period open balance of
($50) for the unapplied cash receipt (assuming that you have not selected
"Age Unapplied Credits" in Receivables Setup).
I agree that the total balance will always be correct in HTAB. However, in
this instance the individual Aging Period amounts are not necessarly correct
as of the date in question, but rather reflect how each cash receipt is
currently "applied" .
The apply table is not kept in perpetuity but rather a record is deleted
from the table when you unapply. Therefore, I know of no way to go back to
the correct aging periods as of a certain date.
the impact is not overwhelming, however it can cause problems in a
collections department as they try to address moving amounts between
statements (that are in a customer's hand) and actual remaining balances as
of the time of a call after mis-applied payments are sent out.
Also, I believe it does present some issue with regard to accurate reporting
to auditors in that you can't show a Agining (by bucket) as of a certain date
without printing a reports and storing that.
I hope I am wrong in what I write above, but have not figured out anything
to the contrary that can provide such a report and is accurate by agining
period.
Sorry for the long winded and rambling reply.
Post by Victoria [MVP]Tom,
Unless I am misunderstanding what you're saying, I have to respectfully
disagree. If you enter and apply a cash receipt with a doc date, GL date
and apply date of 6/1/08 and run a HATB as of 5/31/08, the report will print
as if the cash receipt never happened. The HATB looks at all the RM
transaction and apply tables and 'backs out' anything that happened after
your 'as of' date, whether it's a transaction or the apply portion. This
also applies to voids and NSFs. It sometimes gets complicated since you can
have different doc dates, GL dates and apply dates (which can also have a
different doc date and GL date), and because you can print the HATB using
the doc dates or the GL dates, but the report logic takes care of all of
this.
--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
Post by Tom AGood thread, but I think one key piece is missing based on what I have seen.
Assume that you close periods and don't have any furhter transactions posted
in those periods, the HTAB can still be off because the application of Cash
Receipts against documents. Granted, the total AR as of that date in
question will be accurate, the actual agining buckets may not be as you may
have Unapplied a Cash Receipt that had previously been applied.
My understanding is that while Dynamics stores everything about the
Receivable transaction in theRM20101 table (the invoices, cash
receipts,
etc)
it does not store the apply information - that is a separate table and
if
you
look in it any "unapply" of a payment actually results in that particular
record (of the apply) being deleted from the table.
Post by jose garciaFirst at all thank you for your collaboration. I 'm trying to generate a
Historical Aged Trial Balance Report in the Sales module
(Reports>Sales>Trial
Balance).
In the Receivables Trial Balance reports, I choose in the
drop-down
list
of reports the option "Historial Aged Trail Balance" and click in the modify
button to configure the report according to the accounting department.
In the following window, Receivables Trial Balance reports Options,
I
select the option by "Document Date" in the drop-dow list "Sort Documents"
and uncheck "In Detail" and save the report to print.
Now my problem starts when the real information for some costumers
doesn't show up in the right columm.
I checked the report in differents workstations to verify if their report
was a local problem but the problem persisted in all the workstations.
Do you have any idea to fix this problem I really appreciated.
Regards,
Jose Garcia
Post by Mariano GomezJose,
Could you provide more infomation? What data appears in the wrong column,
invoices? credit memos? Also, what payment methods are you referring to? How
are they setup?
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
Post by jose garciaI want to use this report in Reports>Sales>Trial Balance
After I configured it but there are some customer that appear with the data
in the wrong column (current/0-30 days) according their payment’s form.
Thank in advance,
Jose G.