Sage Construction & Real Estate

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.

Hello, i've database file. i need to load data in my sage cre 300. I've installed sage cre 300 in my local machine but not found database dump and database load application. Could you guys help here how to connect with this database? Thanks, …

Hello - I am struggling with the report writer and need some clarification (a long shot, since there is almost 0 documentation on the subject). I am proficient in T-SQL, so am confident in my ability to write queries, but can't get something very simple…

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…

We are having issues with our Procore Connector so we are trying to troubleshoot the issue. Procore is saying it is a Sage issue but since we can't get any support with this I am trying to rule out everything I can. We did review our Event Log and are…

I had a KB that described the process of deleting the replicated database(s) from the SQL server (compnaydata, izenda, etc) to start from a clean slate, can anyone point me to this KB. Thanks V

Sage Estimating version 20.2 Does anyone know if it is posssible to e-mail a project file to another Sage user without them have a copy of the database? And if so what files do we send and will they be able to open the file with there Sage Estimating…

We upgraded Estimating last night and now any report layout you choose the previous settings are gone

Hi My company is using Sage 300 CRE. I just wondering how should I install SQL into 300 CRE? I googled a lot online and I did not find exact step of how to insatll sql into sage 300CRE. Could anyone teach me how can I add or install or connect SQL…

Finding that the response of SQL Estimating is delayed when working with a Windows 10 machine (specifically when modifying a column with grouped items). Here is what we've tried/found so far: Working in an environment where the SQL Database is hosted…

Hey, Where can i get a DB Schema for Estimating? Support doesn't offer one, which is crazy. I'm trying to track down what fields are where so we can do some analytics of the data. Thanks,

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 we tried to update from 17 to 18.12 with Estimating. However, when we did this all of our Crystal Reports wont work.. We are using SQL for our databasing. (SAP Crystal Reports 2016 Support Pack 5) Version 14.2.5.2618 Is what were running for Crystal…

Does anyone know where I could find information for the syntax that Sage 100 Contractor report writer requires with respect to SQL. I am trying to write a report for Committed Costs that is different from the report included with Sage, so I need to write…

Totals Page/s: Format-Save. Has anyone on 18.12 been able to successfully save a Totals Page Template where the Format option was used to Align Text, Font Size/Color, etc.? My templates save with basic formatting like; reordering the predetermined Headings…

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?

Delete Person in the Address Book? Anyone been successful in deleting a Person from the AB in SQL? Apparently it can be done. However in practice....? Follow this LINK to the KB article.

We have experienced this before but it quit before figuring it out but now it is back....Estimating is slow to open application and then when trying to open an estimate, it goes to not responding and then will eventually open. Can not find anything that…

Hello, We are finally going to take the plunge and move over to the SQL version of Estimating but had a few simple (hopefully) questions that my Reseller is not being helpful with and I do not want to pay Sage to answer since it is basically just…

How to write SQL statement for percentage in subtotal and total rows? Getting % on detail rows is no problem, but when trying to get a % on the subtotal or total rows eludes me. Any help on this would be greatly appreciated. Thanks so much!

How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…

Can anyone tell me how to create a calculated field that has a SQL statement bringing in data from an unrelated table? I've looked at fields on other reports that I think are doing approximately the same thing but when I modify the SQL statement I keep…