Sage Construction & Real Estate

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…

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…

The Sage 300 CRE C: drive filled up and caused the Data folders to look as if the rights had been removed. It was caused by .slg files like this: "C:\Users\Public\Documents\GlobalSettings\SageReplicator\4148 - 131882004005307603.slg" There were only…

Created a New Company for testing purposes - copied all applicable files into new company per online instructions. Everything in new company seems to look OK, except the GL accounts had a different format (the - and . appear to have been removed). In…

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…

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…