Go Back   TechArena Community > ARENA > Guides & Tutorials
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 21-02-2011
Member
 
Join Date: May 2008
Posts: 432
Table Search Capability of Tally.ERP 9

Current Search Capability

The current Table Search capability in Tally.ERP 9, allows the user to highlight a particular set of Names based on the search text entered in the field. The text is searched from the beginning of the names in the list (This type of search is called �Starts with� search) and search is applicable only to the first column of the table/list.

Example: Stock Item search in Sales Voucher


n the above case names are searched based on the text entered N, in the Name of Item field and search is applicable only to the first column (Name of Item) in the table. Even after the relevant names are searched and highlighted, all the names (not required) are also displayed in the list/Table.

Lets take scenarios,

1. Where there are large numbers of names in the list/table and it is impossible for the user to remember the starting characters of the names. He may remember only a part of the name which he wants (required) to search.

2. After search, display only the relevant names based on the search text and not all the names in the table/list.

The current search capability doesnt support the above scenarios. To provide Quick and flexible search, the table search capability in Tally.ERP 9 has been enhanced.

New Search Capability Contains Search

The latest enhancement to table search allows the user to search a text from any part of the name which appears in the list. The table keeps on reducing and displaying only those names which fulfill the search criteria. Now it is also possible to specify whether the search criteria should be applicable only on first column or all columns of the table.

Enhanced search is based on the configuration settings. To configure table search, in Advanced Configuration (Ctrl +Atl + F12 from Gateway of Tally) Or F12: Configuration > General following Configuration options are provided
  • Use �Reducing List� for Tables (�Contains� Search): To allow the user to search a text from any part of the name that appears in the list. The table keeps on reducing and displaying only those names which fulfill the search criteria.
  • Apply for all Columns: To specify the search criteria should be applicable on first column or all columns of the table.

Advanced Configuration (Ctrl +Alt + F12 from Gateway of Tally) - Table Configuration Screen appears as shown


By default, both the above options will be set to Yes. User can alter/change configuration settings at any point of time.

Table Configurations can also be done form F12: Configuration > General


Let us now see the New Search Capability of Tally.ERP 9


The Name based search will display the information as shown below:


The search can also be performed in a List/Table containing multiple columns by providing the the necessary search keyword. e.g. search for Quantity of Items.

The Quantity based search (in the second column) to select required item is as shown


Tally.ERP 9 displays all the stock items containing Numeric 4

Table Search

In Tally.ERP 9, Table Search means select (identify) a company, stock Item, Ledger, Group, stock Group, Cost Centers etc. from the List.

For example:

1. Select a Company from List of Companies


List of Companies is called table (which contains names of companies in the selected path).

2. Select a Ledger from List of Ledger Accounts in a Voucher


List of Ledger Accounts is called table (which contains names of Ledgers)

3. Select a Stock Item from List of Items in a Voucher


List of Items is called table (which contains names of Stock Item)

Similarly, where ever List is displayed to select any thing say ledger, valuation methods, groups, units of Measurement, Tax Type, TDS nature of payment, Service Categories, Voucher Types, Pay head Types etc. is called Table.
Reply With Quote
  #2  
Old 20-04-2011
Member
 
Join Date: Nov 2008
Posts: 1,221
Re: Table Search Capability of Tally.ERP 9

I was really not aware that all this stuff would also possible on Tally. I was just using the same as a regular user. This can be much helpful if you can use an entire guide on the same. I had not found any better study material for that. And the reducing Table tip is nice. The next drop down box list you all the ledgers and when you press an alphabet it highlights them. But reducing them to that letter only increased the rate of your work.
Reply With Quote
Reply

  TechArena Community > ARENA > Guides & Tutorials
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Table Search Capability of Tally.ERP 9"
Thread Thread Starter Forum Replies Last Post
Migrating TCP Files from Tally 7.2 to Tally.ERP 9 RedZot Guides & Tutorials 2 24-04-2011 03:40 PM
How to get Windows XP search capability on Windows Vista? Karunashankar Operating Systems 5 25-03-2011 10:38 AM
How to Migrate TCP Files from Tally 9 to Tally.ERP 9 Format spookshow Guides & Tutorials 1 22-02-2011 12:27 PM
How to Migrate Tally 7.2 data to Tally.ERP 9 fumble Guides & Tutorials 1 22-02-2011 11:10 AM
Link a Table to another Table to Drop Down In Main Table himeshRES Windows Software 6 11-12-2010 02:01 PM


All times are GMT +5.5. The time now is 06:50 PM.