• Why is my custom report using "or" for the selection criteria?

    I have multiple selection criteria for my report but instead of pulling data that fits all selection criteria it is pulling in all data that fits any of them. I know there is a box that says enable or logic but it is not checked and even if I do check…
  • Need help with a select statement for adding total sales to job cost journal?

    I'm new to S100C and report modifying so not sure if this is even possible but I am trying to add just a total AR invoice amount to the bottom of the modified job cost journal and it's not working. I have tried many versions of SELECT statements but can…
  • Lien Waivers - accounts payable

    When you cut a check and print a Lien Waiver, can you customize the form to include "paid to date" on a job for that vendor?
  • 6-12 - Project Work Center - Any way to copy custom menu from one machine/user to another? Or can a custom menu be made the default for all users?

    Hello, we're working on Sage 100 Contractor version 25.1.330.0. Is there any way to copy a custom Project Work Center menu from one device/user to another or to make the custom menu the default for all users?
  • Sage 100 Contractor Canada Report Modifications

    We have purchased Sage 100 Contractor - Canada about a year ago. it was an upgrade from Sage 50. we had great support setting up Sage 100 and transferring our account information from Sage 50. the person used for this has since retired and we are…
  • Custom Report Questions

    Hello Everyone! On report 6-1-4-31 Job Cost Summary ~ Long, there is not a 'Modify Report' button. I believe it is because when it was created, information was taken from multiple 'tables' and the reports that are editable in Sage 100 Contractor seem…
  • Create an Indirect Cost to Budget Variance Report

    Hello! I'm new to Sage City. I am very happy to have joined and I look forward to learning how to get the most out of the Sage 100 Contractor. I am trying to create a report based on 2-3-33, where it allows me to choose the accounts, and shows the…
  • I can print part barcodes, but how do we scan them?

    Is there a method in Sage 100 Contractor to scan a part number barcode to receive and track inventory?
  • Sage 100 and Buildertrend

    We are a home builder using Sage 100 for our accounting. Does anyone use Buildertrend for their construction management software? If so, how do you import / export information between the two? Thank you,
  • Sage 100 Contractor Job Costing Report

    Hello we have been using Sage 50 for a few years now and only recently have upgraded to Sage 100 Contractor as we felt we needed a more detailed job costing report and way of tracking our projects. wondering if there is a template, or help in developing…
  • Contract Summary by job report

    Has anyone ever created a report that shows all the contract summary information for multiple jobs? I've tried creating a report but I can't seem to access all that info in the report wizard.
  • Setting up Auto-Fill for Inventory Items

    Hello, I was wondering if there is a way to have certain inventory account numbers auto-fill. For example, I have a subaccount cell for commercial or residential jobs on screen 12-2 (Inventory Allocation). The jobs are marked commercial or residential…
  • Sage Consultant Switch

    Does anyone know if you can switch your consultant to a different vendor? Is it fairly easy? How does the yearly support subscription work after that, that just gets billed directly from Sage? Thank you, Lisa
  • Modify Accounts Payable Check Form (Template)

    When there are several check form designs with different bank accounts is there a way to review the check form designs (template) before printing to ensure the template with the correct bank account has been selected? In addition, I would like to…
  • SDK user defined field in Job module

    Hi All, I am trying to add the user-defined field in sage 100 contractors using SDK, Anyone knows how to achieve it using SDK? Thanks SF
  • How do I get a customized report to include the budgets from a Prime Change Order?

    We have a customized report done through Report Writer that someone no longer here did. Right now the budgets from a Prime Change Order are not adding into the Budget line. How do I get this report to work?
  • Access Level of Sage Users - What Does Your Company Do ?

    I'm curious to know how other companies use Sage. We currently have 1 person who can do everything - all posting, deleting, voiding, etc. This is also the only person who can cut checks and post adjusting entries straight to the general ledger. We have…
  • Multi Phase Job

    Good afternoon! We are beginning a project that will have multiple phases over multiple years. We will be fabricating spools and receiving material that will end up on this project at some point. The fabrication will be done at multiple sites and shipped…
  • Calculated Field for custom report form in 6-6-1 (POs) for POs issued through 11-2 (Work Orders)

    I am trying to write a calculated field expression that will pull in a Service Work Orders (11-2) location number and name, as well as the location address when there is a document# in the PO Document# field. If there is no Document# in the PO Document#…
  • Modifying default report forms

    My company operates 4 different Sage 100 Contractor companies, with different tax ids and and banks and logos and entity names. I'd like to customize the default system report and landscape report forms to get our branding on them, reduce our color print…
  • Report Showing AR Invoices Associated with Payment Applications

    I am trying to generate a report that lists not only the AR Invoices for a project but the number of the payment application (if applicable) that invoice is for. Example: Job # 9999, Invoice # 20001, Payment Application #1. I can not determine which fields…
  • Knowing how much time has been logged on a work order

    When looking at a service work order in Sage 100C, is there any way to tell if multiple employees had worked on this call? We're having issues not knowing whether there were previous visits, then billing the call and finding out after the fact there were…
  • Custom Developer REferral for Sage 100 Contractor

    Can anyone refer me to a competent custom developer for Sage 100 Contractor? Sage referred us to "Zoom Geeks" to create a script to migrate our transactions from our old COA into our new COA with new departments. It's been almost 7 months and we don…
  • Setting Up Jobs

    We work strictly government jobs and when work is issued, it's by a delivery order. We set up each delivery order individually so that certified payroll reports are pulled correctly. Is there another way of setting these up so we don't have such a large…
  • Can you edit cost types?

    Can you edit cost types? We only use 1-material and 4-subcontract. We would like to only have these options available.