• cannot access database (error=40960) sage 300

    I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?
  • Order Confirmation Creation Time

    Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you
  • OEORDD.UNITPRICE

    Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?
  • Any issue with other app databases in same instance as Sage?

    A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
  • Database error (operation=LOCATE, error=0).

    Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…
  • Payment Batch

    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
  • Exporting Data from Sage 300 Pervasive SQL Database on a Recurring Basis

    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…
  • Is Sage 300 ERP 21014 compatible with SQL Server 2016?

    An existing client Is running Sage 300 ERP 21014 and would like to migrate their SQL from 2008R2 to 2016. Is Sage 300 ERP 2014 compatible with SQL Server 2016? Thanks,
  • 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…
  • 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?
  • GL entries posting

    Hi, We are on Sage 2014 Service Pack 1 and we would like to know if there is a way to find out who made a post in GL entries and possibly the date and the time. Any clue?
  • 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
  • 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…
  • Cleared items still showing on Bank Reconciliation for one period in 2011

    I have a Sage 300 ERP 2012 client who is having an issue with their Bank Reconciliation. They have items that were cleared back in March 2011 that are still showing on the Reconciliation tab, even though they have done reconciliations for all periods…
  • Period Processing

    Hi All, Have you tried doing clear history in OE Screen, does it delete the Orders or only the Shipment & Invoices only? I tried clearing the history using the transaction history option as of 12/31/2014, invoice are remove but the order is still…