3305 Main Street Ste 019 Vancouver, WA 98663

When using the ‘Search Sage 300 Construction and Real Estate’ template, some searchable values are ignored

Background

This is a known issue with revision 9 and prior of this template. This issue applies to the Starter version of the template as well as the version supplied to licensed users of Office Connector Query.
  • Office Connector Starter
    • Filename: Search Sage 300 Construction and Real Estate.xlt
    • Found on the Starter tab of Office Connector Launch Pad and in Sage Desktop
  • Office Connector Query
    • Filename: TS Search Sage 300 Construction and Real Estate.xlt
    • Found on the Reports tab of Office Connector Launch Pad

Symptom

The values entered in the following cells of the Search worksheet are ignored when applying the search criteria for the following sets of results:
Cell (Field Name) Results Affected
GL AP AR JC PM
Extra X X X
Cost Code X X X
Category X X X
Commitment X X X
Commitment CO X X
Change Order X X
Draw X X
Property X
Unit X
Tenant X
Lease X
 

Resolution

A revised version of the template is available that corrects this issue.
  • Users of Office Connector Starter can obtain the new version (of "Search Sage 300 Construction and Real Estate.xlt") by contacting Sage support or by installing Sage 300 Construction and Real Estate 9.8 or higher (when available).
  • Users of Office Connector Query can click here to contact Event 1 Software's support group and request the current version (of "TS Search Sage 300 Construction and Real Estate.xlt").