web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / HATB Problem
Microsoft Dynamics GP (Archived)

HATB Problem

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Tom Cruse Profile Picture
    Tom Cruse 1,477 on at

    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.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans