View Stock Based on Ageing Style in TallyPrime: 6 Easy Steps

You can’t directly view stock based on ageing style (purchase date, expiry date, manufacturing date, etc.) in a single report within TallyPrime.

However, you can achieve this by combining information from two reports:

1. Stock Ageing Analysis Report: This report categorizes your stock items based on how long they’ve been in your possession, using the chosen ageing style (purchase date by default).

2. Stock Summary Report (with Batch Tracking): This report provides details about your stock, including batch information, allowing you to link the batch details with the ageing style from the Stock Ageing Analysis report.

Here’s a detailed breakdown of the process:

Step 1: Generate the Stock Ageing Analysis Report

  1. Go to the Gateway of Tally (Alt+F12) in TallyPrime.
  2. Navigate to Display > More Reports > Statements of Inventory > Stock Ageing Analysis.

Alternatively, you can use a keyboard shortcut:

  • Press Alt+G (Go To) and type or select “Stock Ageing Analysis.”

Step 2: Select the Ageing Style in TallyPrime(Optional)

By default, the report might be set to “By Purchase Date.” However, you can change this if needed:

  • Press F9 (Ageing Style) to see the available options (e.g., Purchase Date, Expiry Date, Mfg. Date).
  • Select the desired ageing style based on your requirement.

Step 3: View Stock Age Breakdown

The report will display information like:

  • Item Name: Name of the stock item.
  • Date: Date of the report generation.
  • Total Quantity: Total quantity of the stock item currently in hand.
  • Age Slabs: User-defined categories representing different age ranges based on the chosen ageing style (e.g., 0-30 days, 31-60 days, etc.).
  • Quantity (for each Age Slab): Breakdown of the total quantity according to the defined age slabs. This indicates how much stock has been in hand for a specific period based on the chosen ageing style.

Example 1: Using Purchase Date as Ageing Style in TallyPrime:

Item NameDateTotal Quantity0-30 Days31-60 Days61-90 Days>90 Days
T-Shirt (M)2024-05-2710040302010
Jeans (Size 32)2024-05-27502515100

Step 4: Generate the Stock Summary Report (with Batch Tracking)

  1. Go to the Gateway of Tally (Alt+F12) in TallyPrime.
  2. Navigate to Reports > Inventory Reports > Stock Summary.

Step 5: Configure the Stock Summary Report

  • Press Alt+F12 (Configure) to access report settings.
  • Under the “Stock Valuation” section, ensure the report is set to display information “By Batch.” This allows you to link the age information from the Stock Ageing Analysis report with specific batches in the Stock Summary report.

Step 6: Analyze Stock Age with Batch Details in TallyPrime

The Stock Summary report (with batch tracking) will display information like:

  • Item Name: Name of the stock item.
  • Batch: Unique identifier for each batch of the stock item.
  • Purchase Date: Date on which the specific batch was purchased (relevant if “Purchase Date” is the chosen ageing style).
  • Expiry Date (if applicable): Date by which the specific batch expires (relevant if “Expiry Date” is the chosen ageing style).
  • Manufacturing Date (if applicable): Date on which the specific batch was manufactured (relevant if “Mfg. Date” is the chosen ageing style).
  • Quantity: Quantity of the item in the specific batch.

By comparing the information from both reports:

  • You can identify the age of each stock item based on the chosen ageing style from the Stock Ageing Analysis report.
  • You can link this age information to specific batches in the Stock Summary report (with batch tracking).
  • This allows you to analyze stock based on the chosen ageing style and manage your inventory more effectively.

Example 2: Combining Information:

Imagine you see in the Stock Ageing Analysis report (using Purchase Date) that 40 units of T-Shirts (M) have been in stock for 0-30

  • Now, you can utilize the Stock Summary report (with batch tracking) to identify which batches contribute to those 40 units with an age of 0-30 days.

By looking at the Stock Summary report for T-Shirts (M), you might see details like:

BatchPurchase DateExpiry Date (if applicable)Quantity
BATCH_A2024-05-252025-05-2530
BATCH_B2024-05-202025-06-2010

Here, you can see:

  • BATCH_A was purchased on 2024-05-25, which falls within the 0-30 day range of the Stock Ageing Analysis report.
  • This batch contributes 30 units to the total of 40 units in that age range.
  • BATCH_B was purchased before the 0-30 day range and likely contributes to older age slabs in the Stock Ageing Analysis report (not shown in this example).

Benefits to View Stock based on Ageing Style in TallyPrime:

  • This combined approach allows you to view stock not only by total quantity but also by age based on the chosen style (purchase date, expiry date, etc.).
  • You can identify aging stock within specific batches for better inventory management.
  • This helps with prioritizing sales of older stock to prevent obsolescence or expiry.

Additional Considerations:

  • You can utilize filters in the Stock Summary report to focus on specific items or batches.
  • Consider the chosen ageing style when interpreting the reports. For example, “Expiry Date” is crucial for perishable items, while “Manufacturing Date” might be relevant for warranty purposes.

By effectively combining the Stock Ageing Analysis and Stock Summary (with batch tracking) reports in TallyPrime, you gain a comprehensive understanding of your stock age distribution based on your chosen criteria, empowering you to make informed decisions regarding inventory control, stock rotation strategies, and potential write-offs.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

2 FREE Lessons Daily from TallySchool