• 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…
  • How to Use Query Input in a Calculated Field

    I want to show the beginning balance based on a starting date of a check date range in the report query. How would the value from the query field be used? Example: I want to show a running total of accrued vacation hours from each pay period. I need…
  • 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 Writer Question

    I am trying to write a report that includes information from the vendor certificate database. The report must also include the YTD vendor activity. The database that includes the YTD vendor activity isn't part of the primary database for the vendors.…