Sage 50 roll forward error

Sage did not amalgamate all income/expense balances into retained earnings when updating to a new year - old year OK - new year balance sheet not balanced - retained earnings is the only account not correct.  We need to post a one-sided entry only to retained earnings to correct situation.  How can this be done?  Thanks.

Parents
  • 0

    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. 

Reply
  • 0

    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. 

Children