Announcements
The GL Reconcile shows in balance with the GL and no unmatched transactions but when you run the HATB it doesn't tie to the GL or the GL reconcile report. How can this happen? Where do i look to find the difference.
I have run scripts to validate Distribution types are correct. I have looked for any GL journal entries in the AR there are none.
The client needs to run an Aged Trial Balance that ties to the GL. Help
Brenda,
Try running the Sales >> Utilities >> Reconcile on the Customers, check the Reconcile Date as that changes the Ageing Buckets if you use today's date, so usually the end of last month, and see if that updates the Customer Balances.
Brenda, If the Ledgers have never Balanced, then you would need to get that sorted first, and then work from there.
Mick
Good day,
You can also run a reconcile on the outstanding amounts.
Regards
Hi,
Just to add to the suggestions already given I tend to follow the steps in this blog post I wrote when I hit a reconciliation issue in GP
thedynamicsexplorer.com/.../
Hope this helps
Thanks
Gavin
Thank you for the responses. Should have mentioned that i have tried the reconcile of the current Customer information and outstanding document Amounts did not help.
The link's first step is to find the last time they balanced.... here is the kicker... they have been on the system since 2019 and it has never balanced. I took one month to try to reconcile the activity in the month.. for that month the activity reconciles. The Reconcile report show the ending balances as balanced and they actually tied to the GL. I have reviewed all JE since the beginning of time and they all clear. i have reconciled the differences in Distribution types. (to be clear, when the account number is AR but the distribution type is other than RECV)
What is bizarre is that the GL Reconcile Excel sheet shows it ties to the GL but the HATB does not.
Hello,
If the reconcile to GL total matches the GL balance, but only the HATB is different then perhaps you have some missing or damaged apply records in the historical tables. To see if this is true, run both the ATB with options report and the HATB report, both with the same options and with the same date out into the future of 12/31/2999 and see if you get the same total. If they do not match, then have missing or damaged apply records in history. I would recommend to open a Support case for assistance to help address the issue, or contact your Microsoft Partner to help identify and correct the data.
Cheryl W
Microsoft Dynamics GP Support
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 681 Super User 2026 Season 1
André Arnaud de Cal... 551 Super User 2026 Season 1
Giorgio Bonacorsi 471
