The “Search” fields allow you to enter information you know about an item and the system will search the database for matches. If you want to change the search values, then select the Clear Search Fields button. This button will restore the defaults of the Search For and Advanced Search Criteria fields. This button will not clear the Sources of Supply selected in the Check Sources of Supply section.
The Search For field supports special characters and reserved words for advanced searching based upon the database that is being used (that is, Oracle, IBM DB2 or Microsoft SQL server). For a complete list of the special characters and reserved words by your installation’s DBMS, please refer to "Appendix A”, “Appendix B”, and "Appendix C” in this user guide. The Search For field can be blank as long as a value is entered in at least one of the following Advanced Search fields: Vendor, Warehouse, or Commodity. The Search For field searches across the following fields:
Commodity Code
Commodity Description
Keywords from the Commodity (COMM) table (Only applicable if Commodities is selected as the Source of Supply)
Commodity Line Description
Manufacturer Name/Part Number (internal catalogs and MA Commodity Line specifications)
Document ID
On the Catalog Maintenance table:
Territory Available
Supplier Auxiliary ID
Text 1
Text 2
Text 3
The Advanced Search fields all default to blank.
Department – Multiple values can be entered by using commas.
Commodity - Multiple values can be entered by using commas.
Vendor - Multiple values can be entered by using commas.
Price (From) - When entered, the search will limit matches to those specified in the range of Prices indicated by the values in both the Price (From) and Price (To) fields. If Price (From) is populated then Price (To) is required, and vice versa.
Price (To) - When entered, the search will limit matches to those specified in the range of Prices indicated by the values in both the Price (From) and Price (To) fields. If Price (From) is populated then Price (To) is required, and vice versa.
Warehouse - This field is protected if Inventory is not selected as a Source of Supply
Expiration Date – If a date is entered, the search will limit matches to those Master Agreements with an Expiration Date greater than or equal to the value entered. You can also use the greater than, greater than or equal to, less than, and less than or equal to signs to filter the MA documents within the date parameter value.
Include Expired Agreements – Select Yes to include expired Master Agreements in the search results. Note: A commodity line is considered to reference an "expired agreement" if the MA document containing the commodity has an Expiration Date (on the MA Header) that is less than the Application Date on the Application Parameters (APPCTRL) table.
Mandatory Source Enabled - If Mandatory Source Enabled is set to Yes, then the system will only return those records that have the Mandatory Source flag selected. This includes any MA Commodity line (including MAs for Catalogs and PunchOut purchases) and any Commodity where Mandatory Source is selected. If Mandatory Source Enabled is set to No, a warning is issued indicating that Mandatory Source Agreements are not included in the search results.