Results 1 to 2 of 2

Thread: Table Search Capability of Tally.ERP 9

  1. #1
    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.

  2. #2
    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.

Similar Threads

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

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,717,852,920.12897 seconds with 17 queries