Will my Office Connector solution continue to work after upgrading Sage 300 Construction and Real Estate?

Background

Nearly 100% of the time, the answer to this question is 'yes', however an Office Connector solution consists of queries and functions that refer to specific tables and columns in your Sage 300 Construction and Real Estate database. Although it is very uncommon, a new version of Sage 300 Construction and Real Estate may include changes to the database that result in certain tables or columns being removed (because they are no longer necessary). If a table or column no longer exists in the database and your report design references the removed item, all or part of your report may not function.

Proactively Identifying Database Changes

Always refer to the release notes that accompany Sage 300 Construction and Real Estate in order to learn about any database changes that may be included. If the release notes identify a section such as “Database and Report Changes”, pay particular attention to the details conveyed in this area of the document.

Upgrading to Sage 300 Construction and Real Estate 12.1

This particular upgrade removes several columns from the JC Commitment table (MASTER_JCM_RECORD_12) while adding new columns to this table and others. If your Office Connector solution references this table, it could be affected by this upgrade if it references any of the columns that have been removed. To confirm whether your solution may be affected by these changes, review the list of removed columns in the release notes (identified on page 18 of ReleaseNotesAcctMgmt.pdf). Then check your Excel workbook or template design, or consult with the author of the report to determine if any of the removed fields are being referenced.

See also