Sage 300

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 bought SAGE ERP 300 2014 in may 2015 and from then we are unable to use and implement the product in our Courtney.after year long fight with our sage business partner we have successfully running the product on our head office and i'm not that…

While trying to restore a SQL server backup for one of our Sage databases, the process returned a restore error. Upon research i found out that the DB may have been corrupted. What can be done to recover from this? Priti

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…

Hi, Sage 300 2016 supports SQL Server 2005 or 2008? Anyone running this last version in that environment? Thank you

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

Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…

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…

Hi there, We are using Sage 6.0 PU2 with SQL server 2008. Every morning our accpac freezes while trying to log in for the first time. It would stay on connecting to DB and become unresponsive. The following error msg from event viewer. The description…

Hi, Does any one maintain or have a Sage 300 ERP running under MS Sql for size over 200GB? Any issue? And have you ever done dbdump , dbload ? How long normally it takes for dbdump and dbload? Thanks