• Importing excel AP invoice error invoice invalid characters put to field 'remit-to location'

    I was importing an excel invoice template getting error in sage 300: invoice invalid characters put to field 'remit-to location' Thank you
  • Import AP Invoice from own excel file failed

    Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…
  • 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…
  • Sage 300 Terminal server workstation

    Installed sage 300 on sql server all working On TS did wstation setup When opening accpac it is not seeing the databases why - these are created on sql server Pathing shared data and programs is correct did a test odbc to sql server also failing…
  • 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…
  • Unable to access PO Sage CRM R1 2023

    Hello community, I am unable to access Purchase Orders or anything under the P\O inquiry page even though I have installed Sage 300 on the same server and performed all the necessary steps for the integration. Every time I click, for example, on All…
  • Sage 300 2017 PU6 Import AR Invoice line comments without line breaks issue

    Hi All, May I know is this the limitation in Sage 300 2017 PU6 whereby user unable to import AR Invoice line comments with line break? One of our clients encountered this issue recently. At first, this client was in Sage 300 2017 PU3. Hence, we…
  • Error message on bank reconciliation: Record has been modified by another user.

    Hello, I'm hoping someone can help me with this issue. There is a deposit that, believe it or not, goes all the way back to 2016 on our bank reconciliation in Sage 300. I have attached a picture file showing the bank reconciliation and error message…
  • 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…
  • Data Integrity - E: The Year/Period of the latest activity [201406] is not consistent with those maintained in payments [201405]. IDCUST:[xxxx]

    IN our A/R data integrity reports, I see lots of entries stating E: The Year/Period of the latest activity [201406] is not consistent with those maintained in payments [201405]. IDCUST:[ARISEH] Do these need to be fixed / how? - or if it should be…
  • 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
  • Web API Bug in POReceipts with Additional Costs

    While the new ability to add a PO Receipt referencing an existing PO is a long awaited for feature of the Web API, the 2023 release has a bug that makes it impossible for us to use this feature. PO Receipts with additional costs incorrectly assigns…
  • 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…
  • Save Time and Avoid Loss: Essential Data Backup Tips

    Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…
  • Bank entry import problem

    When I try to import excel file to bank entry UI, the header and details files not upload correctly, one bank details data automatic transfer to another bank code when upload, why this? Can anybody help me.
  • 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…
  • Is there anyway to Bulk Import Items?

    Is there a way to bulk import items within Sage 300? We around 2000 items that we need to add. Typically we add items using the Items Wizard manually as we utilize quite a few Optional fields and use different pricing Item Pricings. I have tried to use…
  • Sage Intelligence - Conversion failed when converting date and/or time from character string on General Ledger Transaction Details report

    Suddenly having the above error at two different clients. any new information on this error? It appears when running an April 2023 report *only* where it hadn't appeared in the past. Same for January 2023 *only* for the other client.
  • 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…
  • Sage 300 - Where can I find the template for importing A/P invoices?

    Where can I find the template for importing A/P invoices? Someone mentioned that I can find it under the Data folder, however I don't have a data folder?