How can we maintain Batch-wise details in 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

Advertisements