I would contact Sage support for this, especially if it is a new / recent installation.

Probably you should go back to your backups from before, run all your reports and database checks, and run the year end again.  

If you don't have backups, then you may need the data repaired.

Hi Leanna,

You can run the Database Utilities (Sage_SA_dbutil.exe) by following the step below.

1. Backup your data from Sage 50.
2. Close the program.
3. Click on Start; Computer
4. Browse to C:\Program Files (x86)\(Sage 50 installation folder)\
5. Locate the executable file:
   • 2008-2009: SimplyAccounting_dbutil.exe
   • 2010 + : Sage_SA_dbutil.exe 
6. Double-click Sage_SA_dbutil.exe.
7. Click the Browse button in this Database Utility tool.
8. Browse to the folder where your data file is located (the .sai file), select and open it.

   Note: Ensure the file is locally on your computer, if it is on a server, copy the file on to the local machine to run the dbutil and then copy back to the server.

9. Select all 4 check boxes and then click the OKbutton to begin repairing the database.

   Note: The window will remain on displayed until the process is complete. A window will appear stating that the tasks are complete.

10. Press OK then close the window.
11. Start Sage 50 to verify that the problem was fixed.

You can run it on the data file already rolled over to the new year first.  If that does not fix the issue, try to restore the backup before advancing to the new fiscal year, run dbutil on it and then roll over.

Hope this helps. 

I agree with RandyW -  had this happened to me a few years ago where the retained earnings did not update. I had already started entering a few entries without checking the Data Integrity at the time (something I now do every time I roll over into the new year). The end result was that I had to have Sage support repair the data.

Keith,

Which of the four options actually rebuilds tAccount balances?  And does it recalculate tAccount.dYts and tAccount.dYtc only or does it recalculate tAccount.dYtsLY and tAccount.dYtcLY as well if necessary?

Thank you Keith, tried these instructions, the function ran but sadly didn't fix the problem though.  Any other ideas?  Thanks again.

Hi Leanna,

If you are using Sage 50 2014 with your warranty service or service plan, please call us by 1-888-522-2722, we will remote in and help you troubleshoot your issue.  

Thanks

Leanna

After the REBUILD check the data integrity report under MAINTENANCE.... if the debits do not equal the credits then call support and ask for level 2 support. The level 2 guy can access support utilities and put the GL in history mode. Then will guide you through the process to update R/E

ok Keith has already answered

Richard

Rebuilds dYts, dYtc, dYtcLY based on the start balances in dYtsLY. If your interested run an update query and SET all the balances dYts, dYtc, dYtcLY  to zero ... run the rebuild

Thanks G for the info.  I was a little too lazy to do that kind of thing but have always wanted to find out if it did recalc.  I'll try it someday when I have a bit more time.