• SQL Server Crashes

    Is any one else having issues with SQL crashing in the middle of the day, just randomly? I can be working fine all day, and not necessarily be working in SAGE and I get an error message "Failed to connect to the specified SQL Server. Connection to the…
  • 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!
  • Sage 100 contractor error... you are not a user in this database

    Hello all.... I am receiving this error once every few days on every workstation. I have to restart the server and everything is fine. It usually does it in the middle of the night. We recently installed a new server. Any ideas?
  • 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…
  • can SAGE 100 Contractor Database Admin connect to a remote sqlserver

    Can you run the database admin on a workstation and connect it to the SQL server remotely
  • Unable to authorize new license server

    I'm trying to setup a new Database and License server for our Sage 100 Contractor, I need to test the new server to make sure we can use it on our network but I'm stomped. I Deauthorized the old License server (showed 2 seats) and stopped the Sage Hosting…
  • Sage 100 Contractor 24.1 - New Important Notes feature

    This is a great new feature, but has a significant flaw. The important note uses the same field in the database, so therefore an important note prints on all documents where a note filed is already used on a printed form. The means that if you want…
  • Database error

    How did you get this resolved? I just purchased and received the download link. Setup users and database. First time I login it says must upgrade database. I go to upgrade database. In SQL I get an error and it won’t upgrade. In windows it just runs forever…
  • Database Upgrade Issue

    New Sage 100 Contractor User. I just installed the software (single user, accessing software & database directly from server, no network). When logging in to Sage 100 it says I need to upgrade the database. When I try to upgrade the database in Database…
  • Connect Purchase Order Header to Job Cost Number

    What tables connect the Purchase order Header to the Job Cost Number ? Also: Is there a PDF document on the tables and their relationships? Thank you,
  • Data Dump

    Good Morning, Is there a simple way to do a data dump of Basic G&A invoice into an excel spreadsheet? Second Question... how do you remove a customer from the aging payable report that shows up with a zero blanace due? Thanks! Jenn
  • Sage Contractor 100 - Database Admin

    FormerMember
    FormerMember
    Our Database Admin for Sage Contractor 100 wont allow us to archive 2018 payroll. The dropdown menu does not have our company listed. It does elsewhere, but not under the "archive payroll data" link in the left column. Any help is appreciated. Thanks
  • SQL Database size

    Greetings, As we attach more and more documents in Sage of course the database grows. It appears that the size limit for SQL 2014 Express is 10gb. Our current company file is 12gb. How is that working? I would guess that at some point we would have…
  • How to migrate data v. 19.7 or earlier to data v. 19.8 ?

    FormerMember
    FormerMember
    When I installed Sage 100 Contractor v.20.7, I migrated my data for my active companies. Not a problem. Everything is running smoothly. However, I forgot about my archive companies. I now need to get into an archive company. When I tried using the Data…
  • In 3.9 Unitary Billing, how do I correct the Unitary Price after an initial save?

    FormerMember
    FormerMember
    I realized subsequent to manually entering the line items that I could have imported the information over. I caught my error prior to saving but saved the information thinking I could go back and update as needed which I now realize is wrong. How do I…
  • database version #s don't match the version # of the DB Admin?

    why don't the database version #s match the version # of the DB Admin? It's confusing to users, IT people, etc.
  • Two company files - Overwriting reports Issue

    Hi, We are working on two company files, each with their own separate logos, and reports. The reports are linked which is causing us to overwrite the other company reports. Editing one company report overrides the other company report. How do…
  • Incorrect GL on Payroll

    Hello, What is the best way for me to adjust an incorrect GL created by payroll? I can't void each payroll record and create a new record since it's associated with a posted T&M Invoice. This issue is the Payroll Calculations (5-3-1) were crediting…
  • Job Cost and Burden Rate

    When you run a Job Cost report, it only includes the hourly or salary rate for the employee from the payroll. Where can I add or increase to compensate for each employee's burden rate without interfering with the employee's pay rate for payroll processing…
  • Project List

    Hello, I wanted to know if there is a way to associate or list all personnel involved in one place in the Job record, i.e. project managers/architects/vendors/sub contractors? I want to be able to create a list or report for each job that lists everyone…
  • Setting up a Job in Sage

    Hello, I currently have a job is set up in Sage 3 - 5, I want to know if there is a way to limit who can access or view this one particular job?
  • Company List - Active vs Archives

    My Archive list shows only archived companies; however, my active list shows both actives and archives, including my latest 2013 archived file. Any idea how to move these files to the correct location when viewing the Company List?