KB All Products
Queries containing TRIM function no longer work after upgrading from Sage 100 Contractor v19 to v20
Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]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 […]Add Trusted Locations To Microsoft Excel
Background In some environments, Microsoft's Trust Center will not allow you to automatically add Event 1 Software, Inc. as a trusted publisher using the instructions listed here. If this occurs in your environment, the instructions listed below should help you resolve the matter. Recommendation Excel 2010 & above Do not […]Add Event 1 Software, Inc. to Microsoft’s Trusted Publishers
Background In some environments, Microsoft's Trust Center will not allow you to automatically add Event 1 Software, Inc. as a trusted publisher using the instructions listed here. If this occurs in your environment, the instructions listed below should help you resolve the matter. Recommendation Excel 2010 & above Do not […]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 […]