Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
Hi.
We need help getting our database setup. I did some reading on it and even though I understand technical things pretty well I did not quite get it. As I mentioned in the title this is for a class we are taking in Computerized Accounting and we all…
Hi,
I want to create a Business Intelligence Report by using Report Manager & Connector.
In this report, I want to get rows from table APPYM of all Companies database.
But first, I need to know which database is actually a company database for Sage…
Don't let database errors slow down your productivity. Here is how to deal with some of the database issues that Sage 300 Customer Support often gets contacted about.
Error: "Cannot access database Error=49153" with a newly installed server
The "Cannot…
Does anyone know the easiest way to copy shortcuts created in company A to be identical in Company B in Sage 300? Assume the shortcuts in company A are set as all users.
Hi, I am trying to determine why my GL and AP control accounts dont balance.
Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.
To this end, I would like to build a query in sql…
Hi,
We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed.
1 Error found in Administrative Services.
Any ideas?
We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions?
We're also looking at the possibility of using server 2016. Is there any chance…
The last updated datetime stamp for every record in Sage 300 is stored in two fields AUDTDATE and AUDTTIME and from the forum I've learned that AUDTTIME is in GMT time. From my own testing it seems AUDTDATE is also part of the GMT datetime format meaning…
