• User Creation Date and License Type Fields in Sage 300 2014 Database

    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…
  • GLJED CompanyID field with incorrect company ID

    We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…
  • Qty in Bin Location not matching IC Qty - How do I get them to Match?

    We running SAGE 300 ERP and we have a problem with Qty in Bin Location not matching IC Qty. How do I get SAGE to automatically sync the Bin and IC Qty? Doing each transaction manually takes way to long. Thanks
  • loading data error

    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
  • Data Integrity Check

    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?
  • Restoring MS SQL backup to another database

    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…
  • number change

    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
  • ODBC connection failed...

    Hello All, Hope you can help with my odd ODBC connection, I have 40 companies that I pull data using pass-thru queries. ODBC connection string is set up for each of the companies. The retrieval process is stacked inside an Access Button object, when…
  • Day end error: Transaction History. Database error. (Operation=INSERT) (Error=824)..

    We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.
  • Application Object Model (AOM) for AH61C Sage Accpac HRMS Payorll Link for Sage Accpac 6.1C

    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.
  • Unable to Connect to Database error 98

    Have been using Sage ERP Accpac 200 v 6.0 with Pervasive workgroup v10.30.017 successfully for several months. Today, there was an automatic update and reboot on the "server" while the other workstation was creating bank entries during a bank reconciliation…