You’re offline. This is a read only version of the page.
191
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
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
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.
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
Hope this helps
Thanks
Gavin
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (