• Looking for SQL table information

    HI, i'm trying to create a report for tax exemptions and W-4 amounts. I have the knowledgebase article that calls out that PARMSEQ refers to the field on the screen and PARMVAL is that value. But is there any way to get the Tax Field and Value entries…
  • IN THE WILD VOL 10:. To form a more perfect union (or HRMS Globabl reporting available in 10.5).

    GREETING SAGE CITIZENS. Today I am EXCITED to discuss this new topic. This isn't one of those cases where I work for SAGE so I have to be excited about everything. This is one of those cases that if I were with a channel partner or a direct customer…
  • Class library file .vcx is not found

    Getting the error in the attachment after clicking on Print button to print one of Benefit reports into PDF from SAGE benefit reports window. The error occurs on any report. Reinstalled SAGE and still the same problem.
  • Start Date on the Employee Pay tab on earnings and deductions gives an error message in Crystal Reports

    Does anyone have a workaround? Apparently the step that converts this field into the SQL view that Crystal uses through the OLE DB has an error in it. I can pull end date but not the start date. The error I get is i_SqlExec line 0 Conversion failed when…
  • 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 thanks
  • 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 that employees…
  • 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 leginfo.legislature.ca.gov/.../billTextClient.xhtml
  • 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???