• 1094-B & 1095-B

    My predecessors (4 of them) never utilized Sage/ACA portion. We now need to file electronically. How do I "fix" every employee for 2023 hours so I can file?
  • reports affected by rptclc^clc in report forms and custom reports

    Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc. I have seen this before but not to this extent. It is massive. Has anyone else seen this before? Or know what causes this…
  • Service Days from Request to Invoice Report

    I was looking for a solid report for our service department efficiency and could not find anything I liked. I created a report which captures the number of days from call to schedule, schedule to invoice, and the total days from call to invoice. Enjoy…
  • Report Design: Report detail area (gray box) ghosting (duplicating itself) in report

    What caused, or how can I prevent, the gray box (report detail area) in the report form from duplicating itself (ghosting), usually in the bottom right side of the report when the report is run. First thought is there is another gray box, even just a…
  • Union Paygroup Report

    Hello All, We use the Union Paygroup Report (5-1-7-31) in Sage 100 Contractor to pull information for our monthly union remittance. This report can only be run by period end or check date. I'm looking for a way to run it for the entire month (i.e. 1st…
  • Adding % to reports

    Does anyone know if I am able to add % to a report? For example Job Cost Summary (6-1-4-31). Thanks.
  • Avery Label Templates

    I need to print shipping labels a 18 label per sheet template - Avery J8161 for example. How do I get this template into Sage 1010 Contractor 4.1.6 so I can proper export list to Microsoft Word? Thank you Brenda
  • Bank Rec Report

    Isn't there a basic bank rec report that will spell out the bank reconciliation? I have run 1-5-0-21, but the "account current balance" at the bottom of the report is very misleading, as it reflects today's GL balance instead of the GL balance at the…
  • Excel Friendly Reports

    Anyone have any luck modifying reports to be more Excel friendly? I'm used to pulling G/L details and Job Cost details into Excel to put them into PivotTables or Filter by specific jobs and/or codes, but the System reports have too many page breaks. It…
  • Cash flow statement based on budget

    I am looking for a cash flow statement that can be ran based off budget numbers entered into Sage 100C. I realize that this would be a custom report and would need criteria entered, ie AR & AP turnover, etc. Looking for ideas, a report writer, or utility…
  • Is your Aatrix tax forms update not completing or presenting an error?

    The Aatrix automatic updates this year-end may take longer to complete, please allow time for them to finish. For 2017 year end (W2, 1099 & 1095 (ACA)) filings, Aatrix now requires 3 different Microsoft redistributables. These files will be installed…
  • How do you pay your taxes? Cash or Accrual?

    This is our first year in sage, so as we are looking towards tax season we are curious how all of you pay your taxes. We have traditionally used Cash basis so now feel a little lost not seeing a cash income statement. So if you pay your taxes in Cash…
  • How to write SQL statement for percentage in subtotal and total rows?

    How to write SQL statement for percentage in subtotal and total rows? Getting % on detail rows is no problem, but when trying to get a % on the subtotal or total rows eludes me. Any help on this would be greatly appreciated. Thanks so much!
  • Payroll Summary for Workers Comp Audit

    I need to print a payroll summary, by employee, that shows gross payroll and overtime paid over a specific time period. For instance, For the period 1/1/13 - 4/30/13 Employee Gross Wages OT Wages John Doe 10000 425 Jane Doe 6500 0 Johnny Doe…
  • Subcontractor Application for Payment

    I am a Commercial General Contractor. I am new to Sage and am quite surprised to see Sage 100 doesn't have a stock Subcontractor Payment Application form. Typically, I have used these Forms to recap a Subs Progress in order to issue payment. We issue…
  • Re: Certified Payroll Reports, Displaying Work Classifications and Split Time

    Hi there, I am looking to find out about specifically Certified Payroll reporting. We use the standard DOL report, but it does not fill in the Work Classification. I would like to know if I can add that and how, and where the information pulls from…
  • Check Run report with detail

    I am looking for a Check run report that also includes the 4-2 line detail, specifically the GL account and dept. Is this possible through a report or query?
  • California DIR Certified Payroll Reporting

    Contractors in California received the following notice from the Department of Industrial Relations today (5/26/16): News Release No.: 2016-54 Date: May 19, 2016 Enforcement of the Requirement to Submit Electronic Certified Payroll Reports…
  • PDF Export

    Trying to export an Aatrix report and get Error -30 Printer not Activated. Anyone know how to fix this? Thanks, ~j
  • Printer not activated, Error -30

    Windows 7 Pro SP1 S100C 19.5.34 Aatrix wont print to S100C PDF Export. Assistance appreciated. Aloha, ~j
  • new CA DIR requirements for certified payroll reporting

    Brandi Lube The CA Dept of Industrial Relations has stopped accepting pdf files for reporting certified payroll reporting that has to be uploaded to their site. I am fielding multiple inquiries from customers on how to create these files from within…
  • Modify an Unmodifiable Report

    S100C 2014 US v19.5.34.0 The top of Report 6-1-7-31 displays "Job Superviso" and "Estimated Total at Completio." There is no button to modify the report. What would you suggest we do to get it to display "Job Supervisor" and "Estimated Total at Completion…
  • Job Hours Summary - Actual vs. Budget

    I am trying to figure out a report that I can run for job hours. I need for it to show actual hours versus budget hours by cost code in summary form. Similar to 6-1-4-21, but instead of cost, I need hours. Does this report exist?