• 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…
  • Sage 100 Contractor Modify Report - Define Selection Criteria - Enable 'Or' logic

    When modifying a report, there is an option to enable 'or' logic in the selection criteria. I'm having a hard time setting this up and wanted to see if anyone has had success with this.
  • Report modification

    I need to modify the 5-1-8-41 report (and name it 5-1-8-05) with the following modifications: * Remove PREMIUM hours column and replace with OTHER hours column (to include sick, vaca, holiday as we don't use premium) * Add OVERTIME WAGE column …