In Tally.ERP 9, table search is the ability to 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, a list that is displayed to select anything such as a ledger, valuation methods, groups, units of Measurement, Tax Type, TDS nature of payment, Service Categories, Voucher Types, and Pay head Types is called a table.
Using the table search capability, you can 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, and search is applicable only to the first column of the table or list.
Example: Stock Item search in Sales Voucher
In this example, 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.
You can search for 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. You can also specify whether the search criteria should be applicable only to the first column or all columns of the table.
To configure table search,
In Advanced Configuration (Ctrl +Alt + F12 from Gateway of Tally) or F12: Configuration > General
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 whether the search criteria should be applicable to the first column or all columns of the table. This option is displayed only when Use 'Reducing List' for Tables is enabled.
Table Configurations can also be done form F12: Configuration > General
The Name based search displays information as shown below:
You can also search based on quantity by providing a number. All stock items containing the number 4 are displayed.
'Table Search Behavior in Tally.ERP 9' has been shared with
