35
This is the second month we have encountered this issue between the GL Summary and GL Detail not matching. The GL Detail is correct. The first time it happened, we ran the Reconcile Utility and it fixed our issue, but this month it did not. We even ran Checklinks for the Financial Account Transaction History and our problem is still there. What else could we do?
Best regards,
Dinora
*This post is locked for comments
| Display Name | Technical Name | Physical Name |
| Account Current Summary Master | GL_Account_SUM_MSTR | GL10110 |
| Account Summary History | GL_Account_SUM_HIST | GL10111 |
These are the correct file names - Leslie wrote "GL10100" above in error.
Hi ddoss,
Yes, that is exactly what I mean. Depending on whether you're dealing with Open or History there are two tables:
GL10100: Open year summary master
GL10111: Historical year summary master
Be sure to backup your databases before you embark on this adventure.
Kind regards,
Leslie
Just wanted to second what Leslie is telling you. I've had the same issue prior where I ran the reconcile but summary did not update. I did delete the summary table gl10110 then re-ran and issue was solved. Seems intermittent to me, I'd be interested to hear if/how you get this resolved. gl10111 if you have a history reconcile issue.
Babu,
The problem is the GL Detail does not match the GL Summary. The GL Detail is correct. The smartlist I ran has the GL detail correctly shown, but it is the GP Summary for some of our GL accounts the summary balance does not match the GL detail.
Hi,
So your smartlist value is not correct if that is the case have you tried to run accounts transactions SL just for one account. If that also didn't works please go to smartlist builder and check whether you can see accounts transactions smartlist with star * symbol on it that means some one press modify GP default SL and saved it. You need to delete the same. Please take a backup of company and dynamics database before doing this. If you have a text environment please try it there.
Hi
Are you comparing accounts transactions smart list to financial summary and details window
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 (