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.

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

I'm noticing that when I go back to certain takeoffs in estimating that the bid item's data will be deleted even after saving... why?? I go back to an estimate, expecting to see the final bid amount, but often it is lower than what I remember. When…

Error retrieving data for an estimate. Error: "Error Staging Data No data was returned by Sage Estimating. This could be caused if the estimate you selected is currently open (locked) in Sage Estimating. Close the estimate and then try again…

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

If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V

We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…

Hello, this has happened on two of the take off templates I have been working on while trying to add bid items. I have attached a screen shot of where I have been adding the bid items in the take off templates also. Is this what could be causing the error…

I have a field that I'd like to generate in Sage that is based on other manually entered values in Sage WBS codes. I could do this in excel utilizing a concatenate function, but I'd like to do it all in one place, if possible. Does anyone know if it's…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

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,

In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…

Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…

We recently upgraded from Pervasive to Sage 18.11. I am trying to update and also do some improvements in our existing database(Job Cost Codes or Job Phase,NOT PRICE CODE!). There are no way to make a report for all Job Codes plus Descriptions into…

I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB. In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db. Class name is: com.pervasive.jdbc.v2.Driver. URL is in…

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…

Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7): Common Tasks - Tools - File Tools - Backup The "ts.ctl" file is in use when we try to use file tools to backup our data. The knowledgebase leads you to various methods…

Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

Is there a way to copy a set of 100 cells (100 rows deep by 1 column wide) and paste those into excel? Right now doing it one by one and sure takes a long time..... Thank you

Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…

Aloha fellow Sage City dwellers. I've had trouble upgrading SQL databases after installing new SQL Instance for latest versions. No problem using Mgmt Console Tools to restore the backups, but Estimating locks up after failing to upgrade. Has anyone…

Yesterday, I decided to update to the latest version of Sage 100 Contractor (version 20.2.35.0) When I went to Upgrade the database I was denied permissions to access folders (yes, I was logged on as my system admin). After two unhelpful hours on the…

I have an order in 11-2 Service Receivables that originally had parts, quantities and price in the Invoice Details grid - that calculated up to a total that was emailed as a Quote to a Client. Today, the grid on the Invoice Details tab for that order…

We installed Estimating 13.1 two weeks ago and are now experiencing some problems with the Pervasive Database Pre-Load not starting up when the computer starts. We have verified that the Pervasive Pre-Load is in the Start Menu and have done a reinstallation…