KB All Products
Making Sure Your Business Management Software Upgrade Goes Smoothly
While Event 1 Software strives to be aware of every possible contingency that could arise due to upgrading your Business Management Software, it is impossible to account for every type of implementation. Because of this, it is highly recommended that a test environment be created prior to upgrading a production […]Why Does My Query Sort Differently After I Upgraded to Sage 300 Construction and Real Estate (CRE) version 16.1?
Scenario After upgrading to the Sage 300 CRE version 16.1 the Office Connector queries are not sorting by the table’s primary key order. Explanation Sage utilizes a Software Development Kit (SDK) made by Simba Technologies to create the Sage 300 CRE ODBC driver. With Sage 300 CRE v16.1, Sage is […]Combining Multiple Base Accounts with Sage Office Connector Financials
This article explains how to create rows in a financial statement that combine the amounts of several base accounts. Strategies Option 1 – Include Individual Base Account Lines with Hidden Rows and Total Option 2 - Use BaseAccount Argument of TSGLAmount Function Option 1 – Include Individual Base Account Lines […]An Error Occurred While Attempting To Retrieve The List of Sage 100 Contractor Databases From The Server
Scenario When migrating from Sage 100 Contractor 2014 (version 19.x) to 2016 (version 20.x), the underlying database framework changes to Microsoft SQL Server. As there are considerable differences between the previous underlying database framework, Fox Pro, and Microsoft SQL Server, there are certain configurations which can result in the following […]How can I identify the installed version of the Sage 300 CRE ODBC Driver?
Background The Sage 300 CRE ODBC driver is installed as part of the Sage 300 CRE workstation or server install. Updates and hotfixes to Sage 300 CRE may include newer versions of the driver. Depending on specific issues that may be addressed by a given update, it may be important […]Anti-virus Policy Update Damages Office Connector and Liberty Reports .xla File
Background When using Sage Office Connector or Liberty Reports with certain anti-virus applications, a recent security policy update marks the Office Connector.xla or LR.xla file as dangerous and attempts to quarantine/disinfect/remove the file. Problem Office Connector.xla and LR.xla provide the main functionality for Office Connector and Liberty Reports. Once either […]Liberty Reports shows ‘invalid data drive’ message when trying to connect
Background Liberty Reports for Sage 100 Contractor uses the Sage 100 Contractor API when working with a Sage 100 Contractor database of version 19 or prior. The API is used to populate the list of known databases for use with Liberty Reports and is also used to validate login credentials. […]How to access a Sage 100 Contractor SQL database with Liberty Reports
Background Beginning with Sage 100 Contractor version 20, Microsoft SQL Server is now used for the underlying database that stores your Sage 100 Contractor data. Liberty Reports automatically adds databases to the list of known databases with Sage 100 Contractor version 19 and prior. This functionality is not possible with […]Does Liberty Reports for Sage 100 Contractor support the SQL Server Version?
Background The purpose of this article is to make you aware of the status of Liberty Reports as is relates to compatibility with Sage 100 Contractor v20 (the SQL release). As you may already be aware, the release of Sage 100 Contractor v20 is an extensive upgrade because the underlying […]