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
I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation.
What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…
We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more.
A user…
Hello all,
I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this.
I'm a student, using cloudpaging…
We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…
I’m trying to determine what table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database.
You get to it by clicking the Item/Tax button…
Hi,
We are experiencing an odd situation. When in location details and drilling down on the quantity on S/O we are missing orders. It shows the correct quantity but you are unable to see the list of orders.
-Customers allow backorders, are not on…
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,
In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table.
But there is no entries for 3, 4, 5 in AOM.
Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH?
Thanks.
Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet.
I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…
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…
I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.
Now I want to add some fields to it that are not in the set of data tables already in the report.
In the "Field Explorer" I right…
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,
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
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 there,
I am trying to perform Database Dump but always get the following error message.
Then, if I perform database verification, it returns this.
Could I know how to fix this issue to be able to dump database?
Thank you!
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…
Are ICPRIC and ICCPUR accessible via the Sage API?
If not, is there any other way to access Price Lists, other than by direct SQL Query or middleware such as Realisable IMAN?
I have a sync app running and it's exporting out from Sage: Orders, Shipments, Customers, Inventory, and Credit Notes. I want to only grab the records that have changed since the last time I ran the sync. For some of these it seems I can grab the DATELASTMN…
As a system administrator, but not familiar with the app Sage 300 app.
I wish to activate the Payroll Module for three “Historical Data” companies in Sage 300. Need this in order to access payroll information from 2009-Current
Just wish to know how…
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…