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

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…

I'm working alongside a freelance estimator who's working on a portion of the project from a remote location. His version of Sage is one version older than the one in our server. Would it be possible to merge both estimates into one? If so, how…

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…

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?

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…

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…

We are a custom homebuilder. I have multiple base house plan estimate takeoff files with roughly 300 items in each. I'd like to load them into base estimate templates in SQL estimating with an easier method than just doing an item takeoff manually if…

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 am building new crew rate tables and desire to create individual adders to each labor rate, currently I have 20 plus added columns that are driven from the base rate. I am curious is there any way to download these columns of cost into the job cost…

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…

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…

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…

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…