HATB Problem

(0) Share

Report

Posted on by Community Member Microsoft Employee

We have always used the Historical Aged Trail Balance Report run with the end of month date, to prove that our ending A/R balance in the GL reconciles. Until recently this has always worked. Recently it has not matched and we have identified credits that are matched to invoices, but the invoices still show open for those accounts on the Historical Aged Trail Balance. Is there a file rebuild that needs to be run to correct this problem? Has anyone else run into this?

Thanks.

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Bill Campbell 22,647 on at

Like (0)

Report

RE: HATB Problem

One of the worst things about the Historical Aged Trial Balance report is that dates are everything.

If you have a document posted on the 31st of the month and by chance run the HATB for the 30th - the document that was applied on the 31 will show as 'not applied' as it was not applied until the 31st.

I know this does not address your issue specifically, but, when you are running HATB be aware of dates. Look to see when the apply was done, look to see the posting date, look at the document date and then look to see if the HATB running date covers them all.

If you apply a payment on account for a customer on the 1st - even when the document date is 30th - and run HATB on 30th - it still shows - it is the apply.

Ramble on and on - if this helps - let me know.
Suggested answer

Tom Cruse 1,475 on at

Like (0)

Report

RE: HATB Problem

I would run reconcile on the sales module at the customer level for that particular customer.

DynamicsGP >> Tools >> Utilities >> Sales >> Reconcile

As always be sure to backup you data prior to running but this might fix the problem.