• 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…
  • Client Average Days to Pay Report

    I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,
  • User defined "Number" option has no decimal places. Is this new?

    I'm sure I've used the usrdf1/usrdf2 in places and changed it to be a number value, but i have noticed lately that when i change it to number it is only accepting and integer and not a decimal. I know i can make custom fields but i avoid them as they…
  • Report Form- Check

    Hello, I have transferred Sage 100 from my old computer to a new computer and moved my customized forms for printed checks. In doing this step, I had to upgrade Sage from 23.3.23.0 to 25.3.98.0 I tried to pay a vendor using check. However, the spacing…
  • 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?
  • 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…
  • 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…
  • 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?
  • 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. …
  • 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
  • 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…
  • 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?
  • 13-6-21 Report List shows "Apex Format" on some reports

    Running 13-6-21 is a listing of all reports in Sage. Some reports are showing "Apex Format". Never seen that before. What is this?
  • Purchase Order Audit report - no sales tax

    The purchase order audit report does not include the sales tax in the received columns, even though it has been inputted during accounts payable data entry against the PO. Can this be corrected?
  • How to Create a Local Services (LST) Tax?

    How does one go about creating a Local Service Tax in Sage 100 Contractor? We operate out of Lancaster County in Pennsylvania and have been notified that in 2024 our township will levy a LST of $52.00 per year. We are told this should be withheld on a…
  • Report writing

    I am trying to write a report, i have a if then and select syntax. Does anybody know the correct code for the tmcdln.crtfid table/column I want the report to be able to select sum from the tmcdln.hrswrk based on a y in the tmcdln.crtfid column. …