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
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 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…
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…
Hi all,
We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project).
The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered.
We have registered the accpacic1500…
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
Sage 300 Premium (Version 2022)
SQL 2019 on Windows Server 2019
GL batch posting freezes during month end closing periods and Sage 300 becomes inaccessible for anyone who wants to further login. Other logged in users won't be able to post from GL…
We are using AccPacc to work with Sage 300.
When we call View.Insert the error message appeared:
------------------------------------------------------------------------
Timecard Detail.
Database error (operation=REV-POST, error=229)
------…
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…
A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed.
sage 300 has detected module update inconsistencies that requires activation. The…
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…
We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300?
Comments…
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…
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,
I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…
HI,
We have applications that generate payment batches that are imported into Sage 300 AP module. We were generating them as a Single CSV file. Everything was going well until version 2019. I realize there are a few extra fields in one of the tables…
I create a user in ACCPAC. But i can't execute my macro syntax. But if i change the user to Admin, its working fine. Can anyone help me? How to configure the new user, so i can execute the syntax
I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC").
the condition that i have set if PORCP1header.Read
how to get the previous data from that field and set into a variable in vb
Example:
Dim vItemDesc As String = ""
vItemDesc…
Hi, I am trying to determine why my GL and AP control accounts dont balance.
Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.
To this end, I would like to build a query in sql…
