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.
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
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
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…
We were thinking to move our DB to SQL 2019. We ran the SQL migration assistant to check for compatibility issues from coming from 2008.
We got one note back from the tool on the DATADICT table with column TABLEDATA type 'image'
Anyone know how we…
Hello Everyone,
I thought I would find at least one question about compatibility with SQL Server 2019 but nothing.
SAGE 300 v2019 compatibility guide lists SQL Server version up to v2017.
Is anyone out there running SAGE 300 v2019 with SQL Server…
An existing client Is running Sage 300 ERP 21014 and would like to migrate their SQL from 2008R2 to 2016.
Is Sage 300 ERP 2014 compatible with SQL Server 2016?
Thanks,
Hello,
I was hoping someone might be able to assist me. I am trying to create a report using the Sage 300 2014 database. I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to…
Hi,
We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed.
1 Error found in Administrative Services.
Any ideas?
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?
We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions?
We're also looking at the possibility of using server 2016. Is there any chance…
When I go to Item number change and processing I have an error message:
Cannot open database "ccs.net.ccscom" requested by the login.The login failed.
Any idea
Hi,
1) Will the new Sage 300 2016 allow upgrade from older version ?
eg: Accpac 5.5?
2) What about the Database, will it help to migrate Data from AccPac 5.x, PSQL, to MS-SQL ?
3) The Database Dump & Load Application, does not work for different…
We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.
Have been using Sage ERP Accpac 200 v 6.0 with Pervasive workgroup v10.30.017 successfully for several months. Today, there was an automatic update and reboot on the "server" while the other workstation was creating bank entries during a bank reconciliation…