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…

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.

Why is Timberscan and Sage not matching in the units column after a Commitment CO?

We started experiencing this issue 2 days ago and it seems that we are unable to get past the error. When trying to make a payment in Sage AP, my user gets the following error when trying to submit: This program is about to close. See the journal in the…

How do I import payroll data from an outside 3rd party (Foundation) into Sage 300 CRE?

I am getting this error when trying to update Job Custom fields through ODBC. Has anyone seen this or know how to determine what the error is? Michelle Outler

Hi! I have a new contract with 195 cost codes and values. Is it possible to upload a list of cost codes with the name and the budget instead of manually keying it in via a CN module?

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…

Hi all - we are trying to pull data directly from our current transaction tables and see that it only has transactions from 30 days prior. We have look at the new and batch transaction tables and those records are not there. Any idea on where this data…

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.

Is there a way to import revenue rates in the equipment module?

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?

Does Sage 300 CRE permit upload of batches of payable invoices from either Excel or CSV upload templates? Can an upload tool be built to import multiple supplier expense invoices at a time with a template?

We are exploring options to import an employee master file into sage 300 CRE. What are the sage specs needed to execute this import?

I have a bunch of excel files that ready from different AP, AR, JC etc tables using a User DSN with the Timberline Data driver. Prior to upgrading today, they all worked. Since the upgrade, I'm getting an error that the "required credential settings are…

- Is there a way to mass update active vendors to inactive status?

Hi, I have been told by sage support that ODBC and MS Access can be used to add employees to the payroll module, but professional services must be engaged. I am wondering if anyone has used powershell or another scripting tool to add employees.

I have 2 Cost Codes that have randomly stopped working for 2 users. I am the Admin and it won't let me use them for 1 specific job only. The other 2 users is for any project. Won't allow them to be used when entering a Change Order Request in Project…

Hello One of our workstations crashed and we have currently installed 20.5 version of Sage 300 CRE (there are no other versions on this workstation). The server is also on 20.5 which we upgraded from 18.4 to 20.5 In the workstation, the install completed…

Hey Sage experts, Can anyone provide an excel template or guidance in importing budget estimates into Sage from our excel job master. I’ve been able to create a working template for accounts payable which is great for credit cards and payroll. my…

I accidentally closed our contracts module twice, rolling it forward two months rather than one. How can I reopen the contracts module?

I am trying to establish a ODBC connection to Sage 300 using Powershell ODBC. I am getting below error. I have tried using the same username and password for importing via ODBC in MS Access and it works. What am I missing? Exception calling "Open…

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 300 Construction and Real Estate v20.3 After running “File Doctor” we notice several errors. I found the client record with the unprintable characters error and manually replaced the text without any special characters. A re-run of “File Doctor…

Dear team , When trying to generate a payment voucher using crystal report ,following error obtained.