• Custom Columns

    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?
  • Payroll Earnings Report Showing Departments Employees Worked In

    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…
  • Adding fields to Standard Sage PR report

    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…
  • UDF in Time Track that can get to Job Cost billing

    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…
  • Stub, Check, Stub format in payroll

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

    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.
  • Pass a Job Name to AR Aging Wrk using UDF?

    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.
  • PR v2.22.3 - Personal Exemptions in Employee Maintenance

    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…
  • The Cost Code is required mesage when editing UDF's on Estimate Lines

    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…
  • Job Cost Code Detail 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…
  • Full-time & part-time status not reportable fields?

    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…
  • Changes not captured in Employee Masterfile Audit Report

    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 100 Employee Data

    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:…
  • Job Cost billing history

    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?
  • Adding a UDF to the PR check form - PR v2.19 or v2.20

    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…
  • Payroll Check Form

    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…
  • Crystal Reporting - Formula

    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…
  • Modifying Tax Description on Paycheck in Payroll 2.20

    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?

    In the new payroll (2018+), which tables contains the PR_23 data for deduction code detail? Thanks
  • How do I add a custom report in Sage Payroll 2.20?

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

    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…
  • Time off accrued by posting date

    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)
  • Add sick leave hours to pay check stub in Version 2018+

    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…
  • TPA Pension report

    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
  • Comment Lines on Job Cost Invoice

    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…