Sage 300

above is the error experience when trying to locate the database on sage 300 people

I am currently experiencing an issue where i installed and set up sage 300 application on AWS EC2 instance and connected to RDS SQL for the database Everything works fine besides when i run queries it is really slow and takes 5 mins when it should take…

New database cannot activate in Sage 300 ERP 2023 with Product Update 1 Computer operating system version MS Windows 11 Display the following message creating the new company. 'User input email password cannot be blank' 'Cannot activate common…

Hi everyone, A customer that uses Sage 300 2022 more than 1 year ago suddenly when users try to enter they get this error message: No Supported Databases Are Set Up. Not use what happened but since a couple of hours ago they are getting this error…

The link to the Sage 300 2024 Database and Report Changes opens V2023, am I correct in assuming that means there are no changes between 2023 and 2024? cdn.na.sage.com/.../Documentation.htm

Hi Sage City community, I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing. Could anyone guide me on which specific…

hello i had those errors Unexpected Error: An unexpected problem has occurred. Please try again or contact your administrator for assistance. Unexpected Error: Error HRESULT E_FAIL has been returned from a call to a COM component. when i try to…

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…

After installing Sage 300 2023 PU3 I have created 2 new databases and an SQL user as it is explained in the Sage300EnhancedSecurity.pdf document. However, when I log in Database Setup and entered the required fields on the opened Configure Databases pop…

Hi All, Has anyone installed Sage 300 2023 with SQL 2022 yet? Does anyone have it working? I know it isn't in the compatibility guide yet (as of 8th March 2023). I am hoping it is supported in the next Product update or sooner. Regards, Quent…

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…

I cannot find the Tables names and field description for the Manufacturing module in Sage300. Anyone knows where to get it Something similar to this Thanks

Hi everyone, A customer is still running Sage 300 2019 (with SQL Server 2012) and its going to move to Sage 300 2022 in a few months. But before of that its going to invest in a new server and want to upgrade some applications to SQL Server 2019.…

Hi all. I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt…

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…

We have disabled login user Sa in SSMS and created different user to access Sage 300 databases, Our auditors asked us about the default logging users created when you install SQL. What's the best practice to deal with those users created during SQL installation…

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, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully. I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…

Every now and then I have Sage freeze and lock everyone from doing anything. It commonly happens in the payment batch list during heavy usage around month end, but it can happen other times as well. The system during the working day is under heavy usage…

Are there any best practices or caveats for re-indexing Sage 300 Databases using Microsoft SQL Server's maintenance plans? Thank you in advance for any suggestions!

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, Can someone recommend a product to audit the update process for transactions? We need to know who does modifications. Ty.

Sage 300 2021 PU5 - SQL 2016 I think I know the answer to this (no) but can the System DB be a different collation method than the company DB? I ask since a new company is being brought onboard from an old Sage version environment where the company…

My customer is replacing their server which is running Sage 300 relatively current version with MS SQL 2014. As long as we are moving we want to upgrade to MS SQL 2019. The customer purchased MS SQL CALs on subscription from Sage with the original purchase…

Hi All. I have error when i want connect new PC from sql. Cannot Access Database 49153, it means the PC cannot read the sql server. No issued with another PC, only problem from this PC. But if i create ODBC, connection is sucsessfull, and change…