• 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…
  • Creating a formula field in SAP Crystal Reports

    In SAP Crystal Reports, a formula is any field in which the value is calculated. For example, if you want to find out how many days are left before employee evaluations are due you can subtract the next performance review date from the current date. Formulas…
  • Pending Leave report

    Anyone built a report that shows upcoming pending leave from ESS? Looking for solutions thanks
  • Calculating Age - Part 4

    During the last several weeks we've looked at how to calculate someone's age for benefits and rate tables using Expression Builder. What if you need to calculate an employee's age in a SAP Crystal Report? To start with, Crystal Reports does not recognize…
  • Grouping Employees in Sage HRMS Payroll

    Have you recently needed to run a report or process a separate payroll for specific employees? If so, employee selection lists are the solution. Selection lists can contain as many employees as you require. The same employees can belong to several different…
  • 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!
  • Follow up on Q&A from What's New in Q2 2021 webinar

    One of the takeaways I had from yesterdays webinar was the Wyoming quarterly unemployment report. After installing the Q2 2021 product update, why was WY not appearing in the Report Authority ID drop down box (Path: Payroll > Employee Supplemental Info…
  • 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…
  • Challenge Question (20210122) Form W-2s

    Here's your chance to test your knowledge on Aatrix and the Form W-2s. If you attended the Sage HRMS Learning series webinar earlier this month, not only will you will recognize these questions, you'll know the answers! T/F - Aatrix has the ability…
  • 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.
  • Challenge Question (20200827) Timecard Reports

    True or False - You can print the Timecard Summary Report from within the Timecard List in the Payroll Processing Map. Answer: True Navigation Path: Payroll or Canadian Payroll > (Tasks) Process Payroll > Timecard List and click >> (Go) Clicking…
  • 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)?