315
I have a Trial Balance report of all accounts and it does not balance on the bottom totals. We believe that some entries were deleted on the back end in the SQL database. We lost our server and current backups and we had no choice but to to restore a database from a backup that had been used for testing.
What would be the best way to search for the deleted entries? Which tables would we search other than table 17?
*This post is locked for comments
Hi, Try narrowing down where the discrepancy appeared - set smaller periods for Net Change to find the exact date where trial balance doesn't balance. And then you can do similar with document number. When you find the document number and date, click on Navigate, see what additional entries where created and you'll know what you should have had in GL.
Robertas
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
