Data Inconsistencies

I have run into this issue before and was able to fix it, but can't for the life of me remember how... I'm hoping someone can assist. My Sage 50 Canada (2023.2) file has data inconsistencies. Debits and Credits don't balance. It's not in the A/R or A/P. My opening Retained Earnings doesn't agree to what it should be. This seems to have been triggered after closing our April 30 fiscal year-end. I have tried running the Advanced Database Check, as well as the Database Utilities (Sage_SA_dbutil.exe), but neither of these have corrected the problem. It seems to me I have corrected this issue in the past (on another file) by being able to partially re-open history mode and manually enter the correct Retained Earnings balance. Can anyone offer any instruction on how to do that? Thank you!

  • If the imbalance happened during the last fiscal year transition and the difference in Retained Earnings is the Net Profit from last year, there is no need to open history and post entries.  Sage Tech Support should be able to walk you through an internal Rebuild.  It will recalculate the totals.  If not then contact me off forum through the email in my profile.

  • 0 in reply to Richard S. Ridings

    Thanks so much. Support did walk me through an internal rebuild. It didn't work. But I was able to re-open history mode in the process and was able to manually enter the correct retained earnings figure in the chart of accounts (the difference wasn't net profit from last year - I'm really not sure where it came from even after hours of digging). My prior year-end financials still don't balance somehow... but the current year does. For now, I'm happy with that. But thank you again for the message.