Sage Construction & Real Estate

I am in need of a purchase order import template. I have tried using the help section to create one with no luck. Our consultant doesn't have one and I cannot work backwards by exporting because I get the following error: Can someone please send me…

I can't find a report or a notification set up for Invoices marked as On Hold in Paperless. We had a problem with an invoice being approved while still marked as on hold and it never got exported. Where do I find just the invoices that are On-Hold?

Would like to know if there are going to be changes to the Importing of Flatfile. We currently use this to integrate Job Costs with Sage 300 CRE and Prolog. Also, What are the impacts/look changes for the EndUser with this update from 17 to 18?

Just out of curiosity does anyone have older macros from 16 and before that has been brought over to 17 and was able to successfully use them with 18.2?

I am trying to view via search/report what assemblies/items are being used on all current Estimates. Something that can be viewed using a report/search if it exists. That way if I need to know what all estimates contain a certain item/assembly it will…

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 have been able to find the import layout for AR Invoice Import but it looks as if this is using contract based type billing for the imports. Is there anyway to import an invoice as a quick bill with standard items on it?

I would like to access Sage 300 CRE data via Excel. I do not have Office Connector, and I am not an IT wiz, but know my way around Excel. I tried to setup an ODBC connection but could not make it work. Someone said that there was a MS 365 solution? What…

I have created a data warehouse database within the Sage 300 CRE SQL replicated databases to merge some of the data from both Timberline and Timberscan for reporting. I have been able to write the Crystal Report and have it work when previewing from with…

Good afternoon, Seeing if anyone has found a good way to account for contract allowances. If a contract has a built in allowance it's noted in the original contract, but trying to fid the best way to track and bill against that allowance. I haven't…

Hello! When we enter commitment change orders, they are saved with a "Pending" status until management approves them to be issued. We have one commitment change order that was updated as approved, but the totals on the commitment are now incorrect. …

I am having an issue with a Crystal Report that I have pulling the data from the SQL replicated data. The data pulls when I run the report in both Crystal Reports and also when I run from within Sage from any of our companies. Upon having a user try and…

On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant

Sage300 CRE Version 17.1 Rev6 We had a power issue and the database server shut down unexpectedly during operations. After the server was powered on again, several users complained they were getting errors in the application. We tried restarting the…

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…

Any users out there importing approved Subcontractor AP Invoices from ProCore? Here is a link to a video showing how it works. www.youtube.com/watch 1)Procore provides the ability for the Project Mgr to review and approve a Subcontractor's application…

My TB is out of balance by $.72. When I try to run a Totals by Bath report in GL, it freezes up every time before it even gets to the report screen. Has anyone had this issue, and how do we fix it?

We have one user of the Purchasing Module POIV that gets the error Not Responding when opening the program. It hangs on configuring database. This doesn't happen with our Win7 users only the Win10 user. We are using Sage300CRE version 16.1. Any ideas…

I'm trying to create a formula for a date stamp time condition but cannot seem to figure out the format used for a time constant. For example: Time Stamp > 14:30:00 doesn't work. What is the proper format for a time constant?

Over the years, having several accountants, I have discovered that some of them rather than simply changing an address for a customer or vendor would enter a completely new customer/vender with a new ID! For example, one customer is actually set up 8…

We are about to enter into agreements for several multi-phased projects. The way I see it, we have the following three options when setting this up in Sage 300 CRE: Multiple Contracts, matched to Multiple Jobs; Single Contract, with multiple Jobs;…

We have several jobs/contracts with allowance items, that once fulfilled we like to no longer have posting to that cost code or extra. Is there a way to block or at least get an error message that a particular cost code or extra on a particular job is…

I am on 18.2.2 and use Report Designer (not crystal reports). How do I get the lien waiver to show the check amount when paying more that one requisition on one check?

AVIF Support Services / Flowpoint is seeking a full-time Accountant. It is mandatory that the Accountant have at least five (5) years of accounting experience using Sage 300 CRE accounting software. No applicant will be considered for this position that…

Has anyone else experienced after installing a new workstation client since upgrading from (15 to 16) and (16 to 17) they have an issue when accessing the company data? Refers to a Pervasive error 94. In both cases we need to rename the Local Machine…