• 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?
  • W3

    What report can I run to tie into the W-3 form?
  • Report Designer

    Does anyone have a way of pulling specified text from within an alpha field, from right to left? Example: Job Description field contains: Hudson - Model I want to report to be able look through all job descriptions and identify which ones have 'Model…
  • 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…
  • Gross wages and hours report for the prior year

    How do I get the Gross wages and hours report for the prior year and is there one that also includes 401k, Roth and loans on it?
  • Payroll Expense Check Only not on Check Recap

    Doing payroll and for one employee, I'm only paying them for an expense due. The $250 expense shows up on my time journal, Payroll Post Checks Report and the actual direct deposit check printed out. But when I look at my Check Recap by Employee, which…
  • How to record reissuance of check from third party (Avid Exchange) refund to not overstate 1099 vendor totals

    My company uses Avid Exchange to cut checks. We have a check that got outstanding for too long and Avid refunded us the money. How do I reissue the check without overstating the vendor totals for 1099 reporting purposes. Here are the problems I came across…
  • 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…
  • Cost Codes last used

    Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?
  • 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…
  • Job Cost Accounts Receivable Paid Report

    I'm looking for a report in Job Cost that shows what we've invoiced to a particular job, when it was paid, invoice number, etc. The Job Cost/ Receivables Aging by Job report only shows open invoices. Once the invoice is paid, it is removed off of the…
  • 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…
  • Payroll

    I have posted my checks but the report is showing nothing was posted. I am unable to print reports under "current" because there are none? How would i fix this problem? Is there a way I can go back and find out what happened? I think what i did was I…
  • Job summary JTD balance is not matching trial balance

    Hi, I'm closing month and job summary balance does not match with trial balance. It only total month to date and does not include total from last month. Any idea how I can fix this? Thanks.
  • 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?
  • W-2's using Aatrix

    Noticed a couple of issues on this years W-2's... wondering if anyone else has noticed: 1. WA Long Term Care tax is listed as a local income tax. I wasn't aware that this was going to be listed separate on W-2's, is it supposed to be? 2. Out of State…
  • Report that shows wages for a particular job

    I m looking for a report that shows employee's name and wages for a particular job and a certain time frame.
  • How do I reprint a check

    I have a check that posted but did not print and I need to reprint it
  • Recently filed W2s are not listed in Aatrix History button

    We recently filed 2023 W2s and completed the process except printing the employee copies to pdf for our records. I understand that the Aatrix files are located inside the company folder on the server where they were processed and we can see them there…
  • Deleting Cost Codes

    If I have a Cost Code that we no longer use and I want to delete it from the list, what are the ramifications of doing this? If I ran a report where costs were associated to the Cost Code, would they disappear? Would to Description of this Cost Code…
  • Report 6-8-1 Cost To Complete Report is inaccurate

    I am using Sage 100 Contractor 25.3.72.0 The program will not allow this version to be entered when attempting to set up a new support case. The program will not allow uploading of images when attempting to set up a new support case. The program…
  • Printing job statements is cutting off paid dates

    Report 3-4-21 (at least in the Canadian edition) is cutting off the dates when you print the payments. This has been happening for a while, but we were hoping it would get fixed in a subsequent release
  • Job Cost Report Missing Entry

    On the Job Cost Report for one of my jobs, the Subcontract total for a specific cost code is missing the amount of one invoice. The invoice was correctly put to the corresponding Commitment. The correct amount shows up on all other JC reports. But for…
  • 5-1-7 Union Report

    Hello, is there a way to make a copy of 5-1-7 report 31 (union report) to modify it?