Employee Earnings Summary Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: EARNSUMM.DAT

EARNSUMM.DAT is the employee earnings summary file. It contains a record (row) for each quarter per employee.

To add Sage 50 employee earnings summary fields to your Crystal reports, select EARNSUMM.DAT.

These fields define the quarters per employee and weeks worked per quarter. There are two sets of quarters:

Quarter 0 is used to contain only beginning balances for "running" fields such as vacation and sick time.
Quarters 1-4 are for the current calendar (payroll) year, while quarters 5-8 are for the next payroll year.

To determine Sage 50's current calendar (payroll) year, do the following:

From the Tasks menu, select System, and then Change Accounting Period.

Note: Calendar (payroll) and the fiscal years are different concepts that don’t necessarily refer to the same real year. Calendar years refer to payroll years that start in January and end in December; fiscal years are established in Sage 50's New Company Setup wizard and can start and end at any time.

Indexes and their uses

The EARNSUMM.DAT file has four keys, as follows:

0 = ByEarnSumm_RecordNumber – Unique and doesn’t change. Usually used to link to other tables.

1 = ByEarnSumm_EarnSummGUID

2 = ByEarnSumm_EmpRecNum – Identifies the employee associated with this earning summary information

3 = ByEarnSumm_EmpRecNumQtr – Used to retrieve the earning summary information for an employee sorted by quarter

Field Name	Type	Comment
RecordNumber	Integer	Used as a table-linking field.
GUID	Ubinary	GUID (Globally Unique Identifier) used for linking the Earnings Summary table.
LastUpdateCounter	Integer	This is a counter that increases incrementally each time a record is modified.
EmployeeRecordNumber	Integer	Identifies the employee.
Quarter	Integer	Identifies the quarter.
WeeksWorked	Integer	The number of weeks the employee worked (based on paychecks entered in Sage 50) in the quarter.