Browse By Tags

  • How do I join STOJOU to GACCCODE?

    I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

  • How can I go about joining the SINVOICED table to the STOJOU table?

    As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

  • Unable print _Manual check and payment register_databace connector error


    There is error message on the Sage100 as shown below. 

    How to fix the error?

    Thank you in advance for your help!

  • Oops, skipped a database conversion!

    We've skipped a database conversion during multiple upgrades (2017 to 2021), and now the database shows as "incompatible" and cannot be converted. The recommended solution is to get Professional Services involved. I'm wondering if I could start over with…

  • Exporting Data from Sage 300 Pervasive SQL Database on a Recurring Basis

    We are working with a company using Sage 300 on a Pervasive SQL database. 

    They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. 

    I'd like to know if there are any…

  • new password database error message, and i don't even use passwords. what does it mean?

    the following error message appeared unprovoked today:

    firebird database error

    cannot attach to password database

    class: EIBNativeException

    code: 335544653

    i can't even open the database. the minute i double click the icon, the error appears. can't get…

  • Betrieve Error #2

    I am currently using Sage DacEasy 2012.  I am currently trying to switch my "server" shared windows 7 pc to a window 10.  Somehow got messed up but still on windows 7 for time being. Have full version but currently only use ACC and POS.  Im coming…

  • Simply Accounting Cannot Connect to Connection Manager

    Please I cannot start my Simply Accounting Set up.

    It keep telling me cannot connect to Connection Manager.

    What should I do.


  • 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…

  • updating your main computer and a remote laptop from v24 to v25

    can any one help i had to update my sage accounts 50 because i moved my computer and all of a sudden the sage couldnt recognise the computer.

    so i was advised to cahnge and upgrade to v25 of which once i had done that my main computer worked. what i then…

  • Sage 300 Construction and Real Estate PRM tables Pervasive


    I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

  • 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…

  • What are the .PRD files

    What are the .PRD files of random products that are showing up in the data base about?

  • Upgrading application SQL Server to 2014


    My group has been task with updating our SQL Server to 2014. This is were the application and config databases are stored. What are the best practices for performing such a task?

    We are also using crystal reports but based off the system requirements…

  • Is Sage 300 ERP 21014 compatible with SQL Server 2016?

    An existing client Is running Sage 300 ERP 21014 and would like to migrate their SQL from 2008R2 to 2016.

    Is Sage 300 ERP 2014 compatible with SQL Server 2016?


  • 2015 DacEasy Accounting deposit number does not increment, when entering payment in the invoice.

    2014-2015 DacEasy Accounting win7pro, Server2008R2 network, win10pro

    When  procuring invoice, and entering payment in the payment field, the deposit number does not increment, but remains the same for indefinite period of time. It only increments when…

  • Renumber Sales Tax Districts and Sales Tax Entites

    We have been using Sage for about 5 years.  I have been using it for about 2 months.  My question is regarding the numbering of sales tax districts and sales tax entities.  If I have a sales tax district - let's call it 100 for example and it ties to a tax…

  • What's the latest build of SQL Server that you're safely using with Sage 100 Premium?

    Hi all!

    Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium.

    If you can supply the version of Sage 100 Premium (e.g., 2017) and the SQL Server build # (e.g., 12.00.554…

  • Does Sage HRMS 2017 support SQL HA (High Availability) databases?

    We will be upgrading to Sage HRMS 2017 and Sage Employee Self Service 2017 soon.  As our company has two data centers I am interested to know if these products support a SQL HA cluster so that I could offer failover capabilities that we've not had previously…

  • SEI Subqueries

    How are subqueries performed in SEI without creating a custom DB view ?

    Creating an Order Shortage Report.

    I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find the…

  • Deleting Warehouses in Sage 100 2017

    We just upgraded to Sage 100 2017.  Is there an easy way to delete warehouses?

  • Datetime fields ALL no longer allow nulls

    We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…

  • database upgrade error

    our accountant is trying to access the "sage fixed assets", just like any other sage user we have at the company 
    but she get this message "database upgrade ..the current database could not be opened because it is designed for use by a newer sage…

  • 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…

  • Sage 50 Canadian SDK - how to do wSDBGetDBVer in c#

    I am trying to use some of the features described in the documentation that came with the SDK. In the doc, dev-progref.pdf, I've read about the methods and they all seem to start with wSDB. I've seen that the wSDB* methods can be called in C++ and VB…