Sage 300

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…

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…

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 ANY BODY HERE TO HELP OUT MY…

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