शनिवार, 28 नवंबर 2020

Batch wise Details example-4

             

क्या आप जानते हे tally में Batch wise details  क्या हे? Tally में Batch wise details का उपयोग कैसे करते हे? Batch wise details का उपयोग कौन करता हे? तो आइए आज हम Batch wise details के बारे में जानते हे. Batch wise details का उपयोग तब होता हे जब हमें tally में ऐसी inventory की entry करनी हो जिसमे manufacturing और Expire date लगानी हो.  तो आइये हम निचे दिए गए उदहारण Batch wise Details example 4 के जरिये Batch wise details की Entry करना सीखते हे।        

Batch wise Details example 4

Batch wise Details example-4


Exp-4 Batch wise details

      Ø  Step-1 Create Company Alfa Medicine.

       Ø  Step-2 F11 Inventory Features-Storage & Classification

o   Maintain Batch Wise Details- Yes

o    Set Expiry Date for Batches- Yes

 

        1)      Commenced business with introduction of capital  400000

        2)      Loan obtains of  60000 for Ataullahkhan.

        3)      300000 deposited with Union Bank and opened account.

        4)      Withdrawn  2500 from business for personal use.

        5)      Withdrawn goods of  1500 from business for personal use.

        6)       Dividend received  2000 through cheque. Cheque deposited with bank.

        7)      Paid  900 for life insurance premium from business.

        8)      100 shares of ShriBashra  Ltd. Purchase at  30 and 2% brokerage is paid. Both the payment paid         by cheque.

        9)      Goods of  1000 destroyed by fire. It was not insured.

        10)   Goods of  5000 are stolen from business.

        11)   Goods stolen receive back of  1000 on police investigation.

        12)   Goods of  2500 are destroyed by fire. Insurance company has admitted clam for it.

        13)   Goods of  4000 are destroyed due to sinking steamer. For with insurance company has admitted         claim of 50% amount.

        14)   Goods of  500 give as donation.

        15)   Goods of  200 distributed as free sample for advertisement purpose.

        16)   Goods of  400 received as a free sample from manufacturer.

        17)   Goods received on 16 number transition sold and realize  300.

        18)   Goods of  600 destroyed in rain, which is sold for  200.

        19)   Goods of  1500 are destroyed by fire. Insurance company has admitted claim of ₹ 900.₹ 200             realize from scrap of goods.

        20)   The goat ate the 2000 note as the 500 note.

Ø  Below item purchase for Anupam Bakery

Ø  All Purchase 15% Discount receives.

Ø  All Sales 10% discount paid.

 

Name of Item

Batch No.

Opening QTY

Purchase QTY

MFG Date

Expire Date

Rate

AlifSuji Rusk, 200GMS

PCS-001

500

1000

Jun23

June-25

50

Belgian Waffle

KG-215

500

1000

June-23

June-25

275

Buttermilk Alif Milk Rusk

PKT-147

500

1000

June-23

June-25

40

Instant Caramel Custard Mix

Box-52 one box 90g

500

1000

July-23

July-25

2500

Vizyon Sugar Paste

KG-125

500

1000

July-23

July-25

480

Sugar Free Toast

PKT-100

500

1000

July-23

July-25

100

Chocodelite

KG-145

500

1000

Aug-23

Aug-25

100

Instant vanilla cake

KG-50

500

1000

Sept-23

Sept-25

200

Ambrosia Rice Cake

PKT-62

500

1000

Oct-23

Oct-25

250

 

Ø  Below item sales to Star Bakery

Name of Item

Batch No.

Sales QTY

MFG Date

Expire Date

Rate

AlifSuji Rusk, 200GMS

PCS-001

1000

June-23

June-25

50

Belgian Waffle

KG-215

1000

June-23

June-25

275

Buttermilk Alif Milk Rusk

PKT-147

1000

June-23

June-25

40

Instant Caramel Custard Mix

Box-52 one box 90g

1000

July-23

July-25

2500

Vizyon Sugar Paste

KG-125

1000

July-23

July-25

480

Sugar Free Toast

PKT-100

1000

July-23

July-25

100

Chocodelite

KG-145

1000

Aug-23

Aug-25

100

Instant vanilla cake

KG-50

1000

Sept-23

Sept-25

200

Ambrosia Rice Cake

PKT-62

1000

Oct-23

Oct-25

250



शुक्रवार, 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.