• Opening a backup on a remote station

    Hi, I am having problems opening a backup on a remote laptop. The laptop has BV already installed and will open the company while connected to the network. I have copied the "data" folder to my laptop while connected however when I try to open the…
  • Back-Ordered Item Error

    We are on the updated Sage Businessvision 2023 edition, but we have been experiencing an unusual problem in the past few months. Random items will show items as "back-ordered" despite there being no outstanding sales orders. That, or the back-ordered…
  • Sage BusinessVision 2023 - AP_TRANSACTIONS.REF_NO - 25 Character Field limited to 10 chars in the front end GUI

    AP_TRANSACTIONS.REF_NO has a 25 character field limit, however the use of this field has been limited in the BusinessVision front end GUI to 10 characters. It appears that this is because the cheque number field in system setup is limited to 10 characters…
  • Sage BusinessVision 2023 SBE Bug Report - Duplicate Customer Records created in POS Module

    We have reported this bug on several occasions dating back to 2019 but it still exists as of Oct 03, 2023 After adding a customer in the POS module, and creating a sale, then pressing the tender button, the payment details screen pops up. (The customer…
  • Sage BusinessVision 2023 SBE Bug Report - legitimate Sales posted that do not pass Data Validation

    If a sale is tendered for $0.01 or $0.02 or -$0.01 or -$0.02, and tendered with "Cash & Cheque Receipts" selected as the payment method, BusinessVision will apply penny rounding and will round the total to $0.00. This will post a journal entry that…
  • Exporting Data to Excel

    How do I activate this option? We have excel on workstations, but not on server where BV runs, and cannot export data files to excel (see "grayed" Excel option in pic). Thanks for any help.
  • Save Time and Avoid Loss: Essential Data Backup Tips

    Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…
  • 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 …
  • Importing receivable trans and ref numbers

    I imported receivables into BV from another BV account that I exported from. I added a letter in front of the reference number ex P and now in a lot of cases it doesn't show the last digit on the reference number ex P1000005861 shows up as P100000586…
  • Pervasive & Crystal Reports

    I believe our database is corrupted in some way and I am wondering how to fix it. I am inserting pictures of a report that I have used for years and an excerpt of this year's report. The rows in blue are correct. There is a royalty of 20%. But then…
  • 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 2013 Data Tables

    I am trying to export data from a legacy system and wondered if someone knows of a resource that describes the Pervasive SQL tables and their relationships. Thanks for your help in advance.
  • 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…
  • The Sage BusinessVision Control File for the company selected is currently being used by another user. The company selected cannot be accessed by Sage BusinessVision at the present time.

    Hi i have the lastest version of BV running on a server with Server 2016. I have the 10 user lanpack installed and this has been working perfectly for the past 6 years. All of a sudden only 1 user is able to connect to the data file at any time. I checked…
  • Can I export customer/supplier information into Excel in a format specified by others?

    I am trying to export our customer and supplier information into a format specified by another company. Is this possible? Also is it possible to delete all the customer profiles that do not have any history in one process or do I have to go through each…
  • Does anyone here actually work at SAGE?

    Is there any sage employees on this forum, if so, please speak up. Where do we report bugs?
  • BusinessVision DELTA version 6.22, Export .ISM/IDX History/Data Files into Excel Spreadsheet?

    Hope all are well, we have a very old system that ran a DOS based accounting software BusinessVision DELTA version 6.22, I was hoping that you have a way to "Export" that data into a Excel Spreadsheet format, many people I am sure not so much recently…
  • Is there a quick way to delete CSP ?

    I have a customer who has customer specific pricing on over 300 items. Is there a quick way to delete them? Otherwise I must do them one at a time in the customer file. What if I imported a csp of zero? Thanks.
  • Covert Business Vision to Sage 50

    FormerMember
    FormerMember
    How do I convert the data from Business Vision 2.02 to Sage 50? Is there anyone that can do that for us without loss of data?
  • GL Chart of Accounts Import?

    Hello, We are trying to setup our company in BusinessVision 2019. How do we get the Chart of Accounts in with correct Opening balances? You can't start a company with a custom chart of accounts - if you don't select one of the predefined chart of…
  • Backup

    I've been working at a small business for 5 years. I have knowledge of Sage300 and Quickbooks but the business uses Sage BusinessVision (Version 7.92.01) and I feel like I'm working in the stone age. There is no way (that I can see) to generate a backup…
  • gl allocations crashes when we choose a particular account

    We used to have an account 42155-99 that was set to allocate to different segmented accounts. About a year ago, it stopped working. Today I was asked to fix it. I'm not super knowledgeable in regards to the segmented accounts, so bare with me. I'm not…
  • Why is it exporting to 2 sheets?

    I am trying to export our inventory into excel 2007 but when I select my fields and click okay it exports into 2 sheets in the same workbook. How do I get it to all go on 1 spreadsheet?
  • BOM Import

    We design and manufacture electronic circuit boards. Our BOM is first created in our design software and then imported to BusinessVision by hand. Automating this task would save us lots of time and reduce errors.