• 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…
  • Payroll errors in previous year are messing up 2024 payroll YTD calculations

    The answer is yes! Let me explain, I followed the year-end guide. I ran the audit, I repaired the errors listed in the audit, I ran the audit again to check for errors. There was zip, zero, zilch errors reported. I proceeded to close 2023 payroll. Everything…
  • 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…
  • 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…
  • 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…
  • 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…