Selling Stock Items from Batches/Lots in TallyPrime: 8 Easy Steps

TallyPrime allows you to sell stock items while considering the specific batches or lots they belong to.

This functionality is particularly beneficial for:

Perishable Goods: Prioritize selling older batches to prevent stock expiration.
Serialized Items: Track and manage sales of individual units with unique serial numbers within a batch.
Quality Control: Sell stock from batches that have passed quality checks.

Here’s a detailed explanation on selling stock items from batches or lots in TallyPrime with an example:

1. Prerequisites for Selling Stock Items from Batches or Lots in TallyPrime:

1. Enable Batches:

Ensure the “Maintain Batches” feature is enabled in Company Features (Gateway of Tally > Accounts & Taxes > Company > Configure Features).

2. Batches Configured:

The stock item you’re selling should have “Maintain in Batches” enabled in its Stock Item Master (explained in the post on Setting Up Batches for Stock Items).

2. Steps for Selling Stock Items from Batches in TallyPrime:

1. Gateway of Tally (Alt+F12):

Launch TallyPrime and navigate to the Gateway menu.

2. Create Voucher (Alt+F9):

Select “Create Voucher” and choose “Sales” (F8) to create a new sales invoice.

3. Select Party:

Enter the customer or party details for the sale.

4. Select Stock Item:

Choose the stock item you want to sell from the available list.

5. Stock Item Allocation Screen:

After selecting the stock item, you’ll enter the “Stock Item Allocation” screen.

6. Choose Batch:

Here, you’ll see a list of available batches for the selected stock item.

Choose the specific batch you want to sell from.

This selection might be based on factors like expiry date (for perishable goods) or specific quality control checks.

7. Quantity and Other Details:

Enter the quantity of the stock item you’re selling from the chosen batch.

You can also add other details like the rate per unit and any applicable discounts.

8. Complete Sales Invoice:

Enter any additional information required in the sales invoice and save the voucher (Ctrl+S).

3. Example: Selling Expiring Medicine

You have two batches of “Paracetamol 500mg” (set up with batches in the previous example).

One batch is expiring soon (Batch A), and the other has a later expiry date (Batch B).

A customer wants to buy 20 units of Paracetamol.

Create a new sales invoice and select the customer.
Choose “Paracetamol 500mg” as the stock item.
In the “Stock Item Allocation” screen, you’ll see both Batch A and Batch B listed.
Since Batch A is expiring sooner, select Batch A and enter the quantity of 20 units.
Complete the sales invoice details and save it.

4. Benefits of Selling from Batches:

1. Enhanced Inventory Management:

Ensures proper stock rotation and reduces wastage.

2. Expiry Tracking:

Prioritizes selling perishable goods nearing expiry.

3. Quality Control:

Allows for selling stock that has passed quality checks.

4. Serialized Item Tracking:

Manages sales of individual units with unique serial numbers (if applicable).

5. Additional Considerations:

You can view the remaining quantity for each batch within the Stock Ledger Enquiry report (Gateway of Tally > Reports > Inventory Reports > Stock Ledger Enquiry).
Consider using barcode scanners to efficiently track and manage sales from specific batches, especially for serialized items.
Explore third-party add-ons for TallyPrime that might offer advanced batch management and reporting functionalities.

By effectively utilizing the batch selection feature while selling stock items in TallyPrime, you can optimize your inventory management practices, prioritize stock rotation, and ensure compliance with expiry regulations (if applicable).