Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Sage 300 typically uses a database backup system where you back up the entire database. Is it possible to extract specific period from the entire database, i.e. Jan 2020 to Dec 2021 only.
Hi everyone,
Im going to install new Sage 300 2024.1 in a new server but going to migrate Sage 300 ERP 2018 data to this. I already reviews information about new security enhancement through move ISM files to new databases (Vault and Store) and changes…
This is on my test machine (full local install). I already had 2023 PU4 with the enhanced security set-up. I decided to uninstall 2023 and install 2024. After installation, I go to DB setup and get the above error.
Yes, I can recreate the vault and…
I have a client that is running Sage 6.0A. I have SQL backs up both their company and system databases. When I try to login to the company, I get a message stating the the Company database is a later version than the system database.
How do I fix this…
Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…
We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…
Hi everyone,
We are just moving DBs of some Sage 300 customers to new database servers with SQL Server 2019 (Windows Server 2019). We are not going to upgrade Sage 300 or move applications to new server, just Databases. From SQL Server 2008 R2 to SQL…
I accidentally cleared all A/R Statistics instead of doing just the year-end activity. So now I'm in big trouble since we use that a lot. Does anyone know of a way to get it back without having to go to the backup? Or maybe an add-on I can purchase?
Hi All,
I just restore Sage Accpac 5.6A from old server to our new server (both database names are the same: "ACCPACSYS" & "ACCPACDAT").
After restore successfully and launch Sage Accpac ERP on server (on where Accpac 5.6A and its sql server database…
Hi all,
During a database load, I have encounter this error. No clear message so I don't know what is the cause and how to solve it. Below is the screenshot.
Can anyone help me please? Thank you.
Hi,
I'm an IT Manager of my company. My user deleted the Currency Rates by mistake and I already restored the data back to the table (CSCRD). But the Currency Rates still do not show the data that I restored back. How I can fix the screen Currency…
I'm performing another test upgrade of Sage 300 to a new application and database server. (going from SAGE 2017 to 2022 and SQL2012 to SQL2019)
Is there any reason to use DBdump and load to move data to a new server versus just restoring a fresh database…
Client uses Sage 300 2014 & SQL 2012, on separate servers. They have provided 2 new 2019 servers for us to begin the upgrade -- but first, I want to make sure that everything works as it does now, before installing version 2022. The DBA restored the SQL…
As a system administrator, but not familiar with the app Sage 300 app.
I wish to activate the Payroll Module for three “Historical Data” companies in Sage 300. Need this in order to access payroll information from 2009-Current
Just wish to know how…
Hello Everyone!
I am currently learning Sage 300 2019. While using it, I accidentally deleted the Sage 300 System Manager, which contains : Common Services and Administrative Services. Can anyone please show me how to restore it?
Thank you in advance…
There are many very large SLG files in C:\User\Public\Public Documents\Global Settings.
I believe Sage keeps these log files for 7 days and should delete them afterwards. I see many that are many GBs that are a year or so older.
Is it safe to delete…
A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed.
sage 300 has detected module update inconsistencies that requires activation. The…
Hi,
We're using Sage Accpac 500 ERP.
And we have 2 Company set (set from Database Setup Tool), so we have 4 databases : 1. OriginalCompanyDB 2. System Database for "OriginalCompanyDB"
3. TestingCompanyDB 4. System Database for "TestingCompanyDB…
Objective: Reduce recovery point objective in case of a server failure to within 1 or 2 hours.
Has anyone been successful at doing backups more frequently than once a day?
for example, VM snapshots, or other SQL backups ? every hour for instance?…
I installed Sage 300-2019. I could not load my dumped files from sage 300- 2017. I received the following error: The company you are trying to open uses a later version of Sage 300 than its related system database uses. You must restore your system data…
When running a data integrity check on Order Entry we get a few of the following errors on Shipments.
E: Header Mismatch: Number of Lines on Shipment(SHILINES) is incorrect. E: Header Mismatch: Shipment Item Total Amount(SHIITMTOT) is incorrect.
When…
I've got our test company working again and now I'm trying to update it with more current information (hadn't used it in years). I thought that maybe to transfer data from the live system to the test, I could do a database dump from the live company,…