3305 Main Street Ste 019 Vancouver, WA 98663

KB All Products

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

Why is my Liberty Reports Add-in unresponsive?

Symptom After opening Microsoft Excel, clicking any part of the Liberty Reports Add-in results in no action taken. Re-installing Liberty Reports does not change this behavior. The following possible Cause & Resolution could relate to the following versions of Excel: Excel 2007 Excel 2010 Excel 2013 Excel 2016 Cause & […]
slide

Excel 2016 Query Table Bug

Background When using Sage Office Connector or Liberty Reports to insert a query in your Excel worksheet, the software automatically checks the "Fill down formulas in columns adjacent to query" box found in the External Data Range Properties window. This check box tells Excel to automatically copy formulas found in […]
slide

Will Liberty Reports for Sage 100 Contractor support the SQL Server Version?

Background The purpose of this article is to make you aware of our release plans for Liberty Reports as they relate to compatibility with Sage 100 Contractor v20 (the SQL release). As you may already be aware, the upcoming release of Sage 100 Contractor v20 is an extensive upgrade because […]
slide

How do I save a Liberty Report design as a Template?

This article provides the steps that you need to follow to save an Excel workbook containing Liberty Reports functionality as an Excel template. You should do this so that when your Liberty Reports solution is used, the user will be creating a new workbook from a template rather than opening […]
slide

How to Test Sage 300 CRE ODBC Driver (query)

BackgroundApplications such as Sage Office Connector, Event 1 Forecast, and Event 1 Integrator utilize the Sage 300 CRE ODBC Driver to query data from the Sage 300 CRE database. This article provides a set of steps that can be used to confirm whether the ODBC Driver is functioning as expected […]
slide

Integrator 2.92.0001

What's new in Integrator version 2.92.1 Posted 4/14/2015 We¬†strongly recommend that you read this information prior to upgrading. New versions may include new features that can help you, resolutions to known problems, and changes to supported environments. Summary 1 - Compatibility 2 - New Features 3 - Corrections 1 - […]
slide

How can I prevent the Security Warning when opening an Excel file?

Symptom When opening an Excel file that contains Liberty Reports or Office Connector queries or functions, a yellow notification bar may appear at the top of the worksheet with a "Security Warning". Background The security warning is not due to your Liberty Reports or Office Connector software and does not […]
slide

How to test writing to JC Master tables via ODBC

Background Applications such as Event 1 Forecast, Event 1 Integrator, and Sage 300 CRE Office Connector Write utilize the Sage 300 CRE ODBC Driver to create or update records in the Sage 300 CRE Job Cost database (specifically, the tables represented by Master.JCM). This article provides a set of steps […]
slide

How to Back Up a SQL Server Database

BackgroundYour SQL Server database resides on a SQL Server that manages all interactions (reading, writing, etc) of data as well as all administrative tasks. Making a backup of the data is therefore not just a matter of copying some files that exist on the network. This article explains how to […]