Sage Construction & Real Estate

I am attempting to create a Power BI report with some of the data from Sage. It needs to pull data about the job checklist items. However, for some reason the Checklist_12 item is not updating in the replicator database (The one we use to push Sage data…

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…

We use AL Mobile for timesheet entry. When jobs and cost codes are entered in Job Cost, they are imported into AL Mobile at regular times during the day. If they are set to unstarted, they aren't imported; I manually change the status to "in progress…

Why is Timberscan and Sage not matching in the units column after a Commitment CO?

Can you update vendor information in Excel and have it import back to Sage? If yes, how?

Can you change vendor master files (ie: Inactive) via Excel and import back to Sage (Easier and faster) if so how? I know I did this years ago but with all the version upgrades it must look totally different.

We started experiencing this issue 2 days ago and it seems that we are unable to get past the error. When trying to make a payment in Sage AP, my user gets the following error when trying to submit: This program is about to close. See the journal in the…

All of our jobs have disappeared from Timberscan and we can no longer select for routing. Any advice?

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 …

I work for a software dev company that is setting up an application for a client. They have been using the Timberline Data driver (using ttsimba.dll) to create an ODBC DSN to their Sage 300 CRE data in Access and run some update queries. We are replacing…

I am trying to import a .txt file that seems to be correct, but all lines are rejecting with the reason "non printable character found (fld 1, col 1)." I have checked and double-checked my file, but cannot figure out why or what "non printable character…

Is there an easier way to upload specifications? Plans have Burst feature, but specifications do not. Is there something similar?

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…

We are trying to move closed jobs in PJ (Project Management) to an archive folder to reduce the size of our database, We have tried multiple times with no success. Things that we have tried. 1- set up a new dummy company to move to 2. tried to move…

In the 'files to backup' instructions, every module says to include the 'User.frm (in the Formula folder).' We do not have a 'Formula' folder. I have done a filename search for user.frm in our entire live data folder but no results were returned. Where…

I have tested this in completely separate workspaces (different clients, different provinces, different computers) and am getting a similar result. V 25.3.84.0 - Canada In enter credit card receipts; no vendor, but select a job; in the AP lines, enter…

I use Excel VBA macros to update vairous tables. I have an Excel spreadsheet to update the ACA Dependents database for my 1095 preparation. Despite the SQL query only selecting one record for updating, when I update records it updates numerous records…

My database that was setup when I bought the system had the pricing in units, an earlier question on here was answered by the Gary gentleman that seems to answer most of these. I tried to create a new database so I could select the crew pricing in hours…

I have completed the newest version of Sage 100 Contractor YE proceedures. I have a clean PR audit. Updated and done every item the instructions say. Yet when I try to Archive 2023 PR "Unable to remove payroll company database, the archive company has…

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!

Good day everyone Can someone please tell me the best way to archive estimating files, and store them on the hard drive to maybe retrieve later. I am thinking of storing the estimate by year and of course the Database would have to be store also.…

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…

Sage Database Administrator 25 and Windows Server 2012 We are currently in the process of purchacing a new server. Sage Database Administrator 25 "SDA25" will not run on Windows Server 2012 "WS12" Problem Closing Payroll for end of year requires Open…

Hello everyone, I am trying to import items into a database. I have exported them into a CSV file within Sage Estimating, but I can not find out where you can import them. I was trying to merge 2 databases with the database editor, but they have different…

Hello all.... I am receiving this error once every few days on every workstation. I have to restart the server and everything is fine. It usually does it in the middle of the night. We recently installed a new server. Any ideas?