Browse By Tags

  • 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?

  • OEORDD.UNITPRICE

    Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?

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

  • Sage 300 Data Activation

    A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed. sage 300 has detected module update inconsistencies that requires activation. The…

  • Importing Transactions into Project and Job Costing

    Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

  • Create Customized Table in Sage 300

    Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…

  • Sage 300 Construction and Real Estate PRM tables Pervasive

    FormerMember
    FormerMember
    Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    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…

  • Current fiscal period for a company in database?

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

  • SDKInstanceManager OpenDatabase always returns false and has no error messages

    Hi, I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…

  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…

  • 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?

  • dbClient.GetConnectionInfo(szFileDir, szHost, szPort) parameters

    I'm writing an application in VB.NET to run custom queries against the Sage 50 database. I've gone through the SDK manuals, but have some additional questions while walking through the sample code. We run the connection manager on the server and install…

*Community Hub is the new name for Sage City