• Errors When Running Secure Queries in HRMS

    We are getting the following errors when running secure queries out of HRMS. We upgraded from Abra to HRMS and are live now but they don't work. We tried on 5 different workstations and received the same errors. I am receiving the errors on my computer…
  • 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.
  • Earning code showing $0 on check if flat earning type

    We have an salary and wages, flat earning code setup in HRMS. We are running the open payroll and checking the calculate pay rates as hourly option. When we add in the earning code to a timesheet, put in 1 hour and $100 for the amount, the $100 is not…
  • ESS passwords are not saving correctly in SQL

    Description of the Problem We currently did an upgrade from Sage HRMS ESS 2012 (10.20) using the Migration Path to version 2015 with latest patch then 2016 with latest patch then 2017 with latest patch, landing on version 10.703701. after the upgrade…
  • INDFLG Error Message on Personnel data forms being encountered

    An error of variable non-existent is being encountered upon executing the following functions: Personnel administration>Personnel Data Forms>Ledgers> * Standard Jobs * Positions
  • Termination

    Whenever HR terminates an employee, this message comes up at the end. Any Suggestions? Thanks.
  • Salary out of range error

    I have salary ranges set up in HRMS for several clients. Ranges were updated after a raise. Now whenever the client adds a new employee and enters pay, they get notification saying Salary is out of range even though it isn't. This happens to multiple…
  • Error when processing time off request in ESS

    We are experiencing an issue processing time off requests in Sage HRMS 2017 and ESS 2017. The message we receive is: Insert failed: Record already exists in table hattran: SELECT Count(1) FROM hattran WHERE a_company = 'GRN' AND a_empno = '3080' AND…
  • adding attendance plans by seniority

    I am new to complex expression and functions My client has attendance plans that employees are eligible for based on belonging to a certain group (I have used Pe.p_level3 to identify the 2 groups) PLUS Either years of service >= X or salary range…
  • Product Enhancement Request: Filtering Field Level Security

    Would like to see filters on field Level Security to give more options at unique access rights... For example: I could use the Product Group Filters and restrict access to a group of employee's based on an Org Level Value, and this prevents that user…
  • Rate Table for a savings plan

    I need to setup a rate table for a savings plan. The company will match up to 5% of the employee contribution if the employee has been with the company less than seven years and will match up to 6% if the employee has been with the company seven years…
  • Employee Selection Lists - Auto Update

    How do you guys handle Employee Selection Lists in Payroll for lots of employee turnover. For example, we have 2 different payroll selection lists. One for Weekly Salaried Employees, and one for Weekly Hourly Employees and we do 2 separate payroll runs…
  • Pay Stub PDF Password

    FormerMember
    FormerMember
    When we process our bi-weekly payroll a PDF is created on our Sage 300 server for each employees paystub during the pay period. I am able to locate the PDFs but when I go to open them it requires a password. I have no idea of what the password would be…
  • unable to reset password in Sage ESS either as admin or user

    As an admin, when the reset password button is hit (2012) it is supposed to set the password to newuser and enable the user to reset their password. That does not work. If an ESS user hits the forgot my password link, it enables entry of user name,…
  • Custom Crystal Reports

    Does anyone know how to exclude history records when writing a custom crystal report using HRMS database? I see that the built-in reports have an option to include/exclude history records. I need to run reports for current benefits and exclude history…
  • HRMS 2016 database encryption with SQL 2016

    We would like to be able to encrypt the databases that HRMS and TimeStar use. After talking with phone support they have told us that is not a current feature, I hope this is the correct forum to post this as a feature request. Preferably whole database…
  • Payroll Link

    Can anyone point me in the right direction. Client is using Sage HRMS 2014 and 300 ERP 2014. I am setting up Payroll Link and everything is working fine except for the Accruals Tab. I can't see the Accpac Accrual Code/Description fields or the HRMS…
  • 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…
  • Sage HRMS and Timeforce

    Does anyone use Sage HRMS and Timeforce together? If so how is the integration? Do you like Timeforce?
  • Updating PTO GL Balance

    As companies accrue PTO in HRMS, the financial liability is also accrued (we are integrating to Sage 100 ERP). But that liability is a function of the hours and the CURRENT pay rate. So, when an employee gets a raise, the GL accounts account needs another…
  • Step rates

    Hi I am looking for someone who has experience working with Step Rates that I can have a phone conversation with.
  • FUTA wages don't match Schedule A FUTA wages

    The FUTA taxable wages from form 940 do not match the FUTA taxable on Schedule A form 940. I can tie the gross wages and payments in excess of $7,000 back to payroll, but I cannot figure out how the number that is listed on Schedule A is being calculated…