• 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…
  • Is there a way to edit Schedule of Values template?

    We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.
  • 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…
  • A/R Invoice numbering

    How do I change the default numbering for the A/R invoicing. I need to change the numbering and then have the next invoice be a sequential (next) number. I cannot find how to make this change.
  • 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…
  • 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…
  • 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…
  • Report Writer decimal points

    If I want to change the number of decimals reported in a calculated field, how would I do that?