Sage 100

In payroll records it gives you the option to select columns to show but can you you not save them that way? Will it not let you customize the columns the way you want them?

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…

I needed a comment in Time Track Entry for work performed. I added a UDF and was able to post that through to the Job Transaction file in Job Cost. How can I get this to pull into Job Cost billing so it can print on the invoice? I can't find any way to…

In SAGE 2020 is there anyway to format the top and bottom stub differently in Stub, check, stub format in SAGE 100 2020?

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.

I would like to see the Job Name, in addition to the Job Number, for each invoice, on my AR Aging Report. Using UDF links and customize the Crystal AR Aging Report.

Iowa client is asking about personal STATE exemptions. The IA W4 certificate allows a personal exemption option. In the IA set up, pers exemptions are greyed out. The HELP text mentions that this field is available only if the tax group allows personal…

Hello! Hopefully someone can help with this. We have a client who wants to use Estimates in the Job Cost module. We have created some UDF's on the Estimate Detail table to allow them to add in needed informaiton that they will be prinitng on their paperwork…

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, all - is the answer right in front of my face and I can't see it? Neither the Employee Listing (in Payroll Reports) and Custom Lookup View (in Payroll Employee Maintenance) seem to report part-time status in EE Maintenance; this status is indicated…

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?

Client wants to pick from two banks to issue PR checks from. Since they use blank check stock, I added a second text field for the bank address information. Doing this in AP, I suppress the text fields based on the bank code. But I do not see the bank…

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.

In the new payroll (2018+), which tables contains the PR_23 data for deduction code detail? Thanks

Is there a guide or discussion thread that instructs a user on how to add a custom report to Sage Payroll 2.20?

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&currentmsID=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

Our client has a series of comments, anywhere from 2 to 6, that they print at the beginning of their invoices. They are on 2016 and are currently entering all of the job cost information in SO Invoice Data Entry to take advantage of the /C lines. They…