Sage Construction & Real Estate

Trying to get import time from a text file and we are getting this error. We aren't sure what needs to be changed. We were told we needed to have "DC" in the first column without a header. We have tried deleting and leaving blank and keeping it. Not sure…

Someone deleted our current GL and JC file last night. How do we resolve without losing what work was done today?

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.

Hello, I was wondering how I could transfer the invoice aging of one of our vendors over to an excel sheet, or how to copy that data from one of the AP modules.

I am trying to create an excel format to be able to copy & paste my mutipule distributions in the AP entry, second page.

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

Hello, i've database file. i need to load data in my sage cre 300. I've installed sage cre 300 in my local machine but not found database dump and database load application. Could you guys help here how to connect with this database? Thanks, …

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?

Good morning, We have our office on a payroll service outside of Sage. We worked with them to set up the weekly GL entries for us so we could import them rather than fat finger them in. I've only imported files into Job Cost so I was curious if anyone…

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?

I have a need to restore a backup from the end of 2021 into a new company in Sage 300 CRE. What would the process be to do that, without effecting the current production company. thanks v

We're trying to set-up a workstation which would allow a 3rd party company (via Microsoft Runtime Integration, etc) to read data off our 300 CRE via the creation of 64-bit ODBC or DSN ... eventual goal is to get our Sage CRE database sending data to an…

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…

We are using System Administrator to do scheduled, nightly backups of Sage 300 CRE. However, they are failing intermittently, seemingly because some people forget to close Sage applications on their desktops every night. As I'm sure any IT professional…

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

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…

Our company has purchased another company. We need to add their equipment to our equipment. Is there a way to import the EQ setup info for the equipment, or does each piece have to be manually entered?

We are looking into starting direct deposit for our employees. I have contacted our bank, CIBC Bank, regarding this and they said that Sage is compatible with the bank and that Sage should have a template that we could use to transmit our direct deposit…

Can anyone assist with a template for importing to Job Cost, including GL Only entries? Below is a snip of the fields we use. I currently import invoice in AP using an Excel template with Office Connector to convert to a .txt file but I cannot figure…

Good afternoon, We post Inventory Imports through the inventory module (Tools -> Import Issues), and its getting to the point where daily import postings will take 4+ hours a day just to post through. At this rate, we wont be able to post daily anymore…

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 issued a CO to an existing PO last week, printed and sent. It was there, I have the proof. This week the PO is not showing in a PO Log but the line items are showing under committed cost. I have no idea what happened. Any help would be appreciated.

We are currently finishing up our Open Enrollment using Arcoro, and I would like to import this data into Sage 300 CRE since the sync they are developing is not finished yet. We mainly need the selections they made, deduction ID's so payroll can run…

I could not download any templates from Help, but I am hoping that someone will share with me. We record 50+ entries for distributions daily and wanted to speed up the process by importing all the entries into Sage via csv file.