Sage 100

Our work comp policy is 11/1-10/31. Has anyone found a way to create payroll reports spanning 2 calendar years for audit purposes?

Have a client using the standard Sage 100 feature for certified payroll reporting. When trying to open Payroll - Report - Certified Payroll Reporting. Instead of the correct Aatrix screen opening, the following screen opens. The client has to uninstall…

Report 5-1-2-56. I have an auditor asking for this report. I didn't even know reports had numbers. I have no idea how to create report sexcept for the ones that come standard. It's a check stub information report.

When running certified payroll reports using the Aatrix integration, is there a way to save our company name, address, insurance info, employee info, etc. (all the red fields that have to be filled in) so that it doesn't have to be entered in manually…

Hi all, It's been a while since I posted on this subject (What does the Payroll Tax Update” do in the Sage 100 Payroll 2.x product?) , but I wanted to amend my original post with the following. Occasionally, there will be cloud Payroll Service updates…

We have an employee who has worked for us several times over the years. When we onboard a rehired employee, we use the same employee number. She has requested some older payroll data (2009-2013). I ran a Check History Report with a check date range from…

Created a report comparing Revised Estimated Cost to Actual Cost. The "sum" of the Revised Estimated Cost is giving me problems. When I try to "Sum" that field, it totals by the number of times the cost code is used...therefore the "sum" becomes overstated…

I am looking to create a report to show all outstanding receivables as of 12/31/2021 and that have been collected in 2022 to date.

good morning: what report can i run for all outstanding receivables as of 12/31/2021 that have been collected in 2022 -to-date?

How can we print a quarter-to-date, year-to-date payroll check history report for a specific ending date? Forgot to print these reports right after the last pay date of the month. Since then we processed the 1st payroll of the next month and now cannot…

We have a client that needs to run a Time Track Report by job number that includes time track entries for a month were some have not been updated along with some that have been moved to the history file. Has anyone come up with a way to combine the two…

Trying to do a simple formula combining the PR Employee last name with the suffix. Both fields are PII fields. When I run the report data formula only works if employee has a suffix so I had to place the last name field in the report and then cover it…

Any work-arounds for getting the payroll history for prior years? The client has year-end backup companies, but the "Retain Perpetual History" option was not checked; therefore the payroll check history report does not show any data in the 2019 version…

So. I have a client who wants just a simple Crystal report to print the employee and the email address used for their DD stubs. I find an email field in PR_Employee, PR_EmployeePIIWrk, and PR_EmployeeDocuments. I have setup a report that just dumps…

Looking at my company's Quarterly Tax Report and in the State and Federal total areas, the YTD Calculated Tax Totals do not match the YTD Tax Liability Totals. Shouldn't they be the same?

I'm looking for the following fields in a file in the V2019 job cost. In legacy, they were included in the JC1 file. I'm hoping I missed them when I attempted to find them in V2019. Can anyone assist? They are not in the new JC_Job file in V2019. PTDActualCost…

Trying to find a way to get a report or create a report in crystal that shows profitability by cost code. It seems every profit type report is by job. I see there's the job cost detail report and you can add the billing amount but it doesn't seem to be…

We have a client that is converting from Sage 2017 to Sage 2020. They do not own the Time Card module, but did have a Union Automation enhancement from Kissinger. They will still use that enhancement in the new version. DO they have to purchase and set…

I've looked through the payroll module overview and other sources and cannot determine whether employees' federal and state withholding elections (filing status, including exempt) from the W-4s are reportable fields. If some report, somewhere, captures…

Client just went live on v2019.3 w/ PR 2.20.2 (upgraded from 2017). In 2017, they configured an Earnings Code using Regular instead of Misc, and it can't be changed in the new version because it's been used. What are the ramifications of this setting…

I'm converting some old Crystal reports from Sage 100 v2017 to v2019. The reports from v2017 use the tables: PR_22PerpetChkHistoryHeader and PR_23PerptHistoryDetail These tables don't exist in v2019. What table(s) should I use in their place? I tried…

Sage 100 - P/R 2.20 After reviewing the Loan Forgiveness Application and Instructions, I am finding I need data which should be in P/R but am unable to locate. It appears all of the Reports are for quarter summaries and I need to access data from…

Good morning, We don't usually do 2 entries for employees in Payroll. If we need to do that to split COVID-19 pay and regular pay, will both entries show on the Payroll Data Entry Audit Report? Thanks, Brian

Based on feedback from clients: 1 - Deduction Report - have an option to do Monthly, not just Quarterly, and be able to do a whole year, not just one quarter at a time. Remember there was a Perpetual version of the old Deduction history report, and…

Client is questioning the Earnings listed on the Pension Plan History Report. Client feels that earnings that are not applicable to Pension deduction (car allowance, etc) are being included and should not be. Anyone confirm or deny?