• 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…
  • After you final compute payroll, does it matter what order you do the rest (Creating Direct Deposit File, Posting Payroll to GL & Emailing Deposit Notices)?

    I was told in training that I had to email deposit notices first, then create a NACHA file through the Direct Deposit File Manager, then post payroll to GL. They seemed very adamant it had to be done in that order but reading through Sage help and trying…
  • Company missing in select company to archive

    I have a very odd issue, in SC100 Database Administrator I can see my companies for tune up, etc., but when I select Archive Company Data, no companies show up in drop down list. Anyone ever seen this? Ideas on a fix? Thx!
  • CPP calculating incorrectly for 2024 payrolls

    I've checked on 5 different databases/servers/installs and none of them are calculating the exempt amount from the CPP. I have checked it against the CRA payroll calculator and my manual calculations. The workaround for now was to change the cheque…
  • 5-1-1-22 Raise History Not showing Correctly

    When running 5-1-1-22, the raise history field is not showing correctly, yet when going into the employee file and using the Raise History button, it shows as it is supposed to.
  • Roll Back Update to Database Administrator

    I just did the year end update to Sage 100 Contractor from 24.3 to 25.x without realizing that my server was running WS2012. When I try to open Database Admin, it says the machine is capable of being the database server. Is there a way to roll back…
  • Year-End: Print W2s before or after closing payroll?

    I'm finding contradicting information for when to process and print W-2s while reading all of Sage 100 Contractor's year-end checklists, guides, timelines, etc. I know that you need to install the year-end tax and software update before doing either…
  • Add Sales Tax to T&M Billing

    I have a Sales Tax District assigned in the 3-5 Jobs, however when I go to print my T&M invoice there is no tax line item. Please help.
  • AR Invoice List

    Hey All, We are still new to Sage 100. I can run a report to see what we invoiced for each month. (3-1-2 Report # 21). However, I was wanting to run a report to show everything thus far this year. January till November. Is there a way to do that? To…
  • How can I apply Credit Card purchases to jobs?

    I have tried to add in through AP. However, when I go to Job Cost, the receipts are not showing. I also tried to add in under 4-7-3 and still not coming up under job cost. We need to be able to see total job cost for the specific job and gross profit…
  • Finance Charge Invoice Numbering

    Does anyone know how the invoice numbers for finance charges are determined? Previously the finance charges for our jobs have defaulted as double digits and the finance charges for our work orders have been triple digits. Last month the finance charges…
  • Employee Records-Filing Exempt Local Payroll Tax

    Hello- we created Oregon as a local payroll tax. Oregon allows our employees to file exempt as we are a in a reciprocal state. How do I enter the employee tax withholding as exempt? I have attempted to enter Sage 5-2-1 with marital status and exempt 99…
  • Emailing Customer Statements

    Hello, We are having issues with the ability to email our customers their statements every month. It gives us a error message of, "Unable to send email via Outlook: Sorry, something went wrong. You may want to try again." It does then show up in…
  • Purchase Order Audit report - no sales tax

    The purchase order audit report does not include the sales tax in the received columns, even though it has been inputted during accounts payable data entry against the PO. Can this be corrected?
  • Purchase Orders - Received doesn't match AP Invoices applied

    The total amount shown as 'received' in the bottom part of the purchase order screen is significantly higher than the total amount of invoices applied against the purchase order. Any ideas?
  • Setting up quarterly/monthly service contracts in Sage 100 Contractor

    We're just learning the program (very basic grasp at this point) but can't seem to figure out how a monthly/quarterly regular service contract might get set up. We've been told that each contract would need to be set up as a job/project? Is this something…
  • Report writing

    I am trying to write a report, i have a if then and select syntax. Does anybody know the correct code for the tmcdln.crtfid table/column I want the report to be able to select sum from the tmcdln.hrswrk based on a y in the tmcdln.crtfid column. …
  • 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?
  • 6-12 - Project Work Center - Any way to copy custom menu from one machine/user to another? Or can a custom menu be made the default for all users?

    Hello, we're working on Sage 100 Contractor version 25.1.330.0. Is there any way to copy a custom Project Work Center menu from one device/user to another or to make the custom menu the default for all users?
  • How to boot someone out of Sage

    Hi everyone, We have some user are are idle on Sage. I would like to know how to boot someone out of Sage. Thank you. Josue
  • Yr-to-date Gross Wage Calculation in Sage Contractor 100 Canadian Version

    How can I change the calculation for Yr-to-date Gross Wages on a pay stub to include Calculation Add ons? I've tried a few different calculations & modifications but can't seem to find the correct one, so on our pay stubs it's not reflecting the additional…
  • Second Company

    We are starting a second company that will be a new LLC. What is the best way to show movement of funds between the two companies?
  • Sage Field Operations compatibility with Sage 100 Contractor v25.2

    Sage Field Operations (SFO) has been tested with Version 25.2 of Sage 100 Contractor and deemed to be compatible with that new version. However, in version 25.2 of Sage 100 Contractor a new feature that allows custom pay types to be created for Payroll…
  • why is screen 3-5 missing units from approved change orders?

    We entered original budget with units (quantities) and a few approved change orders with quantities. But original quantities and only part of the change order units are appearing in the 3-5 budget screen. The 3-5 budget screen is leaving off part of the…
  • TUG 2023 Fall Workshop Extended Early Bird Pricing!

    Wow! Early Bird Pricing for TUG’s 2023 Fall Workshop , Nov. 6 & 7 Extended thru Oct. 16 Join colleagues and Sage consultants for hands-on labs and sessions for Sage 100 Contractor and Sage Estimating! Share knowledge and experiences Collaborate…