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.

I would like to get some insight on Sage's product called "Paperless" vs. Timberscan? Any comments?

I would like to integration third party system with Sage 100 Contractor using API to sync data between systems. Does Sage 100 Contractor have API?

Hi folks, We have been searching for purchasing software that integrates with Sage 300 CRE for quite some time and it looks like Agora Systems may be a good fit for us. We don't currently use the purchasing module; we manually verify POs and enter everything…

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…

I am trying to connect to Sage 300 CRE via JDBC. I understand that Sage is built on pervasive and I am able to connect to the default pervasive database called demodata and read tables. i am looking for guide to read Sage specific tables using this…

Does Sage 300 have an active integration with Microsoft Access, or is it a manual process? Which users rights are necessary to modify the integration, and change what is sent from Sage 300 to MS Access?

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…

The last HR software question in the discussion was 3 years old. My HR Department is asking me if Sage HRMS and/or Sage ESS will work with Sage 100 Contractor. Does anyone that currently uses 100 Contractor use another HR software package that integrates…

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…

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…

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…

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…

Hey Folks: Can anyone tell me about their experience working with Syscon or About Time as an alternative to Sage Service Operations as their mobile resource management tool? We have reached an impasse with SSO in terms of collecting time on equipment…

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…

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…

Does anyone have any experience working with Concur Travel and Expenses software? Has anyone looked at integrating the Concur product with Sage 300 CRE?

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…