• Which Database table holds employee initials? They aren't in the Employees table.

    I am writing a third party app. I need to find Employee Initials which you can configure in BV. Oddly, they aren't in the Employees table. Does anyone know where they are stored?
  • Importing Chart of Accounts Error

    I'm creating a new company and I want the existing Chart of Accounts from a previous company. I've created the company and exported the Chart of Accounts and set all the balances to zero. When I go to import, I get an error saying the account number structure…
  • Yearend Utility and Inventory Count

    Our company has decided to take on this process and we have a few questions. I'm already able to export the inventory, update the values in the spreadsheet and reupload them into the system. Am I suppose to do this before or after we use the Yearend…
  • "Out with the old, in with the new". Why reviewing your software make sense.

    Many of our customers have been using our products for years. Yet these customers' business may have evolved - perhaps through growth, maybe through a change in strategic direction, even changes in compliance or similar. Change also comes from younger…
  • Is there a way to import excel into BV without having MS Office installed?

    If I have BV installed on a server without MS Office installed, the import/export options for spreadsheet are greyed out. I can understand this for the export, but is there a way to still import import if you bring in a spreadsheet form the outside? …
  • Importing promotional prices

    Attempting to import Promo Flag, Promo Price, Start and Stop Dates. Using MS Access to create an Excel file, update the relevant fields, then import. Works fine except that the Stop Date is not updated, is left blank (zeros). Using a copy of the database…
  • Setting up a new company

    Hi, I have received BV data which I want to load into my BV VM to view the data before testing the BV to 300 migrator. I have created a folder within BV and put the data from the client in there and went to New Company set up and directed the path…
  • 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…
  • Business Vision 7.53 - Error 000002 - GL.btr - also fails when rebuilding

    So I had a some power issues last week on the server, fixed that but it seems GL.BTR is corrupt. (i think) Basically cant post invoices. The error is in GL.BTR Tried this: https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Sage%20BusinessVision…
  • Newco.

    Created a new company database using 'Newco'. Why does it generate a U.S. version, and how can I change it?
  • BV 2014 Inventory Pricing Updates

    Hello All, We are currently experiencing a bottleneck where our yearly/bi-yearly pricing increase from our 700+ vendors are not being updated in our inventory system effectively. It seems like a very manual process where we receive pricing increase…
  • Deleted G/L account in error

    Hi, I didn't think you could delete an account that had a balance but I did so in error. I ran Data Validation, but it found no errors. Any suggestions? Thanks
  • Wrong address on some invoices and receipts

    I am using a pre-made invoice form (7" dot matrix for carbon copies) and I have noticed over the last two weeks some invoices and receipts on account are printing out with an incorrect address. The customer name is correct, but the address that prints…
  • What file controls the Customer Bill to and Ship to address

    Rebuilt client data - now when they try to re-PRINT from Sales Analysis the Customer Bill to and Ship to are blank. All new orders are fine. Thanks Sandie