Sage 300

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.

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

I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?

Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you

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 all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

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…

A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…

Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…

Hello, Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank

Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…

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…

Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…

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…

Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?

Hi, I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ? Cleared Y/N - Integer (Column Name ?) Used Y/N - Boolean (Column…

We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…