View Transaction Details from Stock Query in TallyPrime: 6 Steps

Here’s a detailed explanation with every step on how to view transaction details from the Stock Query report in TallyPrime, utilizing the Voucher Display feature:

Step 1: Accessing the Stock Query Report

1. Open the Gateway of Tally (Alt+F12) in TallyPrime.
2. Navigate to one of the following options depending on your preference:
   • Display > More Reports > Statements of Inventory > Stock Query
   • Go To (Alt+G), type or select “Stock Query.”

Step 2: Selecting a Stock Item

• In the “Stock Query” screen, you’ll see a list of stock items.
• Select the desired stock item for which you want to view recent transactions.

Step 3: Viewing Transactions

The Stock Query report displays a list of recent transactions affecting the chosen stock item. This typically includes:

• Date: Date of the transaction.
• Voucher Type: Type of transaction (e.g., Purchase Bill, Sales Invoice, Stock Journal).
• Voucher No.: Reference number of the transaction.
• Party (Optional): Name of the party involved (supplier for purchases, customer for sales).
• Actual Qty: Quantity of stock received (positive) or issued (negative) in the transaction.
• Other Details (Optional): Depending on the voucher type, you might see additional information like rate, amount, or billed quantity.

Step 4: Accessing Voucher Display

Select a specific transaction from the list that you want to view in more detail.

There are two ways to access the Voucher Display:

Method 1 (Keyboard Shortcut):

Press Enter on the selected transaction.

Method 2 (Right-Click Menu):

Right-click on the selected transaction and choose “View Voucher” from the context menu.

Step 5: Understanding Voucher Display in TallyPrime

The Voucher Display provides a comprehensive view of the selected transaction, offering more details compared to the Stock Query report.

This typically includes:

• Voucher Type: (e.g., Purchase Bill, Sales Invoice, Stock Journal) – Same as in Stock Query.
• Voucher Date: Date of the transaction – Same as in Stock Query.
• Voucher Number: Reference number for the transaction – Same as in Stock Query.
• Party: Supplier or customer involved in the transaction (applicable for purchase and sales transactions).
• Narration (Optional): Any additional information entered about the transaction.

Step 6: Transaction-Specific Details

In addition to the general information, the Voucher Display shows details specific to the transaction type:

1. Purchase Bill:

You’ll see information like purchased items, quantities, unit prices, discounts, taxes, and the total cost.

2. Sales Invoice:

Details include sold items, quantities, unit prices, taxes, and the total revenue.

3. Stock Journal:

Information about stock adjustments, quantities moved between godowns (if applicable), and reasons for the adjustment.

1. Example of Viewing Transaction Details from Stock Query in TallyPrime:

Let’s say you selected a Purchase Bill from the Stock Query report for 20 “T-Shirt (M)” items at Rs. 500 per unit.

1. In the Voucher Display:

• You’ll see the Purchase Bill details like date, voucher number, and supplier information.
• It will list the purchased item (“T-Shirt (M)”), quantity (20), and unit price (Rs. 500).
• Additionally, you might see details about any discounts applied, taxes included, and the final total cost of the purchase. This provides a more complete picture of the transaction compared to the Stock Query report.

2. Benefits of Viewing Transaction Details in TallyPrime:

• Provides a comprehensive view of individual transactions affecting a stock item.
• Enables you to verify specific details like quantities, prices, and taxes for each transaction.
• Helps in identifying any discrepancies or errors in recorded data.
• Allows for reconciliation of inventory records and ensuring data accuracy.

3. Additional Considerations to View Transaction Details from Stock Query:

• You can navigate through different sections of the Voucher Display using keyboard shortcuts or by clicking on specific areas of the screen.
• The specific details displayed in the Voucher Display might vary slightly depending on the transaction type and your TallyPrime configuration.

By effectively utilizing these steps, you can easily view detailed transaction information from the Stock Query report in TallyPrime, empowering you to manage your inventory and analyze purchase or sales activities more effectively.