3305 Main Street Ste 019 Vancouver, WA 98663

KB Liberty Reports

slide

Microsoft Excel 2016 Build 1708 Bug – Template Files Open Duplicate Workbooks

Scenario Attempting to open Liberty Reports or Office Connector Suite templates results in two duplicate workbooks being created from the template instead of one. Cause An update to Microsoft Office 2016, released on September 12th, 2017, introduces a bug which results in this behavior for all Excel template files, not […]
slide

An Unexpected Situation Was Encountered When Using Liberty Reports or Office Connector Suite Products In Microsoft Excel 2016 Version 1707

Scenario Attempting to utilize Liberty Reports or Office Connector Suite products results in an error stating, "An unexpected situation was encountered." Cause An update to Microsoft Office 2016, released on July 27th, 2017, includes a damaged copy of a Windows component required for Liberty Reports and Office Connector Suite products. […]
slide

Unable to Update Company Name

Background Due to a requirement for elevated privileges in some installed versions of Microsoft Office 2016, you may receive an error message when attempting to run licensing for Office Connector products. Error Unable to Update Company Name for... Resolution To gain the proper elevated prviliges when this occurs, please follow […]
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

Microsoft Office 2010 Security Update Impairs Functionality

Problem A recent Security Update to Microsoft Excel 2010 causes loss of functionality in some reports designed for Liberty Reports and Office Connector. While some reports may work, others may present the following symptom. Symptom During refresh, Excel will stop responding while calculating results. Recommendation In order to restore functionality […]
slide

Compatibility with Sage 300 CRE v16.1

Software Compatibility Alert Some or all of the functionality of the following products may be disabled by the installation of Sage 300 CRE v16.1 REV 4 This article describes the nature of the issues and their resolutions. If you intend to upgrade to v16.1, please read this article thoroughly before […]
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

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