• 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.
  • 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…
  • 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…
  • 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…