How to Filter Finder Data in Sage 300 ERP

By | February 20, 2017

The Finder tool in Sage 300 ERP is used for the selection of the Key value for which the finder is specified. Finder tool can be launched by clicking the magnifier icon on the Sage 300 screen and also can be opened by selecting the control and pressing hotkey “F5”.

New Stuff: How Are Sage 300 Macros Used

Filter option is divided into various parts:

User can filter the data based on the field selected in the “Find By” list.

Item Finder

Below “Find By” list there is an option to select “Starts with” or “Contains” which is used for the fields other than fixed value fields (“Yes/No”,”Active/Inactive”,”Active/Quote/Standing/Future”)

Find BY Dropdown liat

Item Number in the above screen is not the fixed value field. So user has an option to select the searching pattern with specifying the initial value or specifying the value that is present withing the field (Before/After/Between).


Stock Item in the above screen is fixed value field. So user have fixed options to select the searching pattern as in above case “Yes/No”.

The searching text is entered in the “Filter” option.

Filter by Item Number

The Sage 300 filter in the finder also provides 2 options to filter the data

  • Auto Search check-box
    The filter is processed as the user enters the value in the control for the filter.

Filter by item number

  • Find New button
    User enters the searching text in the filter control and clicks on the “Find Now” button to filter the records.


So, filtering the records for the selection of the key values helps to faster the process of transactions in Sage 300 ERP.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at We will be glad to assist you.