Sage 300

Hello, 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

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

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…

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…

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…

Hi, Everyone How Can I check or clarify SQL server is runtime edition version. Please help me. Thank you so much

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

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…

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

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…

Hi, 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…

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

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

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.... Thanks

We were thinking to move our DB to SQL 2019. We ran the SQL migration assistant to check for compatibility issues from coming from 2008. We got one note back from the tool on the DATADICT table with column TABLEDATA type 'image' Anyone know how we…

Good day all. Today, when I was trying to troubleshoot an issue with a vendorcode in Sage300 2019, I noticed that the audittime for this record in the APVEN table was not correct. I made a small change to the vendor's name, and noticed the differenc…

I never used update statistics as a part of the SQL Server maintenance and wondering is there any benefit from running it?

Hello Smart people! The last company I worked for used to have Sage100. I did an Saved an Excel query and I know that with Sage 100 the data base connection's name is SOMATAMAS90... What is the name of the database to connect with Sage 300? Thank…

Following on from my previous question and rather obvious answer... is there a massive ERD showing the relationships between all the tables in the Sage 300 DB? Many thanks

I'm looking at a field on the screen in Sage and need to figure out what Container and Column contains this data.

I am trying to run some simple queries and use it for audit. In this case I am running an AP register, but for some reason I am getting a syntax error in MS Query that it doesn't like the columns Check or Limit......any work arounds? Thanks,

I am trying to get Sage 300 2017 setup on an Azure VM using Azure SQL databases.I am having trouble with the database setup and the name of the SQL server. It appears that Sage truncates the name. Has anyone been successful with this type of setup?

I try to load the sample data in using Sage 300 Data Loader, there is an error saying "Run-time error '48': File not found: a4wlnst.dll". So the first step that I took was I thought was it might be a permission problem, so I ran it as an administrator…

Hi, Our SAGE is getting error and we found the issue is from SQL server database full. Though our transactions are not heavy, our database is getting full every week. It seems the SQL log is growing a lot and making an issue. Any suggestion?

Using SAGE 300 ERP 2014, what is the process to load sample data. It is not documented in the install guide.