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.
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 all,
On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below.
I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible.
Anyone know…
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?
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…
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…
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…
We are a company that hosts a number of concerts, each with their own 'Transaction Optional Field' so we can attribute each sale and invoice spend to a concert if we want to pull a report by Transaction Optional Field.
The list is getting quite long…
Hi team ,
We used to take backups from the "Database dumb" manually but, I want make a scheduled back up from the database dumb in sage 300 ERP like automatically not manually. please advice..
Hello, we are trying to set up a development environment for Sage300. The version of Sage300 for production use is 2020. On our development server, we are using Sage300 2019. We dumped the company database from our Sage300 2020 and restored it to our…
I would like to know if there is a way or a tool that can be use to reduce Sage300 database. I have a company database of 90GB size with data since 2000.
Hi All,
Can anyone please tell me how can I read my archive database which is in 5.5 in our Accpac 2014?
It says I need to upgrade the database to 5.6 so how can I do it?
Best,
Tom Menace
Hi,
We are on Sage 2014 Service Pack 1 and we would like to know if there is a way to find out who made a post in GL entries and possibly the date and the time.
Any clue?
HI
A client restored their system file yesterday due to them deleting something in the foreign exchange table.
Today, when they try to enter an AP Invoice Entry, they get the following warning:
"Exchange rate information does not exist in Common…