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…

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!

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?

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…

Can you run the database admin on a workstation and connect it to the SQL server remotely

I am currently running Sage Paperless on SQL 2014 ver 12.0.2269.0 (released 7/14/2015). My internal vulnerability scans have flagged this version as unsupported and it likely contains several security vulnerabilities. What is the process for updating…

Does Sage prevent creating one vendor with multiple accounts if you enter a duplicate EIN number? I have two companies that have the same name except one is an LLC at the end and one is an INC. They are two different companies, but it brought up the importance…

I'm trying to setup a new Database and License server for our Sage 100 Contractor, I need to test the new server to make sure we can use it on our network but I'm stomped. I Deauthorized the old License server (showed 2 seats) and stopped the Sage Hosting…

Does anyone know how I can get the Data Dictionary for VM (Service Manager)?

Good Day Can anyone tell me why in Sage Data Base editor there a green check mark beside the database file, see below. And how do we remove it ? Using SQL 21.1 Thank you for any answer

When I enter contract values in Job Central and then click 'Finish' I get the attached error. I'm unable to save any changes. Please advise. I'm on Windows 11 if that matters.

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…

When trying to use Power BI to connect to the Sage 300 CRE (22.2) do I select SQL server, MySQL, BI Connector or something else?

I have 14 material items that are linked together. Is there a way to unlink all items in this group that does not require editing each one?

We are currently running in Sage CRE version 20.4, our cyber security has highlighted that the Pervasive SQL Version was outdated (Pervasive PSQL Version Vulnerability CVE-2017-11757) in the software. Any acknowledgement and remediation plan for this…

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;…

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…

I am trying to create a condition that looks at one of our checklist items in JC setup. We have all the items names in JC setup with what they are for, but they are displaying in MYA under the JC Jobs table as checklist 1, checklist 2, etc. instead of…

How did you get this resolved? I just purchased and received the download link. Setup users and database. First time I login it says must upgrade database. I go to upgrade database. In SQL I get an error and it won’t upgrade. In windows it just runs forever…

New Sage 100 Contractor User. I just installed the software (single user, accessing software & database directly from server, no network). When logging in to Sage 100 it says I need to upgrade the database. When I try to upgrade the database in Database…

What table in the DB has all the Job Setup Change Management information - looking for the table that has the markup grid

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

Hi Everyone! Our roofing company regularly has to submit safety pre-qualification info when we bid for a project. We have places that we can store this information for company wide access (OneDrive, network drives, etc.), but I was curious to see if…

We have two databases for payroll. We have an employee who will be switching jobs and therefore needs to be moved from one database to the other. Is there a way to merge his records at year-end so that he still only gets one W-2, or will we need to provide…