3305 Main Street Ste 019 Vancouver, WA 98663

KB All Products

slide

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

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

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

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.
slide

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 […]
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 can I show an employee name as "FirstName LastName"

Background Sage 300 CRE stores names in 'LastName; FirstName' format so that when data is sorted by name, it will be sorted by last name. This article covers how show names with 'FirstName LastName' format. This could apply to PR Employee Names, AP Vendor Names, AB Contact Names, and AR […]
slide

Why can't I login with Liberty Reports for Sage 100 Contractor?

Background Liberty Reports for Sage 100 Contractor uses your Sage 100 Contractor login credentials when making a connection to your data. The login credentials that you enter are validated using the Sage 100 Contractor API. This article describes some possible reasons that you might be unable to successfully login.   […]