• Upgrade to BV2023/ActianSQL V15 (previously Pervasive V10) - issues with querying GL_TRANSACTIONS and workarounds

    After upgrading Sage Business Vision to version 2023 and the subsequent database update from Pervasive V10 to Actian V15, Issues have arisen which affect querying the GL_TRANSACTIONS table. I am currently in contact with both Actian Support and Sage Customer…
  • up to date version of "BusinessVision Database Structure Reference.chm"

    Hello, I'm wondering where i can acquire the latest version of the "BusinessVision Database Structure Reference.chm" help document. The latest I have appears to be from 2018 and it references database fields that no longer exist. In system setup …
  • SALES_HISTORY_HEADER TERMINAL_ID

    What is this field for? (documentation says reserved for internal use) How come some of my records have a null value (when it looks like the SHH database table schema says NULLs are not allowed) Is it okay if i just use 0 for null records, if i'm creating…
  • BusinessVision licence - activation - 5 User LAN Pack license

    Hi everyone, I recently upgraded to the latest 2019 BusinessVision from an earlier version. I understood the 2019 has a built in 5-user license. I had the 5 user LAN pack with the old version. When I upgraded, I expected to see 10 user because…
  • 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…
  • Need DB definition for Sales History Detail field (ITEM_TYPE)

    I'm wondering if I can ask a more technical question here. In the DB table SALES_HISTORY_DETAIL, there is a field called ITEM_TYPE which seems to store values from 0-9. However in the Database Structure Help where with other similar fields the list of…
  • Reorganize inventory

    I have just completed a reorganization of certain inventory items to allow for a price increase of 7%. It has all worked properly but when I enter one of the changed items on a purchase order, the old and thus incorrect price comes up. I believe this…