• Does anyone know when and how we will connect Crystal Reports 2020 to Sage HRMS (the OLE DB data source is not available)?

    Crystal Reports 2016 is no longer available from the knowledgebase (that I can find), and Crystal Reports 2020 does not have a connection to the HRMS database. I have clients with new workstations that need Crystal installed, but it has to be a working…

  • Pending Leave report

    Anyone built a report that shows upcoming pending leave from ESS?

    Looking for solutions


  • Looking for help on payroll reports

    I am trying to create a report for my boss that shows gross pay, net pay, Overtime pay, retirement contribution and PTO balance.  I am struggling to find the correct Payroll files to use in HRMS for crystal.

  • Reporting

    Is there anything going on with the new WA Cares program that is starting in 2022? 

  • How is annual pay calculated in the Benefits Letter in Benefits Reports?

    We are wanting to implement use of the Benefits Letter report, but seem to be getting some strange amounts for "annual pay" displaying in the letter. Can anyone point me to where that information is coming from or calculated from?

  • Issues after Qtr 2 update

    I ran the update for Qtr 2 this morning and am now not able to run any reports without the program shutting down.  Has anyone else had that issue or know what to do to correct?  Thanks!

  • Is there a way to change the order sage hrms to sage 100 audit report?

    We are using the Sage HRMS link to Sage 100. The order of modified employees is by employee number on the audit report. But the selection list in the check box is alphabetical. Is there a way to change the order of either? 

  • California Pay Data Report is only for Single Establishment.

    Why is there not a multiple establishment report available? Also..the report is completely different from the template on the California Pay Data Portal. Has anyone tried filing with the AATRIX report currently available?  We were given a 30 day extension…

  • Showing Taken Sick Time on Paystubs

    Hello!  In California employees accrue sick time but can only use a max of 24 hours a year.  The current formula in the crystal report paycheck form only allows for "what's left".  I would like to be able to show was has been taken so far so…

  • SB-973 Employers: annual report: pay data

    I have been recently notified about CA state diversity reporting requirements for 2021 and was wondering if Sage had any plans of addressing this.

    SB-973 Employers: annual report: pay data


  • Vets 4212 Detail list

    Is anyone missing employees from their VETS 4212 Detail List Standard report in HRMS 2017 v.10.7049? 

  • Crystal Report

    I'm trying to pull the vacation plan and year end eligibility but can't find the filed names.

  • Sage HRMS reports similar to Sage Abra Suite reports

    What reports in Sage HRMS are similar to Sage Abra Suite Reports. I'm interested in the Payroll Deposit Requirement report

  • Failed logon report for HRMS

    I am in the midst of a security audit and one of the questions has been posed about providing a User Failed Logon Report for HRMS.

    Has anyone created such a report before, or does HRMS even track such things like Time and Date of logons as well as logon…

  • Missed Deduction Report

    Hello, is there a Missed Deduction Report available that shows employees that do not have enough earnings to cover their deductions (which would result in a negative check)?

  • Job History Report

    Is there a way to pull a report that includes all job history for each employee?  I've tried creating a Secure Query with no luck.  Guessing it may be able to be done in Crystal?  Any advice is greatly appreciated!

  • building event code report

    Does anyone know how to build a report in HRMS which will show all employees that are missing one specific event code? 

  • Custom Crystal Report showing pre-tax and post-tax deductions

    I'm trying to create a custom crystal report that shows Employee Number, Full Name, Gross wages, Pre-Tax Deductions, Post-Tax Deductions, Gross wages (excluding Pre-Tax Deductions).

    I believe I need to use UPEMPL, UPCHKH, and UPCHKD to get the Employee…

  • HRMS Secure Query in HR

    When my client runs Secure Query, the report doesn't pull the requested fields.  

    Client asked for: First Name,Last Name, Term Date, Term Type, Term Reason 

    Filtered by terms in a date range

    Report returned: Active, Full name (last, first), Department

  • OSHA 300 Log Report--Wrong Job Title pulling into report

    I've noticed when I print the OSHA 300 Log Report, that it is pulling the employee's current job title rather than the job title at the time of injury.  It appears to be pulling the job title from employee file rather than the Safety>OSHA tab.…

  • Standard Report vs Crystal Report

    When I run the Gross to Net Suitelike report in HRMS, the Premium Pay column is not correct.  Some of the Premium Pay earnings are included in Base Pay column and some in Premium Pay column???

  • Crystal report for Pay Stub

    I am looking for a crystal report to be able to print earning statements using the following databases UPCHKD, UPCHKH, and UPEMPL that includes YTD totals.

  • I updated Sage 100 2018, now the reports in HRMS 2017 will not work.

    I updated to Sage 100 2018. We are currently up to date on Sage HRMS 2017 Q4, version 10.7038. The reports prior to the Sage 100 2018 in Sage HRMS worked. After the update to Sage 100 2018, the reports in Sage HRMS 2017 either error out to Microsoft Foxpro…

  • Why can we not add the LINENO field in UPCHKD to any Crystal Report?

    When you add the LINENO field (it's just a numeric field) to a crystal report and then refresh the data, it always generates an error 1526 and ends not only Crystal but the HRMS session as well.  HRMS version 10.7036 with Crystal 2011.

  • VETS4212 Report

    My VETS4212 reports do not output accurate results in Sage HRMS.  Does anyone have a suggestion as to how to get the summary data?