3305 Main Street Ste 019 Vancouver, WA 98663

KB Microsoft Products

slide

How to Test SQL Server ODBC Connectivity

BackgroundApplications such as Liberty Reports and Event 1 Integrator utilize the Microsoft SQL Server ODBC Driver to query data from SQL Server databases. This article provides a set of steps that can be used to confirm whether the SQL Server ODBC Driver is functioning as expected using tools that are […]
slide

Add Trusted Locations To Microsoft Excel

Background In some environments, Microsoft's Trust Center will not allow you to automatically add Event 1 Software, Inc. as a trusted publisher using the instructions listed here. If this occurs in your environment, the instructions listed below should help you resolve the matter. Recommendation Excel 2010 & above Do not […]
slide

Add Event 1 Software, Inc. to Microsoft’s Trusted Publishers

Background In some environments, Microsoft's Trust Center will not allow you to automatically add Event 1 Software, Inc. as a trusted publisher using the instructions listed here. If this occurs in your environment, the instructions listed below should help you resolve the matter. Recommendation Excel 2010 & above Do not […]
slide

Liberty Reports shows ‘invalid data drive’ message when trying to connect

Background Liberty Reports for Sage 100 Contractor uses the Sage 100 Contractor API when working with a Sage 100 Contractor database of version 19 or prior. The API is used to populate the list of known databases for use with Liberty Reports and is also used to validate login credentials. […]
slide

How to access a Sage 100 Contractor SQL database with Liberty Reports

Background Beginning with Sage 100 Contractor version 20, Microsoft SQL Server is now used for the underlying database that stores your Sage 100 Contractor data. Liberty Reports automatically adds databases to the list of known databases with Sage 100 Contractor version 19 and prior. This functionality is not possible with […]
slide

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

Background The purpose of this article is to make you aware of the status of Liberty Reports as is relates to compatibility with Sage 100 Contractor v20 (the SQL release). As you may already be aware, the release of Sage 100 Contractor v20 is an extensive upgrade because the underlying […]
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

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

2016 Viewpoint Annual Conference

This Viewpoint customer event is dedicated to education, collaboration, and partnership development.
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 […]