• 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.
  • 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…
  • 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?
  • Sage 300 Construction - Job Cost Sheet Cost Code Collapsed

    When you run a Job Cost Report and some of the Cost Codes show no details and the JTD Cost column is 0.00 but the Remaining column has say $15,000.00. This tells me there are entries for that Cost Code (say Hvac - Rough in 10-18-010) but the report shows…
  • Phases Wip Reports

    We have been setting up phases in Sage 100 Contractor for each small job for a customer instead of setting up several small jobs. We then have been billing each phase. It is my understanding that we can not close the phases in sage 100 contractor. …
  • Estimates file listing

    Hello Is there a way to print out a listing of all our estimating projects? Using 22.1 SQL This would be handy for clean up before export files for archiving. Thanks anybody
  • Report Modification - for new payroll calculation

    I set up a new payroll calculation for a ROTH IRA. It works fine with payroll however I want to add it to one of my reports but can't find what the name of the destination field is. Can anyone help me with how to add this to my report? Thank you
  • 2024 Payroll

    Is any one having issues with the new 2024 YTD totals on salaried employees. I have a few, but not all salaried employees, that are taking the last P/R of 2023 + the First Payroll of 2024 in the YTD totals?
  • Quarterly Employee Count Report

    I have just run my Quarterly Payroll Reports. My Quarterly Employee Count Report is missing 4 employees. But these 4 missing employees have wages on the rest of the reports (Subject to Employer & Subject to Employee). The one thing in common with these…
  • Cost to Complete Report Inaccurate

    While reviewing a Cost to Compete Report we noted the Foundation Subcontractor had been paid only $415. On review he was paid the complete $7,500. The Job Summary Report shows the complete amount paid. Foundation Block 4 - Drywall 320.000 - Foundation…
  • Report Field

    There is a field in a Job Cost Report that I want in my Custom Report. Does any one know the name of this field "Jobcst^pytpnm"
  • Year-End: Print W2s before or after closing payroll?

    I'm finding contradicting information for when to process and print W-2s while reading all of Sage 100 Contractor's year-end checklists, guides, timelines, etc. I know that you need to install the year-end tax and software update before doing either…
  • T&M Billed by Cost Code Report?

    I have been trying to determine how to print a "Billed by Cost Code" report in Sage 100 on a T&M Project. This would be highly beneficial for budget update and client inquiries by cost code and would eliminate the need to derive the totals manually in…
  • Sales Lead in SM

    Does anyone use the Sales Lead feature in Service Management? I have set up Lead Types under Setup- Sales Lead. Now when I go to a work order, on the general tab, and use the drop down meanu for 'Sales Lead', nothing is listed. It says NONE. How can I…
  • Is there a way to edit Schedule of Values template?

    We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.
  • Subcontractor List

    How do I create a report that will show me a summary balance total paid to a Vendor/Subcontractor in a specific time period ?
  • Report showing employee hours and wages

    I m looking for a report that shows employees hours and wages
  • Job Cost Report - Paid Status

    Hello, What is the best way to produce a report that shows the job costs that have been paid on a job? I would think you could produce a Job Cost Journal (6-1-2) and filter by the job and by status ("paid"), but it does not allow me to choose a status…
  • Pending Invoice Report

    Hi, can someone tell me how to generate a report for pending prime invoices?