Sage 300

I accidentally deleted all the records in the 'currency rates' section of Sage 300. How can I recover them?

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…

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…

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…

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…

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

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

We have a virtualized server for Sage 300 and a separate virtualized server for SQl Server 2017. Does anyone have good documentation on how to take the backup, create a new server and then get Sage 300 up and working. I know how to restore the virtualized…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me

Hi Team, Doing an installation set up. Can I restore a sage 300 ERP backup from premium version environment into a standard version environment. comparing the variance in the version...........

Hello Guys, Our client is currently experiencing the below error message, when performing database dump in Sage 300. You advise on how to resolve the error will be highly appreciated.

Hi, I just finish to upgrade a customer from Sage 300 2014 to Sage 300 2018 in a Windows Server 2012/SQL Server 2012. We just upgrade Sage not the server,it is the same. Before open the real companies to convert I try to create and dbload sample data…

Hello Guys, I am getting the below error message whenever I tried to open the Sage 300 db dump and load, your advise on how to resolve the error will be highly appreciated. Sage 300 Version(6.4A) 2017 Product update 2 SQL Server 2014 Error…

Sage 300 2017, MSSQL Client daily dump data, as a backup. last week, they dumped data, for strange reason, dumped data only has data up to end of 2016. No 2017 info. any ideas? thanks!

after a server crash I have restored the database. I am able to create the system database in database setup fine but I can't create the company database i get the error that csapp is not found. the table is actually there. i read several posts on this…

MS SQL server 2012, Sage 300 2014 PU 3 I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors…

What is best practice as it relates to handling large Sage database related SQL log files. I generally move them to a different location. What do you guys generally do as Sage database SQL log files grow extremely large? Is purging a normal option or…

This is 10 to 50 times faster than a Dbdump/Dbload. Enjoy! USE [master] --Initialize variables Declare @db_to_name nvarchar(8) Declare @db_from_name nvarchar(8) Declare @sql_data_folder nvarchar(150) Declare @sql_log_folder nvarchar(150) Declare @sql_backup_folder…