शुक्रवार, 27 नवंबर 2020

Batch wise details with Godown

     

दोस्तो आपने हमारे अगले लेख Batch Wise Details Example-1, Batch Wise Details Example-02 ओर Batch wise Details example-4 में Tally में Batch wise details की प्रेकटीस की क्या आप Batch wise details का उपयोग गोडाउने के साथ कर शकते है आईए ईस नये उदाहरण Batch wise details with Godown की एन्ट्ररी कर के Batch wise details को गोडाउन के साथ प्रेकटीस करते है।

Batch wise details with Godown

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.

कोई टिप्पणी नहीं:

एक टिप्पणी भेजें

Thanks for Your Comment !!!