3305 Main Street Ste 019 Vancouver, WA 98663

All Products

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

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

What are the Sage 100 Contractor Account Types?

Account Types Each General Ledger account that is setup in Sage 100 Contractor is assigned an account type based on your General Ledger Setup. It may be useful to filter accounts based on account type when reporting. The account types are stored in the database as numeric values. The following […]
slide

How can I combine data from multiple databases in one Liberty Reports workbook?

Background Liberty Reports establishes one default connection for each type of database that is available. All of the Liberty Reports queries and worksheet functions reference a connection name and you can then change the database that a given connection is associated with at anytime. This makes it possible to have […]
slide

How to setup a Sage 300 CRE ODBC Data Source

Background An ODBC Data Source consists of a descriptive name that you provide and a Sage 300 CRE data folder path that it represents (among a handful of other settings). Applications that can utilize ODBC Data Sources will allow you to identify the source of data using the name that […]