Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...

5.Batchwise Details in Tally.ERP9

Batch details are used to identify the movement of inventory in batches or lots. Although this is a requirement primarily of the pharmaceutical industry, the same can be used by other industries that maintain or manufacture perishable goods. Many organisations also purchase in batches in order to monitor the result of the batch purchased individually. Hence, Tally.ERP 9 has used the term Batch/Lot.

 

Batches/Lots are also often used to monitor the date of manufacture, date of receipt or the date of expected time when it cannot be further used (perished or expired). Tally.ERP 9 makes provisions to enter both the manufacturing date and the expiry date to take decisions as required.

 

In this section the following topics are discussed :

 

                    Activate Batch-wise Details and enter vouchers using them.
                    Set Manufacturing Date & Expiry Date for Batches.
5.1. Activating Batch-wise Details

Batch-wise details are given for maintaining batch information pertaining to stock items. The Man- ufacturing date and expiry date can also be set for batch wise details.

 

To activate Batchwise Details,

 

Go to Gateway of Tally > press F11: Features (Inventory Features).

 

                    Set Maintain Batch-wise details and set Expiry Dates for Batches to Yes.
Batchwise Details in Tally.ERP9
 
5.2. Using Batchwise Details in Purchase Invoice

On 15-12-09, purchased Saridon - 250 nos from GetWell Pharmacy @ 5.50 each with batch number ST/101 having Manufacturing date as 15-8-2009 and Expiry Date as 14-8-2010.

 

Setup:

 

       Create GetWell Pharmacy Ledger under Sundry Creditors

        Create the following Stock Item

          Name: Saridon

          Under: Medicines (create the group under primary)

          Category: Pain Killers (create the category under primary).

          Maintain in Batches: Yes.

          Track date of Mfg: Yes

          Use expiry dates: Yes

          Alter Standard Rates: No

          Rate of Duty: 5

          Retain all the other fields as default and accept the stock item creation screen.

                     Return to the Gateway of Tally.

‡        During Voucher entry, press F12: Purchase Invoice Configuration and set Honor Expiry Dates usage for Batches to YES

Step 1: Create Purchase Voucher

 

Go to Gateway of Tally > Accounting Vouchers > F9: Purchase

 

1. Enter the item as per the transaction details.

2. After you enter Saridon, an Item Allocation screen will appears,

        Enter the batch no. as ST/101 having manufacturing date as 15-8-09 and Expiry Date as 14-8-10.

    3. Select Onsite in Godown field. The Batch details appears as shown below :
Batchwise Details in Tally.ERP9

4. Allocate it to Purchase account (not project purchases). Purchase invoice number NM. Credit period 60 days.

 

5. Press Enter and accept the voucher.
 
5.3. Using Batchwise Details in Sales Invoice

On 27-12-09 , raise a Cash Sales Invoice for 200 nos of Saridon @ Rs. 7.50 from the above

Batch No.ST/101.

 

 

Setup :

 

       Create Cash Ledger under Cash-in-Hand group

       Activate Cost Centre for Export Saes Ledger

 

 

Step 1: Create Sales Voucher

 

Go to Gateway of Tally > Accounting Vouchers > F8: Sales

 

1. Enter the item as per the transaction details.

2. Select the Batch as ST/101

3. Select Godown as Onsite

4. Select the Sales Ledger as Export Sales

5. Allocate the Sales to Cost Centre : Amar

 

 

Step 2 : View Stock Sumary

Go to Gateway of Tally > Stock Summary > Medicines

 

         Specify the date as 27-12-2009

       Press F1: Detailed, you will find that the stock balance is 50 nos.

 

 

Practice Exercise

1. On 28-12-09, raise another purchase invoice on GetWell Pharmacy with the following details

       Batch No. : ST/102

       Quantity : 300 nos

       Rate : Rs. 6 per nos

       Godown : On-site

       Manufacture date : 15-8-09

       Expiry date : 31-12-09

                    Purchase Ledger : Purchases

        Total Invoice Value : Rs. 1,800

2. On 1-1-10, make a Cash Sales Invoice for Saridon - 50 nos from batch ST101 and 200 nos from batch ST102 @ Rs. 7.50 each.

Batchwise Details in Tally.ERP9

        You may not be able to display the batch ST/102, use backspace key and go back to the invoice screen and change the invoice date to 31-12-2009.

 

Tally.ERP 9 displays the batch ST/102 as shown below :

Batchwise Details in Tally.ERP9
Tally.ERP 9 does not display batch ST/102 when we make the entry on 1-1-2010 because the expiry date of ST/102 was 31-12-2009. But when we changed the entry date to 31-12-2009 the batch is displayed! This is because the option Honor Expiry Dates usage for Batches is set to Yes in the F12: Configuration.
 
 
Text
 
 
Company Information @ Tally.ERP9
 
Group & Ledger

Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES

Advanced Inventory / Stock
Meaning
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Tally.ERP9 Report
  1. Unit Objectives
  2. Modifying Reports (Options)
  3. Balance Sheet
  4. Profit & Loss Account
  5. Stock Summary
  6. Trial Balance
  7. Day Book
  8. Books of Accounts
  9. Statement of Accounts
  10. Inventory Books
  11. Statutory Reports
  12. List of Accounts ( Chart of Accounts)
  13. Exception Reports
  14. Printing Reports
Tally.ERP9 MIS and Other Reports
Statutory & Taxation
Utilities & Others @ Tally.ERP9
Credit Limits
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
 
Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website.

 
GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com