Sage Construction & Real Estate

I want to move my past/terminated employees over to the archive folder, however there is already an archived employee with the same number of one I am looking to move. Any thoughts on what will happen, or what I can to to keep the records for both individuals…

Hey everyone, First time poster here because we are in desperate need for assistance. Here's the rundown... - We had been using Sage 17.1 for 2 years until Nov. 2019. With it, we have the SQL Replicator running all the time, and though "Scheduled…

I use a lot of queries to grab data out of Sage. I have and use the PO/Commitments application. Can someone tell me what table or where the table is to look at data there? I can only find data in the Job after the PO has been committed and sent to Job…

I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are. So, if a formula is being used, is it used in another formula, report, etc. I have 100's of formulas & reports…

Does anyone know of a report that shows number of hours per year per cost code? Example how many hours at superintentant were logged in 2018?

Hi all, I don't have experience with sage, but am tasked with writing some automation for exporting sage 300 construction service manager data into salesforce. I'm here to ask mostly about the best way to export the data out of service manager - I've…

Hello All, I have a problem I have been researching lately regarding slow queries over ODBC to our sage server. I have seen people with similar issues on other sites, but no real solutions.... We have a web server that uses PHP to query several database…

I am using Sage 300 CRE 13.1.24 (13.1.0 Rev 7). I am using Crystal Reports XI Release 2 for Sage. I have my ODBC setup using my 32-bit ODBC administrator. My problem is that when I try to create a new report, I can add any file I want in my database to…

Hi folks, We're going to be upgrading to v13.1 here soon and I was wondering if anyone can confirm if Pervasive is the only option available for a database? I say a thread where someone said they were on SQL Server, I would prefer to use that over Pervasive…

Hi guys/ladies, We are just converting our accounting project management to BuilderMT and Sage 300 CRE. Has anyone converted from QuickBooks and migrated their data from QB to Sage? If you did, how did you do it? Who did you use to do it? Rick M

I am starting out on Sage 300 Construction and Real Estate. Timberline/Sage is installed and I have a username and password to access the system. I can also connect via Office Connector to the data and therefore have an data connection string. I would…