Skip to content
logo Knowledgebase

How to Archive Oldest Payroll Year

Created on  | Last modified on 

Summary

How to Archive the Oldest Payroll Year in Sage 100 Contractor

Description

 UPDATED: Version 26.1 and later include several enhancements to the Archive Oldest Payroll Year process: 

  1. Includes options for removing employees from the current database.
  2. An employee Status of Retired has been added.
  3. Added an option to remove only INACTIVE employees
  4. Archiving the oldest payroll year does not include the newly introduced process in version 26.1 and later for creating a Combined (fiscal year and payroll year) archive.  However, if the company has a 12/31 fiscal year-end date just like the payroll year-end, a message will display offering to switch to the Archive Oldest Fiscal Year process to perform a Combined (fiscal year and payroll year) archive in that option.

Resolution

Archive Oldest Payroll Year must be performed in Database Administration for Sage 100 Contractor, while logged into the server. Archiving Oldest Payroll Year is a more time-consuming process that creates a backup of the company database; then, separates payroll records for the calendar year being archived into a new company database:

  • Archiving the oldest payroll year removes all payroll records for that year from the database and places them in a separate archive database.
  • Archiving Oldest Payroll Year allows you to to delete unwanted payroll calculations in the new year.
  • Archiving Oldest Payroll Year allows you to optionally remove employee records with a Laid Off, Quit, Terminated, Deceased, or Retired status.

Important: Sage 100 Contractor version 24.2 later includes a new feature in menu option 5-3-8 entitled Close Payroll Year. In contrast to archiving the oldest payroll year, closing the payroll year in menu 5-3-8 is much faster than archiving the oldest payroll year, typically taking only several seconds to complete. This will save you considerable time at year-end. For more information see What is Multiyear Payroll (Close Payroll Year) in Sage 100 Contractor versions 24.2 and later? New Feature: 5-3-8 Close Payroll Year, and How to Close Payroll Year in menu 5-3-8

 

How to Archive Oldest Payroll Year

  1. Install the year-end update. The year-end update may contain fixes and enhancements to the archive oldest payroll year process.
  2. Connect to Database Administration for Sage 100 Contractor.
  3. Create a backup of the company data, using Tune Up / Back Up / Restore > Back up Companies.
  4. Choose Archive Company Data > Archive Oldest Payroll Year.
  5. Select the company to archive from the drop-down list.
    Note: if your company is not on the list, see: No companies listed or company missing when archiving in Database Administration in Sage 100 Contractor SQL.
  6. In Enter the name for the payroll archive, type a name for the payroll archive that will be clear, such as "CompanyName Payroll YYYY."
  7. Under Remove employees with the selected status(es) no longer referenced in the database, check the appropriate boxes.
  8. Choose Create Archive. This begins with another backup. When the process is complete you can close Database Administration.
  9. Open 100 Contractor, choose the Show archives radio button, and verify that this list contains your payroll transactions. (You may also look in the current company to see that 5-2-2 Payroll Records has zero records.)

Need more help?

Chat now

 

 

 

Related Solutions

How do I back up and restore my company data in Sage 100 Contractor SQL?
How do I archive my Fiscal Year in Sage 100 Contractor SQL