• Total # of AP Invoices | Performance Management

    I am wanting to run a report to show total # of invoices entered through accounts payable module. Is this possible? How do I go about doing this? TIA
  • negative inventory

    hi, how could I end with negative inventory on an item when we don't have the system set up to have negative inventory? Seems like a glitch how can I fix this as i cannot create an invoice because of this item issue? tks
  • Error : Before you can specify documents to send to contact 100, you must enter an email address for this contact.

    Description: Before you can specify documents to send to contact 100 , you must enter an email address for this contact. Hi, I've met the above error while I'm trying to import customer data (an excel file export from the A/R customers). Email address…
  • Web Use

    Hi Just after some honest opinions on web screens and gauging use. We have one customer who is really committed to trying them and using a lot but we are getting all sorts of weird data corruptions now like nothing I have seen in 20+ years of Sage…
  • inventory issue

    Hello, in trying to do an order entry I have an item that has a qty of 200 physically. In choosing the item it shows it is unavailable as 200 are on a sales order. So if run a report to see which OE these units are committed on so that I can uncommit…
  • Sage 300 PU6: "Error: Failed to create Vault settings"

    Hello, I'm having issues configuring my database connection from PU1 to PU6. I followed other guides and answers from this community, and I still get this error. Any help would be appreciated. Thanks, Ethan
  • Database conversion

    Hi, hope you all are well. im trying to pull up the database for company that was provided by my school for the assignment however, i am having thought time to pull and keep getting error message saying “ You cannot upgrade your data directly from…
  • Cannot update existing AR Item using SAGE 300 .NET libraries

    I'm a developer working on application that requires syncing a database of my own with a number of tables in the SAGE 300 databases. I was previously using the SAGE COM APIs to do this syncing, but my application is written in C#, so I'm in the process…
  • Sage 300 ERP 2023 can't connect to vault and store database

    I have my system working fine using Sage 300 ERP, I upgraded to PU5 and now it is asking me for vault and store databases. I followed the procedure in https://www.greytrix.com/blogs/sageaccpacerp/2023/06/06/configuring-store-and-vault-database-in-sage…
  • restore data from a backup for a specific period

    Sage 300 typically uses a database backup system where you back up the entire database. Is it possible to extract specific period from the entire database, i.e. Jan 2020 to Dec 2021 only.
  • Accidentally deleted all the records in the 'currency rates'

    I accidentally deleted all the records in the 'currency rates' section of Sage 300. How can I recover them?
  • 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…
  • 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…