accounts / TALLY / Tally Prime

How can we maintain Batch-wise details in Tally Prime?

Gallery Tally Prime

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
  1. 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

How do you enter Intrastate purchases and Intrastate sales with Cost centers and Cost Categories ?
Advertisements