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…
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?
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
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…
I have a Sage 300 ERP 2012 client who is having an issue with their Bank Reconciliation. They have items that were cleared back in March 2011 that are still showing on the Reconciliation tab, even though they have done reconciliations for all periods…
Hi All,
Have you tried doing clear history in OE Screen, does it delete the Orders or only the Shipment & Invoices only?
I tried clearing the history using the transaction history option as of 12/31/2014, invoice are remove but the order is still…