Batch-Wise details is a part of advanced inventory management. Bath wise information useful where perishable goods like medicines, sea-food, dairy products (ex: ice -creams, butter milk) fruits, vegetables, flowers and meat , poultry etc. Batch-wise details is used widely in pharmaceutical industries as compared to to other sectors.

We can track manufacturing dates and expiry dates for products using with feature Bath-Wise Details.

ASSIGNMENT ON BATCH-WISE DETAILS

1. Purchase the following stock from Arabindho Pharmacy (state : Andhrapradesh) with ref no: Ar/010: and with GST @ 5% Dated: 01-04-2021
   
   • Ventolin (Batch Number ven/01 Date of manufacturing 01-01-2021 & Date of Expired – 01-06-2021) – 50 Boxes (each box has 100 Sheets and Each Sheet has 20 pills) – Each Pill ₹ 5.00 cost. And Stored at Dolapeta – Rajam Appolo Pharmacy)
     
   • Ventolin (Batch Number ven/02 Date of Manufacturing 01-02-2021 & Date of Expired – 01-07-2021) – 50 Boxes (each box has 100 sheets and each sheet has 20 Pills) – Each Pill has ₹ 5 cost (and stored at Bobbili Road Rajam Appolo Pharmacy)
     
   • Saridon – (Batch Number Sar/01 Date of Manufacturing – 01-03-2021 and Date of Expired – 01-08-2021) – 30 Boxes (each has box has 100 sheets and each sheet has 20 pills) – Each pill has 1rs cost) and stored at Dolapeta – Rajam – Appolo Pharmacy)
     
   • Saridon – (Batch Number Sar/02 Date of Manufacturing – 02-03-2021 and Date of Expired – 02-08-2021) – 30 Boxes (each has box has 100 sheets and each has 20 pills) – Each pill has 1rs cost). And stored at Bobbili Road – Rajam – Appolo Pharmacy

2. Purchase the following stock from Terrific Pharmacy (State : Andhrpradesh) with ref no: Tp/099. Dated: 02-04-2021 @ GST 5%
   
   • Paracetamol (Batch Number – Pm/002 – Date of manufacturing – 01-03-2021 and Date of Expire – 01-08-2021)
     • 100 Boxes (each box has 200 sheets, and each sheet has 30 pills) – Each Pill Cost – ₹ 5.00
     • The entire stock stored in ABC Pharmacy , Rajam
       
   • Paracetamol (Batch Number – Pm/002 – Date of Manufacturing – 02-03-2021 – Date of Expire – 02-08-2021)
     • 50 Boxes (Each box has 200 sheets, and each has 30 pills) – Each pill cost -₹ 5.00
     • The entire stock stored in Sri Pharmacy – SKLM
       
   • Asipirn (Batch Number – Asrp/001 – Date of Manufacturing – 01-02-2021 and Date of Expiry – 01-07-2021)
     • 200 Boxes ( Each box has 200 Sheets, and each sheet has 30 pills) _ Each pill cost – ₹ 6.20
     • The entire stock stored in Baba Pharmacy, Bobbili
       
   • Aspirin (Batch number – Asp/002 – Date of Manufacturing – 01-03-2021 and Date of expiry – 01-08-2021)
     • 500 Boxes (each box has 200 sheets, and each sheet has 30 Pills) – Each pill cost – ₹ 6,20
     • The entire stock stored in Suman Pharmacy – VZM

SOLUTION

SETTING UP FEATURES

• Press F11 for company Features
• INVENTORY:
  • Maintain Inventory : Yes
  • Integrated Accounts with Inventory : Yes
  • Enable Batches : Yes
  • Maintain Expiry dates for batches : Yes
• TAXATION:
  • Enable Goods And Service Tax : Yes
• Press Ctrl + A to Accept the all features

CREATING LEDGERS

• Gateway of Tally
  • Masters
    • Create
      • Accounting Masters
        • Ledger
• NAME : Arbindho Pharmacy
  Under : Sundry Creditors
  Maintain Balances Bill By Bill : Yes
  Select the state “Andhra Pradesh” from the list
  Press Enter
  Accept_ Yes
  
• NAME : Terrific Pharmacy
  Under : Sundry Creditors
  Maintain Balances Bill By Bill : Yes
  Select the state “Andhra Pradesh” from the list
  Press enter
  Accept_ Yes
  
• Name : Purchase A/c
  Under : Purchase Accounts
  Inventory Values Are Affected : Yes
  Is GST Applicable : Yes
  Set / Alter GST Details : Yes
  Nature of Transaction : Purchase Taxable
  Integrated tax : 5%
  Central Tax : 2.5%
  State Tax: 2.5%
  Press Enter
  Type of Supply : Goods
  Accept_ yes
  
• Name : CGST
  Under : Duties & Taxes
  Type of Duty / Tax : GST
  Tax Type : Central Tax
  Percentage of calculation : 2.5%
  Press enter
  Accept_ Yes
  
• Name : SGST
  Under : Duties & Taxes
  Type of Duty / Tax : GST
  Tax Type : State Tax
  Percentage of calculation : 2.5%
  Press Enter
  Accept _ Yes

CREATING GODOWNS

• Gateway of Tally
  • Inventory Masters
    • Godown
      Click on Create New option
• Name : Rajam – Dolapeta
  Address : Appolo Pharamacy, 11-5
  Press enter
  Allow storage of Materials : Yes
  Accept_Yes
• Create the remaining godowns same as above

CREATING UNITS

• Gateway of Tally
• Create
• Inventory Masters
• Units
  
• Type : Simple
  Symbol : Boxes
  Accept_Yes
  
• Type : Simple
  Symbol : Sheets
  Accept _ Yes
  
• Type : Simple
  Symbol : Pills
  Accept_ Yes
  
• Press Backspace to change the Unit Type
  Type : Compound
  First Unit : Boxes
  Second Unit : Sheets
  Press enter
  Accept _ Yes

CREATING STOCK ITEMS

• Gateway of Tally
  • Masters
    • Create
      • Stock Item
• Name : Ventolin
• Under : Medicines
• Units : Boxes of 100 sheets
• Alternate Units : Pills (Activate this option by pressing F12 configuration – Use Alternate Units : Yes)
• Where 20 pills = 1 sheet
• Additional Details :
  Maintain in Batches : Yes
  Track Date of manufacturing : Yes
  Use Expiry Dates : Yes
  Press enter
  Accept _ Yes
  
• Create the remaining items also

CREATING PURCHASE VOUCHER

Now enter the purchase voucher with the details above.

SEE MORE