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. 

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?

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

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.