• 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…
  • how to know which check form to select

    we either need to know which check form to select for our current stock of checks or how to know which checks to order and then which check forms to select. is there a way to see how each form displays? or how to we make selection?
  • 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…
  • 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…