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
- 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
- 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)
- 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
- Paracetamol (Batch Number – Pm/002 – Date of manufacturing – 01-03-2021 and Date of Expire – 01-08-2021)
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
- Accounting Masters
- Create
- Masters
- 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
- Godown
- Inventory Masters
- 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
- Create
- Masters
- 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