KB All Products
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 […]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 & […]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.How To Add Office Connector Reports To Sage 300 Reports Menu
Introduction Some users may prefer to launch an Office Connector Report from within a Sage 300 CRE Module as opposed to the Office Connector Launch Pad. Note - This tutorial example is designed to work with the Timberline Construction Sample Data. Adding The Office Connector Report To The Sage 300 […]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 […]How can I get the total amount of the change orders for a specific cost code?
Background Change orders that impact the budget are stored in two tables within the Sage 100 Contractor database. The PM Change Order (prmchg) table contains the header information about each change order (such as the description, job number, date, etc.) and the PM Budget and Sub Change Order Line (sbcgln) […]How can I get a list of all cost codes for a job?
Background The Sage 100 Contractor database does not provide a single table that lists all of the cost codes associated with a given job. The cost codes that are associated with (have been used with) a given job can be found in four separate tables. They include the original budget, […]2016 Viewpoint Annual Conference
This Viewpoint customer event is dedicated to education, collaboration, and partnership development.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 […]