• 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…
  • Can Sage import the BIM from a REVIT model?

    All of our custom home designs are in REVIT. Is there a mechanism to import the BIM from REVIT into Sage?
  • Earnings and Payroll Don't Match

    From 5-2-1 Employees, we have an employee whose Earnings show $875 more than their Payroll totals. (the two Buttons at the lower left) Report 5-1-9-31 (YTD Earnings) is $875 higher than Report 5-1-2-41 (Payroll Check Register Totals) How is this even…
  • 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…
  • How do I create a backup of my data v19.x and earlier?

    Subject is KB article title; the ID# is 17467 Anyway, the article says to copy the Company Folder, while you are logged into the company. Why? What is the difference if you copy the folder while Sage isn't even running? Continuing: The Help…
  • 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?
  • 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…
  • unable to open

    No company lists showing when I open. Initially drive Z was not showing on the drop-down list. Mapped the drive and now it is showing but when I select drive Z it says "Unable to locate required program directories. Please select another drive."
  • 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…
  • Closing payroll year and no historical data

    Hello, I followed the steps to closing payroll and under show archives it lists the 2014 payroll file. When I open the file there is no data also when I was about to post the payroll for 2015 there is no more historical data in Sage for any year. I was…
  • Database Issues with v 19.5

    Is anyone having issues after upgrading to 19.5? My outside contractor who logs into our server remotely keeps getting kicked out with an Error "Unable to continue: A database error occurred: Error 50_90613 Locking File Invalid or Unknown Error Code"…
  • 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?
  • Use of SQL in Sage 100 Contractor Report Writer

    Can anyone tell me how to create a calculated field that has a SQL statement bringing in data from an unrelated table? I've looked at fields on other reports that I think are doing approximately the same thing but when I modify the SQL statement I keep…