3305 Main Street Ste 019 Vancouver, WA 98663

KB All Products

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

Queries containing TRIM function no longer work 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) […]