Sage Construction & Real Estate

When using the Sage Estimating Database editor through Remote Desktop / Terminal Server the software is very slow and laggy. When using on our actual office network it does not have this issue. Any ideas why this is happening or how to fix?

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…

A general and important question When you insert a item into the estimate from the database the change date is the current date. What I want to know can a column for the data base change date be visible in the estimate file. This would make it easier…

Hello, Mistakenly updated Sage 100 Contractor to the wrong update version without the payroll year closed. I rolled back the program on the computers which is fine. It now states the tax table for this year. Do I need to roll back on the server…

We have a diverse amount of experience in our estimating department. Our assemblies have always been high level without a ton of details because we sub out 90% of the work. We have many junior estimators that have worked in the subcontracting world and…

We have a legacy standard database that is set as a 3 digit phase code suffix, example 03000.000. We would like to convert it to a 2 digit suffix, example: 030000.00. I tried to merge a 2 digit and 3 digit but the merge routine rejected the operation;…

Error: Knowledgebase article says: "Error: Exception of type System.OutOfMemoryException was thrown running the 6-1-2 report (version 19 and earlier) Enhance export to MS Excel engine Exception of type System.OutofMemoryException was thrown Job…

I have updated few "JC phase" items in the estimate and then tried to update these item in "DATA Base" with utilizing " I have gone through all steps from inserting "Update DB" col and check make the items and also followed all steps after. …

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…

So, I have been experimenting with Backup-Restore functions of the SQL databases. I was able to restore backup files from my primary workstation with its own SQL Instance to the emergency workstation with its own Instance of SQL Server. It went well enough…

Is it possible to group items in Sage Estimating (Database Editor)? Basically, I am using the CSI Breakdown. The CSI uses a 4-tier system. 080000 - Openings (TIER 1) (GROUP) 085000 - Windows (TIER 2) (PHASE) 085100 - Metal Windows (TIER 3…

I created Crews/Resources/Rate tables etc in a template estimate that I start from in each of my estimates. The other estimators prefer the way I have set things up and management likes the way I set up the rate tables so they can easily go in and update…

Is it at all possible to terminate connections to the database without running a full tune up? It seems like the functionality is there and there are times we need to run in exclusivity mode just for short periods of time without waiting 20 minutes for…

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…

I want to add some addons that are based on the project duration that I enter in Estimate info. I have entered the duration on the Estimate info as " 3 weeks" I have set up an addon with a cost basis of "Project Info" The source is the Estimate…

Does anyone have a lead on someone who could convert custom crystal reports that work with the pervasive database versions of estimating, to reports that will work with SQL? It would seem the reports have to be rebuilt once you upgrade to SQL. Quite frustrating…

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