Tally

Stock Query in Tally

Posted by Asok K Nadhani on

Last Updated on: 5th July 2024, 01:47 pm

Stock Query in Tally

Stock Query

The Stock Query retrieves information from Inventory Master Record (like  stock item, Stock Group, Stock Category,  Remarks, Cost Price, Std. Selling Price, Costing & Market Valuation Method etc), and Vouchers (like Sales, Purchase, Debit Note, Credit Note, Stock Journal, Orders, Delivery Notes etc) ) at one centralized place for viewing

Stock Query Display

At Gateway of Tally, select Display > Statements of Inventory > Stock Query and then select the Item from List of Items to view the Stock Query screen of the selected Stock Item.

1 8

Stock Query showing Items under same Stock Group

Components of  Stock Query on Masters

Stock Query on Masters screen contains  following major Parts :

  • Stock Item Particulars: In this part, various important info of the Stock Item like Group, current closing stock, Stock Item remarks, details of last Purchase & Sale (Date, Party, Quantity & Rate) etc are shown.
  • Godown/Batch Detail : In this part, godownwise detail of the current available stock  (with Batch details, where applicable) are displayed
  • Items of the same Group / Category : In this part, details of other Items (Stock Quantity, Cost & sale Price) in the same Group / Category are displayed

Components of  Stock Query on Vouchers

Stock Query on Vouchers show specified voucher details satisfying the Query parameters

2 9

Stock Query results on Inventory Vouchers

Stock Query Configuration

At Stock Query, click F12:Configure to get Stock Query Configuration screen. Now set the Configuration as follows :

  • Show related Items of same Group : Set Yes to show other Items under the  same Stock Group, Set No to  show other Items under the  same Stock Category
  • Show All Aliases : Set  Yes to show all Aliases (otherwise Alias name are not shown)
  • Show using Alternate Units : Set  Yes to display Alternate Units information, where applicable
  • Show Tail Units of Compound Units : Set Yes to display Tail units (if the Stock Item is expressed in Compound Unit)
  • Show Remarks of the Item : Set Yes to display Remarks (as entered in the Stock Item master)
  • Show Description of the Item : Set Yes to show Item Description (as specified in the Stock Item master)
  • Show Last Nos. of Transactions Set Yes to display the last transaction Voucher Number & date
  • Show All Godown / Batches (incl. zero balance) : Set Yes to show Godwnwise / Batchwise details of current stock
3 9

Stock Query Configuration

Stock Query Buttons

Following special buttons are available in Stock Query screen

  • F4:Item : To select another Stock Item to show the Stock Query for the selected Stock Item
  • F5: Show / Hide Stat Info. : Toggle button to display the Statutory Info (Tax / VAT Information of the Stock Item) as defined in the Stock Item Master.
  • F6: Re-Orders : To display the Re-Order Status of the stock item.
  • F7: Price List : To display the Price List of the  Stock Item.
  • F7: Top Buyers/Sellers : To display the Top buyers and sellers for the Stock Item.
4 9

Stock Query Button Bar

Click here to see PDF