• 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#…

  • Calculated field help

    I'm trying to calculate the average cost per hour by position in 6-1-3. This formula saves, but when I run it I get "Error in processing report. Error details: Incorrenct syntax near '.'."

    [SELECT SUM jobcst.cstamt FROM employ, jobcst…

  • Getting Different Results for Report Writer Calculated Field

    In Sage 100 Contractor, I have created a custom report with numerous calculated fields.  One of the fields calculates the total costs for a work order.  When I run the report and display on screen this calculated fields returns the expected results.  However…