• Sage 300 2024 w/PU1 Sage 300 Cannot Connect to Signon Manager - Resolution

    Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…
  • Sage Database Structure

    Our Sage local DB environment was setup in 2017 hosted on a Windows Server 2016. I am attempting to gain access to the data. Currently an active SQL Instance is named SAGESQLGATEWAY and when connected to it, only lists SqlGatewayConfiguration database…
  • Upgrade Sage 300 from 2023 PU2 to 2024 PU1 creates extra users in the database management system

    I have successfully upgraded my Sage 300 install from version 2022 PU2 to 2024 PU1. Thus far no problems have been found running it. On the Database Server, in MS SQL Server Management Studio however, multiple new users were created during the install…
  • How To Export a Single Transfer in Inventory Control and Re-Import Using different Items

    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…
  • "Sync error server exception sequence number must be specified on insertion of a detail type 2"

    we are using sage 300 with the technisoft service manager app on a Samsung a8 tablet. in the stored actions it says the above line and wont sync anything following that. I've tried everything from fully deleting the work order on the dispatch side (pc…
  • Issue with Importing Simple Data

    I am reaching out because I have diligently followed the installation document step by step for importing simple data. However, I encountered an error, as indicated in the attached screenshots.
  • Vault and Store question

    Error: "Failed to Establish the Vault and Store Databases" During database setup. Above error showed up. New server 2022, new MSSQL 2019, new Sage 300 2024. ODBC tested successfully new install, no Vault/Store in shared data directory mapped…
  • open new database , but error activating

    We have one laptop running Sage 300 version 2023 (Product Update 1) and have error activating New company. After Click Data Activation > Proceed below error pop up. Please advise
  • Upgrade Sage 300 ERP v2018 to Sage 300 2204.1 in a New Server - Vault and Store DBs

    Hi everyone, Im going to install new Sage 300 2024.1 in a new server but going to migrate Sage 300 ERP 2018 data to this. I already reviews information about new security enhancement through move ISM files to new databases (Vault and Store) and changes…
  • Upgrade to 2024 - failed to establish the vault and store databases

    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…
  • locate of database

    above is the error experience when trying to locate the database on sage 300 people
  • Invalid Database Specification

    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…
  • Sage 300 installed on Ec2 using RDS for SQL Database

    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…
  • Company Database version different than system database version

    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…
  • Cannot Activate Common Services data for Sage 300 ERP 2023 PU in MS Windows 11

    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…
  • Sage 300 2022 - No Supported Databases Are Set Up

    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…
  • Sage 300 2024 - Database Changes

    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
  • Sage 300 2022 - What ODBC we need or must use to setup companies/system ODBC?

    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…
  • Running Sage 300 (2019) off cloud paging. Error=100 during Database Loading

    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…
  • Renumbering - Synchronize to Estimating Phase Code

    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…
  • Where to Find General Ledger Account Balances in Sage 300 ERP?

    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…
  • Unexpected Error: Error HRESULT E_FAIL has been returned from a call to a COM component.

    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…
  • Find Sage 300 table and field

    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…
  • Bank Entry excel file import issue

    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.
  • Sage 300 Order entry CSV file import

    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.