Sage HRMS

Is there a way to pull a report that includes all job history for each employee? I've tried creating a Secure Query with no luck. Guessing it may be able to be done in Crystal? Any advice is greatly appreciated!

Does anyone know how to build a report in HRMS which will show all employees that are missing one specific event code?

I thought I would re-post one of the questions asked from last week's webinar (Top 10 with Sage HRMS Support). This is a good question and I didn't want it to get overlooked. Can you explain the License Limit Alert in Sage HRMS? Click the Help…

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…

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…

Question: Can I get a copy of a training manual without enrolling in a class? Answer: If a manual is available for sale, then yes, you can order a hard (printed) copy or a electronic copy (eBook). There will be a cost associated with the purchase. …

Hi all! Here are the questions and their answers from the SAP Crystal Reports for Beginners Learning Series we held on February 20th. Thanks for attending and hope to see you in the next one! Question Asked Answer Given When we create…

SAP Crystal Reports for Sage HRMS connects you to data above and beyond the standard reports included with Sage HRMS by allowing you to create powerful, formatted reports. During this webinar we will use SAP Crystal Reports to extract the data you need…

Question: Why is an employee (for example a new hire) missing from the Pre-check Payroll Register Report in Sage HRMS? Answer: The most common reason is the pay frequency is incorrect on the Employee Payroll > Pay tab. If the pay frequency is correct…

When my client runs Secure Query, the report doesn't pull the requested fields. Client asked for: First Name,Last Name, Term Date, Term Type, Term Reason Filtered by terms in a date range Report returned: Active, Full name (last, first), Department…

I've noticed when I print the OSHA 300 Log Report, that it is pulling the employee's current job title rather than the job title at the time of injury. It appears to be pulling the job title from employee file rather than the Safety>OSHA tab.

Here is this weeks year end question: Transaction History is a way to make adjustments to reports and year end forms. Can you think of one report that these adjustments will not flow through to? Answer: Transaction History does not post to the…

Happy Monday all! Here are the questions and answers from our 12/5 Learning Series on SAP Crystal Reports. Keep 'em coming and hope to see you in the next one! Question Asked Answer Given I would like to know how to group more data…

Hello all! Thank you for joining us for our Learning Series on SAP Crystal Reports. Here are the answers to the questions you posted during the question. Fun fact: I had no idea that my call had dropped during answering these so these were actually…

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 am looking for a crystal report to be able to print earning statements using the following databases UPCHKD, UPCHKH, and UPEMPL that includes YTD totals.

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…

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.

My VETS4212 reports do not output accurate results in Sage HRMS. Does anyone have a suggestion as to how to get the summary data?

Hello! We are having issues with our Sage HRMS, a pop-up error message appears whenever we generate reports/print checks. The message reads as "abra32.exe has stopped working" We lodge a chat session and the technician said that they could not…

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…

Anyone know if Sage is working on update EEO 1 report to include salary information? This is to match the new requirements.

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…

Has anyone created an Crystal Reports XML and Web Services Connection to be used with a ESS View Builder view? I am looking for the Service, Port and Method values for the connection configuration. Thanks John

I am trying to write a crystal report to pull the information from the tax info from the payroll taxes tab. I have been trying to find the table the links to UPEMPT that holds the tax info which includes the pension plan for the W2 . I need to check…