• 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…
  • 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…
  • upgraded from 18.12 to 20.1 all report layouts show under layouts but they are all wrong

    We upgraded Estimating last night and now any report layout you choose the previous settings are gone
  • 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!
  • 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?