Sage 300

Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

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…

Can someone please tell me what table/column will give me the current fiscal period for a company?

Hello, I was hoping someone might be able to assist me. I am trying to create a report using the Sage 300 2014 database. I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to…

Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

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…

MS SQL server 2012, Sage 300 2014 PU 3 I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors…

When I go to Item number change and processing I have an error message: Cannot open database "ccs.net.ccscom" requested by the login.The login failed. Any idea

Is there an AOM for the AH61C module? I have not been able to find anything in the KB or the online documentation after installing.

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…