KB All Products
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, […]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 […]Office Connector 2.04.0021
GL Financial templates have been enhanced to support calendar-period reporting. This will be of benefit to companies who have a fiscal year that does not end 12/31 but still wish to produce financial statements based on the calendar year.Why do my Office Connector functions return no value, zero, or a "#TABLE?" error?
Background Office Connector automatically optimizes the queries it uses behind the scenes when evaluating functions (such as TSLookup, TSFind, TSSum, and TSCount). It does this by keeping track of the set of columns that have been used from each table within a given workbook. The list of columns is stored […]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 […]