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