3305 Main Street Ste 019 Vancouver, WA 98663

Blog Posts

Quick Aim 16.1

Understand and utilize your Sage 300 Construction and Real Estate database like never before! Includes documentation on: Custom Descriptions / Data Files / Record Relationships / Import Files / Functions / ODBC / Data Dictionary
slide

Common issues with custom reports after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Some PivotTables change after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Queries may not return correct results when conditioning on a nullable column after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Queries having parameters in the SELECT list fail after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Union queries containing parameters fail after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Queries with clauses in non-standard sequence fail after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Some GROUP BY queries fail after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Some SELECT DISTINCT queries fail after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]
slide

Queries with double-quotes around text literals fail after upgrading from Sage 100 Contractor v19 to v20

Background The upgrade from Sage 100 Contractor v19 to v20 represents a major change to the underlying database. Beginning with v20, Sage 100 Contractor now uses a Microsoft SQL Server database. Because of this, the database driver (which provides the connectivity between Liberty Reports and your Sage 100 Contractor data) […]