Sage Construction & Real Estate

In the 'files to backup' instructions, every module says to include the 'User.frm (in the Formula folder).' We do not have a 'Formula' folder. I have done a filename search for user.frm in our entire live data folder but no results were returned. Where…

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

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 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…

If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V

We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…

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 determine the best possible backup solutions for Sage 300 CRE. Is it possible to restore single Sage files from a Microsoft Shadow Copy? If so, what is the correct way to do that without disrupting the database? Is it possible to…

I'm not able to create full image backup of my sage machine, so I'm planning on recreating it in another server. The issue being, when I open up System Administrator and I click my company folder, it says, "You have not selected all of your company folders…

Manually performing a company backup works fine but the scheduled backup does not backup the CompanyData folder. Is this a permissions issue as the scheduled backup is running the scheduled task as SYSTEM?

Hello! Is there any way to inactivate terminated employees or get them to stop pulling into reports- same question applies to closing jobs? Currently we are archiving terminated employees (and jobs) to a separate data folder as they will pull into reports…

So I am trying to switch over to using System Administrator to do the backups (we just started using SQL Replicator) and the first back up failed because someone left Sage open at their desktop and I got an error about Master.qlm being open. This will…

I mistakenly upgraded all of my files from 9.8 to 13.1. In the process, a number of files could not be "renamed" and thus did not upgrade. I am unable to access job cost records and unable to process payments in Accounts Payable. The File Doctor report…

In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…

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…

Restoring from a System Administrator backup file from two days ago, using the System Administrator restore function, but as soon as the file is chosen, it kicks to a non-responsive state. I have let it run at least 5 hours and can't tell if anything…

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…

I am curious if anyone else is having issues with the Automatic Backup Feature failing in the System Administrator. I can backup manually just fine, but the auto backup gives me this error: 2018-12-25 20:00:00 Starting backup 2018-12-25 20:00:15 Folder…

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…

Can I delete printouts? Will this effect anything or cause loss of data? Is this a data file or simply an entry report for printing?

I'm running Sage 300 Construction and Real Eestate version 18 without SQL and tried to do a restore to eliminate an accounting error and received this 2018-08-15 14:36:46 Using backup file E:\backup180815_125258.zip 2018-08-15 14:36:46 Restoring global…

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…

Is there a way to retrieve data if server that Sage (Timberlime) was on was hit with Ransomware?

Somehow our Current.prt file was deleted and a new one was created when we processed a payroll on January 10, 2018. Now the Current.prt file contains only the data from that payroll. We use the File Tools>Copy function to back up our transaction and master…

I am hoping to find a way to safely log users out of Sage in order to prepare my server for daily backups. Everything I have read so far seems to depend on the users taking the initiative to log out of their applications at the end of the day, and then…