• Removal of an archived company in database administration

    I would like to remove some of the archived data companies in SQL. When ever I upgrade or update the product, I have to update the older Archived databases. Is there a method for removing those companies and storing? I may at some point in the future…
  • Importing Data

    Is there anyway to import anything into Sage 100 Contractor? Certainly there is some mechanism for migrating data from QuickBooks or Excel to Sage 100... right?
  • AR Sales Tax District field Randomly being filled

    FormerMember
    FormerMember
    We are seeing a strange thing happening and wondering if this has happened to any one else. Occasionally, we are seeing strange entries in our AR Sales Tax District field in AR Jobs. These entries do not match the project location. We are removing them…
  • Archiving old data

    FormerMember
    FormerMember
    Hello my system is running very slow and it seems things aren't posting very quickly-especially in AR. Someone stated that I needed to Archive my old data. Would someone know how to help me through this? Thank you.
  • Sage 100 Contractor nightly back up

    Sage 100 Contractor nightly back up has failed every night since we did our archive of prior year general ledger. How do find out what the problem is so that we can get the backups performing successfully again?
  • 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
  • Keep getting error that Sage file did not backup.

    Every time I open Sage Contractor 100 (version 21.3.39.0) I get an error saying that the Sage file did not backup. Though when i check the backup schedule it is set to backup every night. And i can see the backup files in the backup folder. Is this…
  • Service Profitability Reports STILL NO COST DATA

    FormerMember
    FormerMember
    After this latest update 21.3.39 Sage 100 Contractor, the service profitability reports are still not showing any cost data. When will this be corrected?
  • What am I supposed to do when I click on Sage Chat and this comes up: The page cannot be displayed because an internal server error has occurred.

    The page cannot be displayed because an internal server error has occurred. I cannot do anything with my Sage Admin software on the server either. I'm totally locked up. What's going on with Sage? Why can't I chat either?
  • Downloaded the newest sage update before running payroll close...

    Sitting down to do all the year end stuff and I updated sage and upgraded my databases before closing the payroll year. Will this mess me up? What if anything should I do?
  • Updating Cost Codes

    We are having to change our cost code format from 16 division to 50 division. Is there a way to bulk update the existing records with the new cost codes using SQL statements? If so, would you be able to recommend an expert to help with this? Regards…
  • What tools are available to import data into Sage 100 Contractor?

    What tools are available to import data into Sage 100 Contractor? Any lists? Customers, Vendors, Employees etc Any transactions? Customer history ie work orders, etc. ?
  • Renaming Cost Codes on existing jobs

    FormerMember
    FormerMember
    Hi, Is there an upload for renaming the description of cost codes on existing jobs? For axample renaming all the 3-125 cost codes from "Pot Plants" to 3-125 "Plants" accross all jobs. Doing it manually / individually would take a while as there are…
  • Looking for 3 fields on Sage 100 Contractor Service Receivables screens that are listed in the S/R database

    I'm trying to rearrange and sort the Unassigned Orders on the 11-3 Dispatch Board in the Service Receivables module of Sage 100 Contractor 2018. I see fields listed in the Work Order Display tab that I don't recognize: Customer PO, Service Area, Location…
  • 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…
  • Sage 100 Contractor v 20.7 Sage100Con Folder

    Hi Sage City, Does anyone know why Sage created this new Sage100Con folder? Can our company file that's in this Sage100Con folder be deleted without any problems?
  • 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…
  • What is the HCSS Template in Budget Import Option?

    In Sage 100 Contractor, 6-2 Budget, Options, Import, one option is to import an HCSS Template. What is an HCSS Template>
  • Unitary Proposals from Takeoffs

    Is there a way to import Unitary Proposal from Takeoffs? Or how do I create a Unitary Proposal Template to use for import?
  • 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.
  • Sage 100 Contractor Payroll Archive

    This is our first year of using Sage 100. When we did the payroll archive, we tried to remove terminated employees. It stated "These employees have references elsewhere in the database preventing their removal". Can someone please tell me what types of…
  • Migrating from version 19.8, 29286 issues encountered

    FormerMember
    FormerMember
    Hello, we're trying to upgrade our old Sage 100 Contractor from 19.8 to the newest version. I tried to follow the instructions and got to "Migrate Company Data" in the Database Administration for Sage 100 Contractor program. I select the folder with the…
  • Sage 100 company nightly backup

    Hello Helpies there, I have sage 100 contractor and there are 15 total companies in it. Out of these 15 only 3 are setup for nightly backup. I am not able to find out way to add remaining 12 to backup. Can some one please help. TIA. Raj…
  • Connecting Crystal Reports 2016 to Sage 100 Contractor v20.5

    FormerMember
    FormerMember
    I'm trying to connect Crystal Reports 2012 to Sage 100 Contractor v20.5 via an ODBC connection. I have created the ODBC connection successfully by allowing access from other applications (DAT->Advanced Settings...->Advanced SQL Server Settings->Edit Approval…