Browse By Tags

  • PO archive and upgrade?

    Has anyone had experience with archiving the PO module?   According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module.  Clean out all those old records.   I have done this in a test environment and can…

  • Table and Field Naming mode - JDBC2Pervasive query

    I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB.

    In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db.

    Class name is: com.pervasive.jdbc.v2.Driver.

    URL is in format…

  • BV December 31, 2020 End of the road - Pervasive 10 - Is this slated for update ?

    I recall reading articles years ago about BV and its reliance on Pervasive 10 which reached its end of life a few years ago, and crystal reports which i think is no longer a thing? 

    I recall there being a limitation with BV that all database access would…

  • Where are formulas being used

    I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are.  So, if a formula is being used, is it used in another formula, report, etc.  I have 100's of formulas & reports…

  • Database Schema for Sage 300 CRE?

    Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…