• 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?
  • 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…
  • 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.
  • 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…
  • 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?
  • 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#…
  • 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…
  • Placing form footer on last page of AR Invoices automatically

    We sometimes have multi page AR invoices. Prior to my joining the company, reports for specific number of pages were created so our terms and total print on the last page.I'm making some changes that will result in having different invoices for different…
  • Cash Basis Custom Reports

    I have a lot of requests to write a cash basis custom report in Sage 100 Contractor. What needs to be included to be sure to get all the bases covered correctly for this type of report? Jim Schuett, Report Writer
  • Invoicing

    We are in environmental contractor, and need to create a way to enter information from a waste manifest (manifest number, brief waste description, volume, unit cost, extended cost) on our invoices. Most clients are requesting that line items are identified…
  • Report Writer decimal points

    If I want to change the number of decimals reported in a calculated field, how would I do that?
  • Sage 100 Contractor Report Writer

    The Report Store is in need of a Sage 100 Contractor Report Writer to fulfill a request from a client. Anyone here write reports? Namely a Workmen's Compensation Report? Please let me know. Thank you. The Report Store [email protected]
  • Custom Service Work Order that shows all client equipment and work order history for that client

    Has anyone created a custom service work order that includes all client equipment for that client's location as well as a history of the last 10 work orders for that location- I have a request for this work order to emulate the customer's old work order…