• SQL 2022

    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.



  • Sage 300 Database on Azure SQL

    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…

  • Tables and Fields for Manufacturing

    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


  • Sage 300 2019 Supports SQL Server 2019?

    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.


  • Deposit Date from AR Batch is coming from which table?

    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 Batch…

  • Any issue with other app databases in same instance as Sage?

    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…

  • Deafault loggin users SQL

    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…

  • Database error (operation=LOCATE, error=0).

    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…

  • cannot access database (error=40960) sage 300 2020

    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…

  • Sage freezes sometimes on payment batch list

    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…

  • Recommendations for Re-Indexing Sage 300 Databases using Microsoft SQL Server Maintenance Plans

    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!

  • Payment Batch


    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

  • Database audit product


    Can someone recommend a product to audit the update process for transactions? We need to know who does modifications.


  • Can the SYS DB be a Different Collation Method than the Company DB?

    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 DBs…

  • Migrate from MS-SQL 2014 to MS-SQL 2019

    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…

  • Cannot Access Database 49153 database setup with server

    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 from…

  • How Can I check or clarify SQL server is runtime edition version ?

    Hi, Everyone How Can I check or clarify SQL server is runtime edition version.

    Please help me.

    Thank you so much

  • sage 300 2014 data dictionary

    Hello, I am new to the forum and need some help. Please where can I find the Sage 300 2104 data dictionary?

  • OE: Difference between QtySold and QtyShipped

    Hello there

    I have noticed that for a given invoice in my SalesHistory table (OESHDT) the QtySold=110. But then when I go to my PostingJournal (OEAUDD) for that invoice I only have a QtyShipped = 98. So am I correct in thinking:

    1. When I sell something…

  • Where to find "Account Type" and "A/c Type Sub-Group" ?

    Good afternoon,

    I'd really appreciate it if someone who knows the Sage300 database well could help me on this. If you look at the screenshot below, I'm trying to find the database table where my accounts could possibly map to the ORANGE "Account…

  • Exporting Data from Sage 300 Pervasive SQL Database on a Recurring Basis

    We are working with a company using Sage 300 on a Pervasive SQL database. 

    They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. 

    I'd like to know if there are any…

  • Sage 300 ERP 2014 version is supported in SQL 2019?


    Is Sage 300 ERP 2014 version supported in SQL 2019? Currently 2014 SQL is in use. As per the compatibility guide we cant get this details. Before upgrading SQL from 2014 to 2019 version we need to confirm client if it will work without any issues. 

  • Sage 300 SQL Replicator and Power BI

    Is anyone using Power Bi to access and display data from the SQL replicator DB?



  • Sage redundancy and backups

    Objective: Reduce recovery point objective in case of a server failure to within 1 or 2 hours.

    Has anyone been successful at doing backups more frequently than once a day?

    for example, VM snapshots, or other SQL backups ? every hour for instance?


  • RE: SET

    Hello guys,

    I'm trying to create a new database in sage 300 demo away form the sample companies provided in the demo, is it possible to create a new DB.and modify my own setup away from the sample data in sage 300 erp demo and how....