• AP Report

    We pay vendors on 45 day terms. Can I run a report pulling only invoices greater than or equal to 45 days from invoice date?
  • AP Aging Report - Invoice Date

    Hi all! I am new to Sage 100, but I have been navigating it pretty well for about three weeks. The question I have is, how can I make changes on what pulls up when I run an AP aging report? My report right now, does give invoice dates, it only gives…
  • Calculate only actual hours worked after 5pm

    Is there a way to calculate/include only the actual hours worked after 5pm on the dispatch tab of a work order for a report?
  • Calculating an average value

    I'm writing a custom report and the client needs the average actual hours on billed work orders for a date selection. I am able to count the number of records, but not able to divide the total actual hours by the total number of records. Has anyone done…
  • Payroll report for 401(k) contributions

    Does anyone know if there is a report that lists employees and their contributions to 401(k) by month?
  • Report Writer - how to filter by date?

    Hello, I am trying to build a report in the Report Writer to pull fields from the A/R Invoice Lines table. However, I would like to pull data only from a certain date range. Does anyone know how to add a filter in the Report Writer to only pull from…
  • report writing variables order in pop-up screen

    When in Report Writer, and using variables, how to set the order the variables show up in the pop-up screen The order changes randomly. Need to keep the order fixed that makes more sense. In this case 1. From Period, 2. To Period, 3. From Year, 4…
  • Sage 100 Contractor Payroll Report with Listing Employee Payrates & Payroll Calculations

    Does anyone know if there's a report in Sage 100 Contractor that will show the Employee Payrates & Payroll Calculations?
  • Printing and Drilling into sec

    I am have a problem drilling into detail information on reports, when I want to look at more detail in a report the system stops responding and the I get this message and closes Sage 100 Contractor Canadian Any Suggestions would help, I have sent…
  • Pay Statement at menu 5-2-8 listing union calcs for one employee but not the other but we can see them on his payroll record

    Just witnessed a client who is running union payroll, but the Pay Statement is missing data on some employees in the calculations/deductions section. Both records are final computed but not posted. Both have 0000 as the check number. One employee shows…
  • Check Design

    I am having issues getting Sage to work with my business checks. I have been able to make Sage serviceable but there are a few items that I can't figure out for the life of me. Honestly I am not sure why I can't find any information on these issues due…
  • Reports

    I am having my books certified by a CPA and she is aksing for a report that shows contract totals and change orders by year. Does anyone know if there is a report that does this? If so what it is, or can it be designed?
  • Voided transaction log

    Hi, I am working on the closeout package for 2023, I know a it late, however I am having issues matching the trial balance apparently some transactions were voided after everything was sent to the CPA. I need a way to a report with voided transactions…
  • Stored Material Presently Stored in Sage 100 Contractor

    Regarding the stored material in 3-7 Progress Billing, we are getting many complaints from our clients when we remove the previously stored amounts by entering the negative and positive. It adds into the column under the "This Application Total". The…
  • Parts Listing 9-1-1

    When creating a list of Parts, SAGE includes all parts ever utilized. Is there a way to only list ACTIVE Parts? For example, in other screens there are options to filter a report by only Active Jobs or Current Employees. I do not see such an option…
  • We recently migrated one of our customers to a new server and now they are reporting very slow printing.

    Hello, we recently migrated one of our customers to a new server and now they are reporting very slow printing. I Googled and found a reference to a KB 100949 that may be the information we are looking for. However it can't be located. I found this…
  • Client Average Days to Pay Report

    I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,
  • Crystal Reports and Sage 100 Contractor

    How can I add a custom crystal report into a Sage 100 Contractor menu screen?
  • County Request for list of subs/paid amounts/tax ID's for 2023

    One of our local counties is requesting a list of subcontractor's, Tax ID and amount paid for 2023 for their jurisdiction. Can I run a report for this?
  • Monthly Income Statement

    We are new to Sage 100. We are trying to run a report that shows what we invoiced, and any payments/debits made. We ran report 2-3-21. However, that report is showing every invoice we received for the month even though it wasn't paid. Some of our credit…
  • Accountant asking for a list of Revenue for the year by Customer.

    Sage 100 Contractor. Where would I pull this type of report from? If I go into the 3-6 and choose a specific client and click on the payment button those payment total for that year are different than if I run the Report 3-1-2 78. So where do I find a…
  • Job Period Aging report 3-1-3-46

    When I print this job period aging report for the period Dec 2023, the report displays the retainage in the aging portion of the report instead of the retainage column, but only for jobs that we received the retainage payment in January 2024. Since…
  • Aletering a custom report

    Reposrt 05-02-08-61 report I would like summarized by employee and grand totals. I have done it before, but saved as a shared report. We got a new server mid last year and I lost the report. I need it for an audit due on Feb 1, 2024. I know it is simple…
  • Is there any way to get a Union Benefit Report where I can select which benefit calculations I want under the paygroup?

    Our monthly union benefit payment is split and 9 of the benefit calculations get paid to one place and 3 get paid to another. As far as I can see the Union Reports (for ex. 5-1-7-31) total the benefits by paygroup and unfortunately the report is not modifiable…
  • 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?