• Can you use Crystal Reports to change the value of fields in Sage 300 CRE...?

    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
  • Creating upload files for Arcoro...

    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…
  • Open Closed Contracts Module

    I accidentally closed our contracts module twice, rolling it forward two months rather than one. How can I reopen the contracts module?
  • Backup Questions

    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…
  • error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…
  • Creating a Backup - Curious on a few things.

    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…
  • Scheduled Backup using System Administrator

    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?
  • Inactivate Employees or Close Jobs

    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…
  • System Administrator Automatic Backup-Files Open

    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…
  • Any way to empty Sage 300 CRE log file?

    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…
  • PO archive and upgrade?

    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…
  • Ts.ctl file in use during backup vs 17.1.8

    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…