Batch wise details with Godown
Exp-3 Batch wise details with Godown
Step-1
Create Company Alfa Medicine.
Step-2
F11 Inventory Features-Storage & Classification
Maintain Batch Wise Details- Yes
Set Expiry Date for Batches- Yes
Create
Following Master:
Stock
Group: Liqwid
Creditors: - Amtul Parlour
1. A business is commenced
with introduction of Cash 400000, furniture
of Rs. 10000, Stock of Rs. 8000 and 8% loan of Pragna Rs. 100000
2. A current account is
opened with SBI Bank by depositing Rs. 200000
3. Furniture purchase Rs.
10000 payment is made though cheque.
4. Withdraw from bank Rs. 400
for personal expense and Rs. 700 for Office expense.
5. A cheque of Rs. 5000
received form Ranjan.
6. Fire insurance premium Rs.
450 and life Insurance premium of Rs. 300 & General insurance premium Rs.
800 are paid by cheque.
7. Paid Rs. 2500 for painting
work of shop.
8. Light Bill of Rs. 1000
paid by Cheque.
9. Rs. 5000 paid for
refreshment at inaugural function of shop.
10. A currency note of Rs.
2000 eaten by Goat.
11. Rs. 1500 Bad dept.
12. Goods worth Rs. 500 are
donated to Mahila Vikash Grah.
13. Goods of Rs. 150 are
distributed as free sample.
14. The business owner has
withdraw goods of Rs. 2000 and paid tuition fees of son Rs. 800 from business.
15. Interest of 3 month,
Paid on 8% loan of Pragna.
Name of Item |
Batch No. |
Godown |
Opening QTY |
Purchase QTY |
MFG Date |
Expire Date |
Rate |
Amtul Ghee TIN |
TIN-001 |
Anand |
1000 |
1550 |
April-23 |
April-25 |
425 |
Amtul Cow Ghee |
PKT-002 |
Anand |
1000 |
2550 |
May-23 |
May-25 |
420 |
Amtul 200 g Mozzarella Pizza
Cheese, Packaging |
PKT-032 |
Anand |
1000 |
1200 |
May-23 |
May-25 |
80 |
Amtul Taaza Milk |
PKT-022 |
Anand |
1000 |
2500 |
June-23 |
June-25 |
60 |
Amtul Tetra Milk Shake |
PKT-412 |
Anand |
1000 |
5000 |
June-23 |
June-25 |
28 |
Amtul Kool Kesar Bottle
100 Ml |
BTL-012 |
Anand |
1000 |
4500 |
June-23 |
June-25 |
100 |
Amtul Chees Cube |
PKT-0147 |
Anand |
1000 |
6500 |
July-23 |
July-25 |
400 |
Amtul Calci Milk |
PKT-0148 |
Anand |
1000 |
7000 |
July-23 |
July-25 |
8 |
Amtul Gold |
Pouch-003 |
Anand |
1000 |
25000 |
Aug-23 |
Aug-25 |
48 |
Amtul Sagar Ghee |
Pouch-004 |
Anand |
1000 |
750 |
Aug-23 |
Aug-25 |
500 |
Amtul Choco Buttery
Spread |
Pouch-016 |
Anand |
1000 |
1000 |
Aug-23 |
Aug-25 |
200 |
Shakti Milk 500 Ml |
Pouch-007 |
Anand |
1000 |
5000 |
Sept-23 |
Sept-25 |
28 |
Ø
Below Item Sales to Ramanand Sagar
Parlour
Name of Item |
Batch No. |
Godown |
Sales QTY |
MFG Date |
Expire Date |
Rate |
Amtul Ghee TIN |
TIN-001 |
Ahmedabad |
775 |
April-23 |
April-25 |
450 |
Amtul Cow Ghee |
PKT-002 |
Ahmedabad |
1275 |
May-23 |
May-25 |
460 |
Amtul 200 g Mozzarella Pizza
Cheese Packaging |
PKT-032 |
Ahmedabad |
600 |
May-23 |
May-25 |
93 |
Amtul Taaza Milk |
PKT-022 |
Ahmedabad |
1250 |
June-23 |
June-25 |
62 |
Amtul Tetra Milk Shake |
PKT-412 |
Ahmedabad |
2500 |
June-23 |
June-25 |
30 |
Amtul Kool Kesar Bottle
100 Ml |
BTL-012 |
Ahmedabad |
2250 |
June-23 |
June-25 |
120 |
Amtul Chees Cube |
PKT-0147 |
Ahmedabad |
3250 |
July-23 |
July-25 |
425 |
Amtul Calci Milk |
PKT-0148 |
Ahmedabad |
3500 |
July-23 |
July-25 |
10 |
Amtul Gold |
Pouch-003 |
Ahmedabad |
12500 |
Aug-23 |
Aug-25 |
51.5 |
Amtul Sagar Ghee |
Pouch-004 |
Ahmedabad |
375 |
Aug-23 |
Aug-25 |
550 |
Amtul Choco Buttery
Spread |
Pouch-016 |
Ahmedabad |
500 |
Aug-23 |
Aug-25 |
250 |
Shakti Milk 500 Ml |
Pouch-007 |
Ahmedabad |
2500 |
Sept-23 |
Sept-25 |
30 |
Ø
Below Item Sales to Sajid Parlour
Name of Item |
Batch No. |
Godown |
Sales QTY |
MFG Date |
Expire Date |
Rate |
Amtul Ghee TIN |
TIN-001 |
Ahmedabad |
388 |
April-23 |
April-25 |
450 |
Amtul Cow Ghee |
PKT-002 |
Ahmedabad |
367 |
May-23 |
May-25 |
460 |
Amtul 200 g Mozzarella Pizza
Cheese Packaging |
PKT-032 |
Ahmedabad |
300 |
May-23 |
May-25 |
93 |
Amtul Taaza Milk |
PKT-022 |
Ahmedabad |
625 |
June-23 |
June-25 |
62 |
Amtul Tetra Milk Shake |
PKT-412 |
Ahmedabad |
1250 |
June-23 |
June-25 |
30 |
Amtul Kool Kesar Bottle
100 Ml |
BTL-012 |
Ahmedabad |
1125 |
June-23 |
June-25 |
120 |
Amtul Chees Cube |
PKT-0147 |
Ahmedabad |
1625 |
July-23 |
July-25 |
425 |
Amtul Calci Milk |
PKT-0148 |
Ahmedabad |
1750 |
July-23 |
July-25 |
10 |
Amtul Gold |
Pouch-003 |
Ahmedabad |
6250 |
Aug-23 |
Aug-25 |
51.6 |
Amtul Sagar Ghee |
Pouch-004 |
Ahmedabad |
187 |
Aug-23 |
Aug-25 |
550 |
Amtul Choco Buttery
Spread |
Pouch-016 |
Ahmedabad |
250 |
Aug-23 |
Aug-25 |
250 |
Shakti Milk 500 Ml |
Pouch-007 |
Ahmedabad |
1250 |
Sept-23 |
Sept-25 |
30 |
Ø
Below Item Sales to Abrar Parlour
Name of Item |
Batch No. |
Godown |
Sales QTY |
MFG Date |
Expire Date |
Rate |
Amtul Ghee TIN |
TIN-001 |
Palanpur |
387 |
April-23 |
April-25 |
450 |
Amtul Cow Ghee |
PKT-002 |
Palanpur |
368 |
May-23 |
May-25 |
460 |
Amtul 200 g Mozzarella Pizza
Cheese, Packaging |
PKT-032 |
Palanpur |
300 |
May-23 |
May-25 |
93 |
Amtul Taaza Milk |
PKT-022 |
Palanpur |
625 |
June-23 |
June-25 |
62 |
Amtul Tetra Milk Shake |
PKT-412 |
Palanpur |
1250 |
June-23 |
June-25 |
30 |
Amtul Kool Kesar Bottle
100 Ml |
BTL-012 |
Palanpur |
1125 |
June-23 |
June-25 |
120 |
Amtul Chees Cube |
PKT-0147 |
Palanpur |
1625 |
July-23 |
July-25 |
425 |
Amtul Calci Milk |
PKT-0148 |
Palanpur |
1750 |
July-23 |
July-25 |
10 |
Amtul Gold |
Pouch-003 |
Palanpur |
6250 |
Aug-23 |
Aug-25 |
51.5 |
Amtul Sagar Ghee |
Pouch-004 |
Palanpur |
188 |
Aug-23 |
Aug-25 |
550 |
Amtul Choco Buttery
Spread |
Pouch-016 |
Palanpur |
250 |
Aug-23 |
Aug-25 |
250 |
Shakti Milk 500 Ml |
Pouch-007 |
Palanpur |
1250 |
Sept-23 |
Sept-25 |
30 |
Ø
Give payment receive entry.
Ø
Check Closing Stock.
Ø
Make a excel sheet of Pending
stock.