Archive the oldest payroll year
Description
Archive the oldest payroll year to move payroll records into a separate archive database and reduce current company data.
Cause
Resolution
  1. Install the year-end update.  The year-end update improves the archive process.

  2. Connect to Database Administration for Sage 100 Contractor.

  3. Create a backup using Tune Up / Back Up / Restore, Back Up Companies.

  4. Select Archive Company Data and Archive Oldest Payroll Year.

  5. Select the company to archive.

  6. In Enter the name for the payroll archive. 

  7. For example, enter a descriptive archive name.

    Example: "Company name Payroll 202#."

  8. Select the appropriate options under Remove employees from the current company.

  9. Select Create Archive.

  10. When the process finishes, close Database Administration.

  11. Open Sage 100 Contractor.

  12. Select the Show archives radio button.

  13. Open the payroll archive company.

  14. Verify the archive company contains the expected payroll transactions.

  15. Open the current company.

  16. Verify 5-2-2 Payroll Records contains no records from the archived payroll year.

Benefits

  • Removes payroll records from the current database.
  • Stores archived payroll records in a separate database.
  • Allows deletion of unwanted payroll calculations after archiving.
  • Optionally removes employees with Laid Off, Quit, Terminated, Deceased, or Retired status.

More information

Updates in version 26.1 and later

  • Added options for removing employees from the current database.
  • Added the Retired employee status.
  • Added an option to remove only inactive employees.
  • Displays a message for companies with a December 31 fiscal year-end.
  • Lets you switch to Archive Oldest Fiscal Year for a combined fiscal year and payroll archive.
Steps to duplicate
Related Solutions

How to Close the Payroll Year

About the Close Payroll Year feature