Advance Search feature for Reconcile Statements Form

By | November 19, 2013

In our earlier post, we discussed the standard filtering/sorting feature available on Reconcile statement Forms.

In this article, we will discuss the enhancements that we made to search the transactions in conjunction with the standard filtering and sorting option.

Continuing with our earlier example; whereby we need to only list outstanding withdrawals transactions. This can be achieved using the standard filtering option. But now let’s say we need to locate a particular check using a check no. or find the all checks for a particular payee within the filtered transactions. With our Advance Search feature it is feasible to accomplish this type of complex searches.

We have provided Search By option on the Reconciliation tab under Reconcile Statements Form beside the standard selection fields.

Under Search By option we have provided search fields which are normally required for searching the transactions.

  1. Transaction Number (i.e.; Deposit No. or Check No.)
  2. Entry Number (Bank Entry No. or Transfer Document No.)
  3. Amount (Withdrawals or Deposits Amount)

After selecting the required selection field; you need to enter the search value and by using the Go button all matching values can be searched from the listed transactions.

Considering our example; where we need to search the particular check. Here we will have to select Transaction Number under Search By selection and enter check no. as search value. The program will locate the exact withdrawal transaction having the entered check no. and still keeping other filtered records intact (i.e.; outstanding withdrawal transactions).


Hence using the combination of standard filtering/sorting option and search by fields; it’s easier to locate the transactions.

Note: This customization is done using Sage 300 SDK, as a result, easy to deploy and it works with Sage 300 ERP 2012 and Sage 300 ERP v6.0A.

For more information on Auto Bank Reconciliation, write to us at
About Us
Greytrix is a one-stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.
Greytrix has some unique solutions of Sage 300 integration 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 to Sage business partners, end users, and Sage PSG worldwide.
For more details on Sage 300 Services, please contact us at We will be glad to assist you.