3305 Main Street Ste 019 Vancouver, WA 98663

KB All Products

slide

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 […]
slide

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 […]
slide

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 […]
slide

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 […]
slide

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 […]
slide

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. […]
slide

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 […]
slide

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 […]
slide

OC-Import Misc Worksheets Compatibility with Sage 300 CRE v15.1

Background The Import Misc Worksheets program that is installed with Office Connector Import utilizes certain Sage 300 CRE program interfaces that are specific to the version of Sage 300 CRE. Consequently, with each major version change of Sage 300 CRE, the files that are installed with Office Connector Import must […]
slide

How to schedule a Sage 300 CRE macro to run unattended

This article provides steps for executing Sage 300 CRE macros on a scheduled or unattended basis using Windows Task Scheduler.