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.
I'm trying to install sage 300 from a computer running on Windows 11. The previous installation was ok from our existing computers. Untill this time that I need to install it on a new computer. It reaches up until entering the Program and data Folder…
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
Would you kindly let me know the Max. Length of SQL password Sage Intelligence Acceptable?
My customer change SQL Password to 64bits length…
After change, all Sage300 feature works fine but only Sage Intelligence caused password invalid.
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…
Hi all,
On a Server, we have install a Sage 300, and have the Serialized Inventory and Lot Tracking 2022 checked during the installation. However, the module does not appears on the License manager or data activation.
Please guide be how to solve…
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…
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…
Hi, I hope you and your family doing well in this pandemic situation. I am doing a course in udemy on Sage300erp and I face some problem. course link: https://www.udemy.com/course/sage-300-erp-installation-and-setup-guide-for-beginners/learn/lecture/1757264#questions…
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…
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…
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, but in sql server all data is avail able. kindly…
Upgrading to PU 6 to put the 2020 sm license key in we attempted to put in the new license, all sage-authentication accounts with admin rights lost their module access. Normal windows authenticated users seemed okay, and the default Admin account seemed…
