Sage 300

This is on my test machine (full local install). I already had 2023 PU4 with the enhanced security set-up. I decided to uninstall 2023 and install 2024. After installation, I go to DB setup and get the above error. Yes, I can recreate the vault and…

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

I see this posted all over the place but nothing I have tried has fixed my problem. I have a new VM with Server 2022 with Sage 6.0A installed. I have the database configured and I can login to Sage. The issue is that I can't post new orders. I can do…

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…

I have a client that is running Sage 6.0A. I have SQL backs up both their company and system databases. When I try to login to the company, I get a message stating the the Company database is a later version than the system database. How do I fix this…

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 everyone, I have some customers with Sage 300 2022 and they have and use to setup ODBs for companies/sytem SQL Server Native Client 11.0. But with a customer we are upgrading to that same Sage 300 2022 version, and we dont found it. We download…

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…

I am going through the database editor and moving some items into a different phase. I am using "Renumber Items" to change the phase code of multiple items at a time. One of the prompts is "Job Cost Phase" and the default option is "Don't Change". However…

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…

When I upload excel file in bank entry module, the file row is broken. All row is not inserted to the bank entry at a same time, some rows are missing when uploading. how can I solve it, can anyone help me.

Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.

Can someone please help me build a csv for order entry import? I've tried to export an OE Order but it's too large and keep failing. If anyone has a template or a resource or any other guidance I'd really appreciate it. Thanks!

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…

Hello. I'm working on a project where I need to extract the purchase history from the company's Sage Sql database. According to the documentation located at https://sageaom.kcsvar.com/AOM60/POHSTL.xml the TRANSTYPE of 2 is a Purchase Order. I know…

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, We are just moving DBs of some Sage 300 customers to new database servers with SQL Server 2019 (Windows Server 2019). We are not going to upgrade Sage 300 or move applications to new server, just Databases. From SQL Server 2008 R2 to SQL…

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

We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…