Browse By Tags

  • Cannot continue verification, a database error occured (error=60001).

    When running Verify in Database Setup for a System Database, it returns the following error message:

    ARADV: Table does not exist.
    Cannot continue verification, a database error occured (error=60001).

    How do we resolve this error?

  • I have a Purchase Order that is showing in committed cost but has completely disappeared. How do I resolve this?

    I issued a CO to an existing PO last week, printed and sent.  It was there, I have the proof.  This week the PO is not showing in a PO Log but the line items are showing under committed cost.  I have no idea what happened.  Any help would be appreciated.

  • Upgrade from 2020 to 2022 version of Sage Pro

    I had the downloaded version of Pro 2020 (I assume it was Pro because I still have the CD from the 2019 version which was pro). My hard disk died therefore I lost Sage 50, and have to start from scratch. Lessons learned, I have back-ups from April 30th…


    How can i make company data be accessed concurently

  • Restoring historical data

    History of Question:
    * The SAGE 100 Con database had over 30 companies in it and performance was "sluggish."
    * Backups were made of all companies and copied to another server for safekeeping.
    * A 2nd SQL instance was created and all companies between…

  • Is there an excel template to import your vendor list to Sage 50?

    I am in the process of switching from QB to Sage 50. I would like to import a vendor list that I have modified from Quickbooks. Is there a template available?

  • Importing order entry by excel

    Hi Everyone, 

    I am just wondering if there are any excel template that we can use to import Order?

    Our order has hundreds of SKU, it is taking alot of time to enter one by one.

    Thank you very much

  • Payments "disappearing"

    The following was reported by a law firm using Timeslips Premium 2020
    1. Firm receives payment (eg for June Invoice #123 for $500), applies same against open invoice #123, prints and finalizes bill for July #124. The finalized bill for July has a new balance…

  • Data File Structures class? Crystal Reports classes? Where did they go?

    When I started with Sage, I took several classes online - Data File Structures, Crystal Reports, etc.  I can't find any resellers that offer these programs anymore and Sage seems to only offer X3 classes.  Yes, I see the YouTube offerings but I am looking…

  • Import list of product to run the Gross Requirements Report

    We use the Gross Requirement Report frequently and would like to know if it's possible to import the product list and its quantity instead of manually enter hundred of item numbers each time.  It's seems that the last ran list is stored in table BM_ComponentReportSelection…

  • Can the SYS DB be a Different Collation Method than the Company DB?

    Sage 300 2021 PU5 - SQL 2016

    I think I know the answer to this (no) but can the System DB be a different collation method than the company DB?  I ask since a new company is being brought onboard from an old Sage version environment where the company DBs…

  • back up error on settings - taxes

    By trying to create a backup (working on AIR assignrmnt) on Settings-company-taxes, the sysyem gives an error and allowing me to continue further:

    if i srart from back up, the software shows same issue on my previous record company-credit card.


  • Can a SQL standard database be converted from 3 digit to 2 digit suffix?

    We have a legacy standard database that is set as a 3 digit phase code suffix, example 03000.000.  We would like to convert it to a 2 digit suffix, example: 030000.00.  I tried to merge a 2 digit and 3 digit but the merge routine rejected the operation;…

  • Adding a markup to a number during Visual Integrator Import

    Running Sage 100 v2018 and am trying to create a VI import where one of the numeric fields being imported needs to have a $0.10 markup (i.e. if the field is populated with $2.35, the import should add .10 so the record would import the price as $2.45…

  • What is the Size Required to Create 2nd Store


    We are utilizing Sage 50 Quantum.  I need to create a 2nd store that will be about the same size as my current store. 

    The Data File Stats for my current store has a Grand Total of 771 MB.  In my Windows C Drive, my Sage folder is 79.2 GB.

    If I create…

  • VI Export Job: Issue Linking Tables

    I am needing to run an Open Balance Export job that contains specific headers that are located on different tables. The primary table I'm using is the `AR_OpenInvoice`, to which I am attempting to link to the `AR_InvoiceHistoryHeader` table. The problem…
  • VI Date Import with format of YYYY-MM-DD

    Running Sage 100 v2018.  Creating a VI import job where the field in the import file has a date format of YYYY-MM-DD.  Unfortunately there isn't a date format option matching the dashes ( - ).  Is there a perform or conditional expression I could use…

  • Using a Sage UDT (Sage Premium SQL table) as a source for a VI job?

    How can I use a Sage UDT SQL table as a source for a VI job? 

  • Copy Bill of Materials master files to a new company

    Has anyone copied the BM_Header and BM_Detail files from one company to another company?

    Just curious if there are reasons not to try this.

    We do not need any history, just the bill of materials master files.

  • Sage 100 Contractor 24.1 - New Important Notes feature

    This is a great new feature, but has a significant flaw.

    The important note uses the same field in the database, so therefore an important note prints on all documents where a note filed is already used on a printed form.  The means that if you want to…

  • google sheets

    We are running our Sage 100 Contractor on a cloud server host. As we occasionally need to export or use spreadsheets. As this is an RDP(remote desktop) situation, MS is not very accommodating with allowing this scenario. Is it possible to allow the product…

  • IC Item Change Error

    Getting an error 127 every time a client tries an item combine function. I believe the 127 indicates a duplicated field but I cannot find anything. RVSpy is giving no clues. Any ideas for where to look? 

  • Get SQL Instance from X3

    If I am logged into Sage X3, does anybody know how I can determine which SQL instance X3 is using?  I thought it was in the Administration section, but I can't seem to find it.  This is on V12.

  • Import of employee information from Arcoro into Sage CRE

    We are currently finishing up our Open Enrollment using Arcoro, and I would like to import this data into Sage 300 CRE since the sync they are developing is not finished yet.

    We mainly need the selections they made, deduction ID's so payroll can run with…

  • Syncing Sage50


    I can't get my Sage50 Cloud- 365. to sync with my main version. It stopped working in March on one computer.

    Not sure how to get them to sync???

    Can anyone suggest what to do!??