• 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…
  • Challenge Question (20200309) Topic: Smart Linking in SAP Crystal Reports

    If you’ve worked with linking tables in SAP Crystal Reports, you may remember having to delete the default link _zfilter. This brings me to this weeks question. How can you stop having _zfilter as the default linking field when you select more than one…
  • 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…
  • Upcoming Training – June 8th through June 12th, 2015

    Curious about what training is coming up? MONDAY June 8 th we have SAP Crystal Reports - Level I: Laying the Foundation It starts at 9:30 AM ET and is a 7 hour instructor led virtual classroom course delivered online. SAP® Crystal Reports for Sage…
  • 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…
  • Upcoming Training - May 11th through May 15th, 2015

    Curious about what training is coming up? If you don’t have a lot of time, but want to learn about Crystal Report next week we have three classes that will interest you; each is a 2 hour realtime learning with instructor. MONDAY May 11 th we have SAP…
  • Upcoming Training - May 4th through May 8th, 2015

    Curious about what training is coming up? Well, here is what we have for the week of May 4th through May 8th! IF you have Sage HRMS Employee Self Service (ESS)? If you do, you may be interested in two courses coming up next week. Next Monday/Tuesday…
  • Available Training the week of April 13 through April 17

    Curious about what training is coming up? Well, here is what we have for the week of April 13 - 17 ! MONDAY April 13 we have ES - Reporting for Sage Employee Self Service It starts at 1PM ET and is a 4 hour virtual classroom, instructor led course…
  • Available Training the week of April 6 through April 10

    Curious about what training is coming up? Well, here is what we have for the week of April 6 - 10! MONDAY April 6 we have SAP Crystal Reports - Level 1C: Producing Reports from Scratch It starts at 1PM ET and is a 2 hour instructor led course delivered…
  • Available Training the week of March 30 through April 3

    Curious about what training is coming up? Well, here is what we have for the week of March 30 –April 3! MONDAY March 30 th we have Managing Employee HR Data with Sage HRMS Employee Toolbar . It starts at 1PM ET and is a 2 hour instructor led course…