• 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…
  • 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…
  • Different Pay Stubs for Different Companies in ESS

    We have two companies that we use HRMS and ESS for. One company is in California and has very specific rules on how to display SICK time on the pay stubs. I have different paycheck stubs for each company with the SICK and PTO times displayed differently…
  • Has anyone successfully modified the ESS pay stub Crystal Report?

    We are trying to change from using the earnings totals to using the gross pay totals on the ESS pdf. However, every time I change anything on the report (even just removing a text object), the print/post checks process gives an error that there are no…
  • 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…
  • 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???
  • 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.
  • Crystal Report linking ESS and HRMS

    I am trying to write a crystal report to pull answers to open enrollment questions from ESS. I am using the ESS table employee_open_enrollment_benefit_plan_answers to get the information, but how do I get the employee number and name from HRMS. I can…
  • 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…
  • Staying Compliant with Retirement Plan Administration in Sage HRMS

    Re-posted from DelphiaConsulting.com . If you administer a qualified retirement plan (e.g., 401(k), 403(b), SEP, SIMPLE IRA, etc.) under the Internal Revenue Services’ (IRS’) guidelines you must adhere to rather stringent compliance requirements. Non…
  • 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…