• Are First and Last Names needed for printing or eFiling 1099s?

    I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Work Ticket Printing Error

    There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …
  • Payroll Tax Update - Prompts, but then there is no data to print.

    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…
  • Rehired Employee Missing Check History

    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…
  • Q2 2021 941 Form issues

    Good Day, I was trying to file the Q2 2021 941 Form and it is stopping me due to red boxes on line 19 & 20. Both boxes are asking for a dollar amount of qualified health plan expenses before April 1, 2021 for Covid. But we do not track this. So I really…
  • Purchase Order Printing

    When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order? Thanks
  • PII fields in formula Payroll

    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…
  • COVID wages on W2

    Client running W2s - it appears that any COVID wages (setup with proper Tax Rule as designated by Sage documentation) are not being included in Medicare/SS wages. When viewed in Sage 100, the wages show under the OTHER, not the std SS/Mcare. I ASSUMED…
  • Can I pull a report of employees' federal and state W-4 status?

    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…
  • Check history reporting in Sage 100 v2019.

    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…
  • Multiple Payroll Entries for an Employee

    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
  • More suggestions for Payroll changes

    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…
  • Employee Listing in Payroll (2.19) is now double-spaced.

    We just upgraded to Sage 100 2019 and the Employee Listing in Payroll (2.19) is now double-spaced. Is there an option to print this report single-spaced?
  • Invoice total and Final balance due on AR invoices don't match

    Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
  • Silent ODBC on terminal server

    Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…
  • Job Cost Report Showing Mark-Up Labor and Contractor's Fee

    We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…
  • Payroll deductions

    Deductions are automatically calculated but at times when an employee is on vacation, deductions are not calculated for that week for that employee. They are entered manually next pay period in addition to the automatically calculated deductions. What…
  • Business Insights Reporter Wizard Payroll Hang

    I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
  • MAS90 and Excel 2013

    Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled. Thanks for your help!