Sage Construction & Real Estate

Is any one else having issues with SQL crashing in the middle of the day, just randomly? I can be working fine all day, and not necessarily be working in SAGE and I get an error message "Failed to connect to the specified SQL Server. Connection to the…

When users log in, getting warning about backups not being run in X amount of days. Looked at logs and seeing the following: 2024-03-11 01:00:05 [Company File Name] An error occurred running the nightly maintenance and backup 2024-03-11 01:00:05 …

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…

I have a very odd issue, in SC100 Database Administrator I can see my companies for tune up, etc., but when I select Archive Company Data, no companies show up in drop down list. Anyone ever seen this? Ideas on a fix? Thx!

I just did the year end update to Sage 100 Contractor from 24.3 to 25.x without realizing that my server was running WS2012. When I try to open Database Admin, it says the machine is capable of being the database server. Is there a way to roll back…

Hi, is there a way to export the data in 3.5, in table format, to Excel? Or any data lookup for that matter?

I'm getting the error that is attached when I run the Sage Payroll Archive for 2022. It seems there's a file already there, however when I checked I don't see it. Any thoughts? Thanks!

Hello, we are are construction company in Edmonton Alberta, Canada looking at different software options to automate our AP process. Some of those options require our accounting staff to be able to upload a CSV file or Excel File to sage. Does Sage…

History of Question: * The SAGE 100 Con database had over 30 companies in it and performance was "sluggish." * Backups were made of all companies and copied to another server for safekeeping. * A 2nd SQL instance was created and all companies between…

This is a great new feature, but has a significant flaw. The important note uses the same field in the database, so therefore an important note prints on all documents where a note filed is already used on a printed form. The means that if you want…

Work Order details mysteriously moving to an unrelated work order for a different client and deletes the values that were there. Any ideas on how this happens and what we can do to prevent it?

I have a large project I am billing T&M. I've been pulling reports from 6/1/4 thinking they would be the same as the T&M summary or journal. Turns out there is a difference. Can anyone tell me why these reports would not pull the same for costs? And which…

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…

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…

I'm trying to build a report that will allow me to select job costs for a list of jobs that have no work order assigned. How do I set the criteria to select null values?

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?

Sage 100 Contractor nightly back up has failed every night since we did our archive of prior year general ledger. How do find out what the problem is so that we can get the backups performing successfully again?

Every time I open Sage Contractor 100 (version 21.3.39.0) I get an error saying that the Sage file did not backup. Though when i check the backup schedule it is set to backup every night. And i can see the backup files in the backup folder. Is this…

After this latest update 21.3.39 Sage 100 Contractor, the service profitability reports are still not showing any cost data. When will this be corrected?

Sitting down to do all the year end stuff and I updated sage and upgraded my databases before closing the payroll year. Will this mess me up? What if anything should I do?

We are having to change our cost code format from 16 division to 50 division. Is there a way to bulk update the existing records with the new cost codes using SQL statements? If so, would you be able to recommend an expert to help with this? Regards…

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. ?

I'm trying to rearrange and sort the Unassigned Orders on the 11-3 Dispatch Board in the Service Receivables module of Sage 100 Contractor 2018. I see fields listed in the Work Order Display tab that I don't recognize: Customer PO, Service Area, Location…

When I installed Sage 100 Contractor v.20.7, I migrated my data for my active companies. Not a problem. Everything is running smoothly. However, I forgot about my archive companies. I now need to get into an archive company. When I tried using the Data…

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…