Sage Construction & Real Estate

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…

After this latest update 21.3.39 Sage 100 Contractor, the service profitability reports are still not showing any cost data. When will this be corrected?

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…

Year end is always a pain but this year upgrading from 15 to 16 I have trouble upgrading files in Inventory. The error is Field 'useunits' must have a value. So somewhere in the Inventory database the default value for "useunits" has not established or…

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…

From 5-2-1 Employees, we have an employee whose Earnings show $875 more than their Payroll totals. (the two Buttons at the lower left) Report 5-1-9-31 (YTD Earnings) is $875 higher than Report 5-1-2-41 (Payroll Check Register Totals) How is this even…

No company lists showing when I open. Initially drive Z was not showing on the drop-down list. Mapped the drive and now it is showing but when I select drive Z it says "Unable to locate required program directories. Please select another drive."

In PJ we are unable to attach/link a change order to a commitment. We open the commitment and link a change order, and when we do a print preview the information does not show. We were able to get one to link save and print, out of 10. Not sure why…

Is anyone having issues after upgrading to 19.5? My outside contractor who logs into our server remotely keeps getting kicked out with an Error "Unable to continue: A database error occurred: Error 50_90613 Locking File Invalid or Unknown Error Code"…

In advance of closing 1099 year, backed up data which indentified corrupted files. Ran file doctor and saved to file. Tried to view file and received the following error message: Unable to load the company infomation from the system database due to the…