Sage Custom Reports

ADD CUSTOM CRYSTAL REPORTS TO YOUR REPORT LIBRARY!

Sage Software continues to add customized Crystal Reports which are in addition to the 100+ reports contained on the 7.X CD. Abra users now have another 50+ reports online that they can use as is or as templates. (These reports are available and can be downloaded from the Sage Customer Support Website).

Most of these reports were created by Sage Software based on customer calls making them especially helpful.

Another option to obtain these additional reports is to have Dresser & Associates download the selected reports below, burn them to CD and send the CD to you. In addition, Dresser & Associates will provide a copy of the "Report Writing Screen Guide" on this CD. This guide has been created to assist Abra Users in the development of custom reports utilizing Crystal Reports. The guide should be used in conjunction with Data Dictionary reports generated within Sage Abra HRMS. (The guide corresponds to the order of the "detail" screens in Sage Abra HRMS 7.X.)

The Cost of the Customized Report CD is $60.00, and includes shipping, selected downloaded Crystal reports, and the Report Writing Screen Guide. Mastercard and VISA accepted - fill out this form and we will contact you for billing details.

Order Abra Reports online with Dresser & Associates!

Fields marked with (*) are required fields.

Name:*
Company:*
Title:
Telephone:*
Fax Number:
Email:*
Company Address 1:*
Company Address 2:
City:*
State:*
Zip Code:*
Preferred Method of Contact: E-mail (Be sure to include e-mail address below) Postal Service Phone

Check the box next to the report you want to order, them click the order button.

Payroll Reports

[HR Reports] [Recruiting Solution Reports]

Order	Report Name	Description
	401(k) by Date - no subreports.rpt	401(k) by Date - no subreports is a more streamlined copy of the report that shipped with early versions of 7.x showing hours, earnings, contribution, and employer match for a chosen date period.
	Active Deductions.rpt	Active Deductions shows employees and a list of their deductions that currently have a status of active.
	Census with PrhPost.rpt	This landscaped version of the census report adds gross wages, hours, and 401k contribution for a date range.
	Cross Tab Deductions.rpt	This report uses Crystal's Cross-Tab feature to show a breakdown of every employee's deductions. It shows the total YTD amount for each deduction code and a grand total of all monies deducted both by employee and code.
	Deduction History.rpt	Deduction History report uses parameter fields to allow for the selection of specific deduction codes and then shows the total amount withheld for a specified date range.
	Earning History.rpt	Earning History report uses parameter fields to allow for the selection of specific earning codes and then shows the total amount and hours for a specified date range.
	Earning Code Totals by Division and Department	This report is a workaround to control number 3459, in version 7.1X. Sorts the same as the 6.3X the Employee Earnings report and sorting by Division and Department.
	Earns Deds Taxes.rpt	The Earns Deds Taxes report uses parameter fields to specify 2 earnings, 2 deductions, and 2 taxes to summarize for a date range.
	Employee Charge Date	Trial payroll earnings report that can factor in overtime or double overtime for gross amouns. Shows detail of deductions panel, payroll history panel and includes current amounts
	Employee's Total Hours by Selected Earning Codes.rpt	Employee's Total Hours by Selected Earning Codes shows each check date and the amount of hours for whichever earning code is selected and for whichever date range is desired. The individual entries are then totaled.
	Employee Tax Code Check	Report will display "X" if an employee has a record for the indicated tax code in PRTAXES or "Missing" if there is not a record.
	Employer Liability Adjustment Analysis	Lists adjustment records in PRTAXLB.
	History of Earnings, Deductions, Taxes	PRHPOST report pulling either all earnings, or deductions or taxes by a date range and includes totals
	Leave Liability.rpt	A Crystal recreation of the standard time and labor report 'Leave Liability'. Uses a parameter field drop down list to choose between 'Personal', 'Illness', or 'Vacation'
	Overtime Hours by Supervisor.rpt	Overtime Hours by Supervisor summarizes the current hours as well as the current, MTD, QTD, and YTD amounts for a specific earning code.
	Pay Group Verification Report.rpt	Pay group Verification Report is used to verify the pay group field is set up correctly between the Employee Personnel and the Taxes, Deductions and Earnings databases
	Stuck Entries for Post, Check, Detail	Verifies whether entries are stuck in Post, Check, or Detail after optimizing
	Tax history Report.rpt	Tax history Report uses parameter fields to allow for the selection of specific tax codes and then shows the wages and withholding for a specified date range.
	W-2 Annual Report.rpt	W-2 Annual Report shows YTD numbers for the current year and should therefore be run prior to trial quarter close of the forth quarter.
	W-2 Annual Review	W-2 preview prior to year end with an earnings and deductions summary
	Workers' Compensation Cost - Straight Wages.rpt	Workers' Compensation Cost - Straight Wages uses HR and PR rules at the enterprise level, selecting earnings that have hourly earnings with an earnings type of base pay and earnings category of pay for worked performed.
	Employee Quarter End Audit	Breaks down each employees W-4 panel details in order to help troubleshoot quarter end reports and W-2 issues
	Tax Liability Deposit	Summarizes whether or not taxes have or have not been recoded and deposited
	ACH Deposit Review	Shows detailed information for each employees deposits during the 2003 year
	System Tax Table list by discription	Paramater fields query for a range of tax codes. Sorts the System Tax tables by description so that the code can be easily found.
	Yearly W-2 report	Information as reported on the W-2 for each employee by a selected year
	Year End Adjustment notes	Shows any adjustments made to the W-2, 941 forms with the notes entered for each edit.
	Payroll Balancing	Uses post, check, detail to summarize trial payroll. Can also be used to check for stuck entries. Includes arrears amounts
	Cross Tab Earnings, Deductions, Taxes	Uses a parameter field to pull either earnings, taxes, or deductions for each employee during a date range
	Quarterly tax breakdown	Pre-Trail Quarter Close - Employee Taxes vs. what the employer has paid from the liabilities.
	Deductions linked to HR benefits	Report shows if the deduction code is linked to an HR benefit code and if the code has an employer match component.
	Printable copy of employees check	Employees may need copy of their check. This report will show a duplicate of the actual check/advice

|Top|

HR Reports

Order	Report Name	Description
	Average Hourly Rate.rpt	The Average Hourly Rate report groups employee information by P_LEVEL1 and shows total hourly rate and average hourly rate for the level, company and enterprise.
	Birthday List (year omitted).rpt	Birthday List (year omitted) groups employees by their month of birth and lists their birth date without displaying the year.
	EEO 1 Head Count Summary - ADA.rpt	EEO 1 Head Count Summary
	EEO New Hire Detail - ADA.rpt	EEO New Hire Detail
	EEO-1 Headcount Detail - revised - ADA.rpt	EEO-1 Head Count Detail
	Employee Benefit Letter (without history).rpt	This replacement for the benefit letter includes the suppression of benefit history records that can adversely affect totals.
	Employee Home Phone List.rpt	This report contains an alphabetical list of employees with their employee number, home phone and cellular phone numbers.
	I-9/Visa Renewel Verification	Employees with Expired Visa's and I-9's that require renewal. Prompts for I-9 reverification and Visa expiration dates.
	Employee Marital Status and Benefits.rpt	Employee Marital Status and Benefits lists the employee name, ID and marital status as well as a listing of all current benefit plans into which the employee is enrolled.
	Employee Totals By Company_Job Title_Race.rpt	This report gives an employee count broken down by company, job title and race and gives percentages of each when compared to the company as a whole
	Employee Type.rpt	Employee Type shows a list of employees and their employee job type which is useful for quarter and year end balancing.
	Extended Performance Review.rpt	Performance review report is shows a great deal of information that many persons find useful during review periods.
	Job History Listing.rpt	Employee listing with Current Job data, and a listing of all history records in HJOBHIST.DBF
	Performance Evaluation Form.rpt	This report is a performance evaluation form that can be printed for use when doing annual performance reviews. It includes a parameter field in the selection criteria that corresponds to the month of hire and can be populated with a single month, multiple months, or a range
	Random Employee List.rpt	This report is useful anytime a random list of employees is required such as in the case of random drug screenings.
	Salary As Of.rpt	The Salary As Of report uses the employee personnel and job history tables to determine the employee’s information as of the date entered.
	Salary Grade.rpt	This version of the report shows employees and their salary in relation to their assigned salary grade regardless of the level on which the rules were defined (enterprise vs. employer)
	Security Chart.rpt	Security Chart is a table to show each security group defined under group security and which items that group can access.
	Supervisor List.rpt	Supervisor List shows employee information grouped by their respective supervisors.
	Supervisor Mismatch List.rpt	This Report is designed to list employees who have each other listed as the supervisor. This report may be needed for Org Plus issue where Org Plus errors due to Mismatched supervisors.
	Terminated Employee Name List.rpt	Terminated Employee Name List shows all terminated employees with the date and reason for termination.
	Turnover Statistics.rpt	Turnover statistics is a listing of employees terminated within a date range and includes several pieces of useful information.
	Health Profile	Provides overall view of employee's health profile
	Dependant Birthday list	List dependants birthdays by each month
	Employees without a specific benefit	This report will list all employees who do not have the specified benefit on their Detail records.
	Emergency contact by supervisor	Employee's Emergency Contact broken down by their supervisor
	EEO Job Group Headcount	Copy of the Standard EEO Job Group Headcount report
	EEO by Job Group Detail	List employees grouped by EEO Job Group and EEO Job Class. Shows totals and percentages by sex and race
	EEO New Hire Summary	Provides a table showing EEO Classifications and number of newhires broken down by sex and race. Copy of Standard report

|Top|

ABRA Recruiting Solution

Order	Report Name	Description
	Applicant Mailing Labels.rpt	Applicant Mailing Labels
	Applicant EEO Analysis	EEO Analysis report. By Ethnic and Gender. List current status and the desired salary for the position

If you have any questions, please contact Dresser & Associates.
Dresser & Associates respects your privacy and will NEVER share your information with a third party. For more information, see our privacy policy.

© Copyright 2009 Dresser & Associates, Inc.
Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are property of their respective owners.

Dresser & Associates is one of the nation's leading providers of HR software, featuring Sage Abra Human Resources (HRMS) and Payroll solutions from Sage Software.