• 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 Sage 100 Contractor

    In need of a better system to do our payroll. We are currently using About Time AKA WorkMax. They are SLOW and mess up all the time. My filed guys hate this system and complain every day. There is an issue every week. Most of the time it kicks them out…
  • 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…
  • issue with DB copy

    I want to make a copy of my Sage 100 DB so we can start user acceptance testing. When I copied my LIVE database that contains financials and job, etc, my copy doesn't have any financials. It's like the copy function only selected certain tables (vendor…
  • 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?
  • 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…
  • 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…
  • 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."
  • 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…