• Power BI

    We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.
  • Payroll / Equipment Tracking Systems and importing data

    We are coming up on our renewal date with ExakTime. It does an adequate job of tracking labor hours but we need a system that tracks equipment hours and is capable of importing them to Sage 100 Contractor. Does anyone have experience and recommendations…
  • Cannot seem to import saved takeoff templates to new jobs

    I have a takeoff template for a home model that is very similar to many other home models we have. I have saved the template as a template file on my local desktop but I cant get the thing to import? None of the templates that were made show up as an…
  • error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…
  • 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…
  • 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>
  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
  • Permissions on attachment folders changed with upgrade to version 20.2.35

    Yesterday, I decided to update to the latest version of Sage 100 Contractor (version 20.2.35.0) When I went to Upgrade the database I was denied permissions to access folders (yes, I was logged on as my system admin). After two unhelpful hours on the…
  • Import credit card transactions?

    Is there a way to download credit card transactions from my bank and import them into Sage 100 Contractor using a csv or xls file? Is there an add-on module that would allow this?
  • Invoice Details Disappeared but Grid Total Remained in 11-2 Service Receivables module

    I have an order in 11-2 Service Receivables that originally had parts, quantities and price in the Invoice Details grid - that calculated up to a total that was emailed as a Quote to a Client. Today, the grid on the Invoice Details tab for that order…