Summary of Post
When using Tally ERP 9 in companies dealing with large number of transactions, Tally Search features is a handy tool to find out a particular amount, amount between a minimum and maximum or a particular word in narration. We can do this using Range filter of Tally ERP9. I will explain this with some examples.
Search a Particular Amount in Tally erp 9
Search all vouchers with value 5000.For some reasons as an accountant of the company you want to know a particular voucher valued 5000.For that you don’t need check entire daybook. We can filter all vouchers with ledger amount 5000.
Gateway of Tally> Display>Daybook
Select the period in which you want to search the amount by pressing F2: Date
In the daybook click on F12:Range Button at the right bottom of the screen. or click Alt+F12 shortcut to access range filter screen.
Vouchers having ledger amount
In the Next column enter the amount your want to search for. in our example we are searching for voucher with amount equal to 5000.
Press enter again.Tally will start searching the amount and display all vouchers equal to 5000.00
Conditional search and & or
In the last column you can see condition and & or, what does this mean?
Conditional Search ‘And’.
For example : Suppose you want voucher with amount 5000 and contain a word “bill” in the narration.If all these two conditions met for a voucher then only display result.
- Do not display voucher having value 5000 only
- Do not display voucher having word “bill” in the narration
- Display result only if both the condition of 5000 as amount and bill in narration
Press enter you will have result fulfilling both the criteria
Just check whether the search result is meeting your request.
Conditional Search Or
Now let’s find out how ‘or’ search functions.Let’s take the same example,we need
- All the voucher with value 5000
- And all the vouchers with “bill” in narration.
Tally will display all vouchers with any one of these search criteria.
This will result, voucher with value 5000 & voucher with bill in narration like this.
How to search a specific word in the narration?
Many are specifically asking how to search narration of tally, this I have already explained above .Here is how?
Press enter,you will have all vouchers with that word.
Using Range filter you can define various search criteria like
To find out a party
Vouchers having Party name starting with xx
Vouchers having Party name contains xx
To search all vouchers entered through a voucher type
For example ,to get all vouchers entered through payment voucher
Voucher>Having>Voucher Type>Name>equal to>payment
Using range filter you can create various search parameters.You can search, voucher numbers,ledger name,voucher type and many more,This is really useful feature of Tally ERP 9.