Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello,
I am trying to figure out how to create a custom Payroll earnings report to show the Department field, hours, and dollars from Payroll Data Entry. The stock Earnings report does not appear to report this information, only the department defined…
Have a client who needs to do some reporting for the state and the Check History Report seemed like a good place to start. HOWEVER, I have been unable to add UDFs from the Employee file at all (even non-encrypted fields) (they all show as blank), and…
Does anyone use Data Link for certified payrolls? Looking to see if someone has a custom report they can send me as a template, as the custom report I had is now gone because we updated servers and our IT guy didn't save my custom report.
Can someone modify the job cost code detail report for me?
I would like for the phase subtotal to show the variance between the cost and the revised estimate. I currently have a custom report that no longer works since we have upgraded to 2020 Version…
Hello, folks:
In our payroll module, the Employee Masterfile Audit Report doesn't capture changes to employee deductions, direct deposit bank accounts, or paystub emails or passwords. For years, our workaround has been to save screenshots of the change…
Sage 100c 2019 Standard. When I print a custom payroll crystal report I receive an error message that reads:
Error in File PR BPA CUSTOM
6352-15868-(107A04E2-6BCF-4F92-A9D7-89536928089E).rpt
Failed to retrieve data from the database.
Details:…
I'm creating a Crystal report and wanting only Job Billing History for a specific year. Currently using the selection
{JC_Job.LastBillDate} in Date (2020, 01, 01) to Date (2020, 12, 31),
but it is still including 2019 and earlier invoices?
Hi:
I have a client who just upgraded from 2017 to 2019 Sage 100 Advanced. We have updated her payroll check form. I am struggling with the stub lines.
If we change the amount of the lines I can fit all the deduction lines on the check form but…
Hi. I am trying to find a way to edit the formula in Crystal Reports that says {JC_InvoiceWrk.Description} . This will place the employee first and last name into our Job Cost invoice. However, prior to updating to the latest version (2019) of Sage, we…
How do you modify the description of Social Security to be FICA on the paycheck stub in Payroll 2.20? It does not appear to be a text field in Crystal Reports.
Is anyone having trouble with custom reports for timesheets in the new 2019 version?
We have a custom report created to pull only active employees, but when we print the report it is pulling all employees from the beginning of the business. However…
Is there a table to create a report that can give you info from the Time Off Register but after a payroll is updated? Looking for accrued hours and accrued hours used by posting date. (PR 2.20)
I read through the knowledgebase article below, but what is the field name for sick leave hours?
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=90774&sliceId=1&docLink=true&languageId=&isDocLink=true¤tmsID=MS_Customer&cmd…
The pension report does not show all information needed. Need to show gross wages for all employees irregardless if they contribute. Employment dates and other permanent info. Help
I'm trying to figure out if there's a way to maintain separate Payroll check stubs with the new Payroll. Currently (v2015) the client has the top stub printing 'as is' out-of-the-box, but the bottom stub contains a subreport with the PR7 (data entry)…
Hello,
Is there a way to add an earnings code to a custom payroll report in Sage 100 2018? I want to find out which employees has a specific earnings code. I’m not sure which table has earnings codes for each employee, or if that is available.
Thank…
We are looking for a more specific report (Employee Check History) that shows the Tax Profile Group (Work State) for each Earning code.
Trying to get to the actual State Taxable Wages for 2018 W-2.
Community,
Anyone out there an expert with MAS-90s/Crystal Reports reporting engine?
What I'm am trying to do is create a Job Cost Detail Report that allows me to select a date range and then print job costs by Job Number (participants) that have…
Is there any kind of translation between the old job cost tables and new job cost tables? I have a client that has several custom crystal reports that need to be updated with the new tables.
Thanks,
Suzanne.
Is there a report that I can run that will show me how much overtime has been worked on a specific job?
If not, what files will I need to create the report using Crystal Reports?
JC1, JC2, JC3, and PR_23?