INVENTORY QUESTION AND CO-ORDER VOUCHER(TALLY NOTES PART-3)

 

INVENTORY VOUCHER

                    INVENTORY  QUESTION

     SHORTCUT KE :-

     *  Alt+f3 –compant info

     * Alt+A  - Alter

    * Alt+S – select company

    * Alt+B – Backup

    * Alt+R – Restore

    * Alt+H – Shut down

    * Alt+P – Profit&Loss

    * Alt+D – Display

    * Alt+V – Accounting voucher

   * Alt+C – Creat company

   * Alt+P – Split Company data

   * Alt+B – Balance sheet

    * Ctrl+N – Calculator

   * Ctrl+T – trial Balance

     * Ctrl+D – Day Book

    * Ctrl+M - Remove

 

  

 

 

 

 

 

 

   ACCOUNT WITH  INVENTORY

    LEDGER  (CO-Hero Honda Ltd.)

      

*Capital                                                                       CapitalA/c

*Bank                                                                            BankA/c

*Purchase                                                                 purchaseA/c

*Sales                                                                                 SalesA/c

*Sales return                                                                    SalesA/c

*Tax                                                                            Duties &Tax

*Mohan Automobile                                            Sundrycreditor

*Shyam Automobile                                              SundryDebtor

 

STOCK GROUP

Hero Honda       [primary]

T.V.S                  [Primary]

L.M.L                [primary]

 

 

 

STOCK CATEGORIES

Bike               [Primary]

Car               [Primary]

 

Unit  Of Measure

Pcs      -  pieces

 

NAME	CATEGORY	UNDER	UNITS	COST PRICE	SELLING PRICE
Honda City Vespa Splender Plus Passion Plus Vector Freedom	CAR SCOOTY BIKE BIKE SCOOTER BIKE	HONDA PIAGGO HERO HONDA	PCS PCS Pcs Pcs Pcs pcs	500000 25000 40000 45000 30000 45000	600000 28000 45000 50000 38000 49000

STOCK  ITEM

1.Abdul & Sons started business with Rs.500000 Cheque.

2.Own purchase 200 pieces Passion plus and 150 Splender plus from Mohan Automobile.

3.Own purchase 10 pieces Honda City ,Vector 200 pieces for cheque.

4.Own purchase 200 pieces Vespa & 300 pieces Freedom from Mohan Automobile.

5.Sold to Shyam Automobile 20pcs Vector, 10pcs Freedom, 7pcs Honds City for cash.

6.Sold to Shyam Automobile 30pcs Splender Plus , 20pcs Passion Plus.

7.Sold to Shyam Automobile ie Honda City 2pcs for cheque.

8.Shyam Automobile return 2pcs Splender plus.

Note :-

*F11 – Debit & credit Note – Yes

*Sales return – Credit note

*Purchase return – Debit note

[Allow Standard rates?  -yes]

(Press F12)

*Display – Statement of Account – Outstanding –           receivable/Payable.

*Then after Accounting Voucher esa tkdj Receivable or Payableesa show dj jgsa Amount dks  Transaction djsxsa A

*dgus dk eryc gS Receivable wala Amount Receipt Voucher esa tkdj Receive djuk gS A Same pht Payable ds lkFk Hkh djuk gSA

 

2. Inventory (co-Duty &Taxes).

   Ledge :-   

*Capital                                                                                    CapitalA/C

* Central Bank                                                                           Bank A/C

*Canara Bank                                                                             Bank                               

* Sale Electronic                                       Sales A/C (NotApplicable)

* Purchase Electronics                                                   Purchase A/C

 * M/S Anamika Electronic                                       SundryCreditor

 * Mr. Raj Electronics                                                   Sundry Debtor

 

Stock Group:-

Electronics – Primary

 

 

Stock Item:-

        Cost                        Name                             Selling Price

        20,000                   Refrigerator(LG)                        25,000

        25,000                   Refrigerator                        30,000

                                        (Samsung)

        24,000                   Refrigerator                        26,000

(Elec.)

        30,000                   Refrigerator                        35,000

                                        (Kelvinator)

        4,500                     T.V. (Akai)                           5,000

        8,000                     T.V. (Sony)                          9,500

        7,500                     T.V. (T-Series)                   9,000

        8,500                     T.V. (Philips)                    10,000

        7,000                     T.V. (Onida)                      7,900

        25,000                   Music System                   30,000

                                                (Sony)

 

12,000                   Music System                         15,000

                                        (T-Series)    

20,000                   Music System                         24,000

                                        (Lenovo)

15,000                   Music System                         18,000

                                        (Philips)

10,000                   Washing Machine                12,000

                                        (Samsung)

20,000                   Washing Machine                25,000

                                                (L.G.)

1 .Ak pvt ltd. Started business with Rs.50000000 cash

2. Purchase following item  from M/s Anamika Electronic pvt. Ltd Refrigerator(L.G) 10pcs, (samsung) 5pcs, (Electronic) 3pcs. Tv(sony) 5pcs, (T-Series) 5pcs, (philips) 5pcs, T.V. (onida) 20pcs.

3. Purchase followind item from M/s Anamika electronics Pvt. Ltd:-Music system(sony) 5pcs, (T-Series) 10pcs, (Philips) 10pcs, washing machines:-   (samsung) 10pcs, (L.G) 10pcs.

4.Sales following goods to Raj electronics Pvt ltd :- Refrigerator (L.G) 5pcs, T.v(onida) 2pcs, Music system (sony) 2pcs, Washing Machine (samsung) 2pcs.

 

5. Cash sales following item ,Bill No :- 1.06.2010

Refrigerator 1pcs (L.G) , 1pc.(samsung), T.V(Akai) 2pcs, (onida) 2pcs, Washing Machine (L.G) 2pcs.

 

 

 

How to check…….?

Got  - Display – Statement of Accounts – Receivable &payable

 

Inventory (company-Sagar)

Ledger :-

Capital                                                                                     capital A/c

Bank                                                                                         Bank  A/c

Purchase                                                                            Purchase A/c

Purchase Automobile                                                     Purchase A/c

Purchase Medicine                                                           Purchase A/c

Sales                                                                                      Sale  A/c

Sales return                                                                          sales A/c

Sales Automobile                                                                 Sales A/c

Sales Medicine                                                                      Sales A/c

Mohan Pharma                                                    Sundry   Creditor

Raju Pharma                                                         Sundry Debtor

Sunil Automobile                                                  Sundry Creditor

Shyam Automobile                                               Sundry Debtor 

 

STOCK GROUP :-   

Hero Honda [ Primary ]

T.V.S [primary]

Cipla [Primary]

 

 

STOCK  CATEGORY :-

*Car [Primary]

*Bike [Primary]

*Tables [Primary]

*Capsules [Primary]

*Injection [Primary]

*Syrup [Primary]

 

UNIT OF MEASURES :-

1. pcs(pieces)

2. st(strips)

3. ct(cartoon)

4.ct = 100

5.ct = 100 =pcs

 

STOCK ITEM :-

*Honda City pcs.[car]

*Passion Plus pcs.[Bike]

*Splender Plus pcs.[Bike]

*Vector T.V.S  pcs.[Bike]

*Max 100  pcs. [Bike]

*Benadrill  ct.[syrup]

*Perryton  ct.[Syrup]

*CB12 ct.[Injection]

*Decadorabin ct.[Injection]

*Asomex ct.[Tablets]

*Saridon ct.[Tablets]

*Disprin ct.[Tablets]

*Biscasual ct.[Tablets]

1.Rajesh & co. started business with cash Rs.3000000 & 5000000  for cheque.

2.On purchase 200pcs. Max100@35000 for cheque.

 

3.Our purchase 100pcs. Splender plus @40000 andPassion plus 100pcs. @45000 from Sunil Automobile.

4.Our purchase Honda City 100pcs. @ 500000, vector 200pcs. @30000 from Sunil Automobile.

5.Purchase Return 5pcs. Splender plus to Sunil Automobile.

6.Withdraw cash from Bank for office use Rs.25000.

7.On purchase 5ct. saridon @1500& Disprin 40ct.@1000 from Mohan Pharma.

8.On purchase Decadorabin 20ct.@ 2000 & CB12-25ct.@1800 for cheque.

9.On purchase parryton 2ct.@1500 & Benadrill,7ct.@1800 from     Mohan Pharma.

10.On purchase ,Biscasual ,10ct@130 for cheque.

11.Sold to shyam Automobile, Splendor plus ,10pcs.@45000&              Passion plus 3pcs.@50000.

12.Sold to Shyam automobile, 3pcs. Honda city car@600000& vector 13pcs.@35000.

13.Sold Max 100,12pcs. @40000 & 5ct. saridon @1800 for cash.

14.Sold to Raju Pharma ,Decodorabin 1ct.@ 2200 & CB12, 2ct@2000.

15.Sales Return to Raju Pharma 3pcs. Decadorabin, 1pc. CB12.

 

 

1.            INVENTORY QUESTION :-

LEDGER :-

·     S.K.S Electronics – Sundry Creditor

·     Ranjeet Electronics – Sundry Creditor

·     Rajan Electronics – Sundry Debtor

·     Digital Computers – Sundry Debtor

·     Bank  - Bank A/c

·     Salary - Indirect Expense

·     Office Rent - Indirect Expence

 

·     Purchase  - Purchase A/c

·     Purchase return  - Purchase A/c

·     Sales - Sales A/c

·     Sales Return  - Sales A/c

 

 

 

STOCK GROUP  :-

·      L.G

·      Samsung

·      Videocon

SROCK  CATEGORIES :-

·      T.V

·      V.C.D

·      Computer

·      Laptop

UNIT OF MEASURES  :-

You will need to create unit of measures ,you have purchase and sold and maintain how many quantity.

E.g :- pcs.= pieces.

 

 

STOCK  ITEM :- Primary entity of inventory.

NAME OF ITEM	COST PRICE	SELLING PRICE
L.G  Telivision (42)	40000	72000
Samsung Laptop	30000	35000
VCD (Videocon)	500	900
(L.G) Computer (coredue)	15000	19000
(32)Telivisoin (L.C.D)(Videocon)	15000	22000

                                                 

1.  Ramesh company started business with Rs 1 Crore cheque + 500000 for cash.

2.  Purchase 100pcs. T.V (L.G)(42) + 200 Pcs. Laptop (Samsung)from S.K.S electronics. Ref. Invoice No.- P/S/01.

3.  Purchase 100pcs. VCD (Videocon)& 200pcs. computer (Core 2duo) (L.G) From Ranjeet Electronic. Ref Invoice no.- P/S/02.

4.  Paid to S.K.S electronics full amount again by cheque . Bill no:-P/S/01.

5.  Sold to Rajan Electronics ,20pcs. computer (L.G) & 15pcs. Laptop (Samsung). Sales invoice no :- S/R/01.

6.  Purchase 100pcs. T.V. (LCD) (Videocon) ,S.K.S electronic. purchase Invoice No:- P/S/03.

7.  Paid to Ranjeet electronic against invoice no :-P/S/02 by cheque.

8.  Sold to digital Computer ,20 pcs. (L.G) Computer , 30pcs. Telivision (Videocon). Sales invoice No:-S/O/02.

9.  Sold 5pcs. V.C.D for cash.

10.                  Received cash from Rajan electronics against Invoice No:- S/O/01.

11.                  Return 2pcs. Laptop to S.K.S electronic .

12.                  Return 1pcs. computer from digital computer.

13.                  Paid office Rent Rs.30000 from cheque.

14.                  Paid salary Rs50000 cash & Rs600000 for cheque.

 

 

       

 

 

 

 

 

INTERODUCTION OF

CO-ORDER VOUCHER

Inventory Voucher are used for stock related all types of tranjection.

TYPES OF INVENTORY VOUCHER :-

1.  Purchase order voucher – Alt+F4

2.  Sales order Voucher – Alt+F5

3.  Receipt Note Voucher – Alt +F9

4.  Delivery Note Voucher – Alt +F8

5.  Rejection in Voucher – Ctrl +F6

6.  Rejection out Return Voucher – Alt +F6

7.  Stock Journal Voucher –Alt +F7

8.  Physical Stock voucher – F10

 

1.  PURCHASE ORDER VOUCHER :- Can be record all types of                                                                                   purchase order tranjection.

*Press F11- Go to inventory Feature – purchase order processing –“yes”.

2. SALES  ORDER VOUCHER :- Can be record type of sales order tranjection.(same as purchase order)

3.DELIVERY NOTE VOUCHER :- Can be recorded deliever of goods  to customer .

ACTIVATE :- Press F11 – Go to inventory –use tracking .No (Delievered receipt Note).

4.RECEIPT NOTE VOUCHER: –Can be record receipt of goods by   Supplier.

ACTIVATE :- “DO”

5.REJECTION IN VOUCHER :- Can be record return rejected goods from customer .

ACTIVATE:- Press F11- Go to inventory feature – used rejection invoucher –“yes”

2.  REJECTION OUT VOUCHER :- Can be record as return rejected  goods to supplier.

ACTIVATE :- vice-versa (same)

3.  STOCK JOURNAL VOUCHER :- Stock journal voucher are used to  stock transfer b/w two or more location.

4.  PHYSICAl STOCK VOUCHER :- Physical stock voucher are used to physically verify of stock.

PURCHASE	SALES
Purchase order	Sales order
Receipt note	Delivery note
Purchase	Sales
Payment	Receipt
Rejection out	Rejection in
Debit note	Credit note
Receipt	payment

 

 

1.CO. ORDER VOUCHER

1. LEDGER :-

Moan Automobile – Sundry creditor

purchase – Purchase A/c

HCFC BANK – Bank A/c

Sale  - sales A/c

Shyam Automobile – Sundry Debtor

 

UNITS OF MEASURES :-

Pcs – pieces

 

Stock Item :-

Splender  plus

 

 

1.  Amar & company started business with Rs.20000000 Cheque. (HDFC).

2.  Purchase order 200pcs. Splender Plus from Mohan Automobile @40000.Purchase order No.Po/01.

3.  Create a receipt note against Purchase order No.Po/01.(receipt note No.”rcpt/01).

4.  Purchase Splender Plus from Mohan Automobile Against receipt no.-rcpt/01. purchase invoice no:-P/01.

5.   Paid to Mohan automobile against purchase Invoice No:-p/01 by cheque (HDFC).

 

6.  Return rejection Splendor Plus to Mohan automobile 20pcs.

Rejection out No:-RJCT out /01.(New no-ord no:-Not apply)

7.  Create a Debit Note against rejection out NO. :-RJCT out/01.

8.  Receipt amount from Mohan automobile against Debit Note-Dbt/01.

9.  Receipt –Sales order from Shyam automobile 100pcs @45000. sales order No :-So/01.

  10.Delievery splendor plus to Shyam automobile against Sales order .No:-So/01.  Delievery note no:- Devy/01.

11.Sold Splendor Plus to Shyam automobile against deliever note     no:-Devy/01. Sale invoice No:-S/01.

  12.Receipt cheque from Shyam automobile against Sales Invoice   No:-S/01.

    13.Return 10pcs. rejected Splendor Plus from Shyam automobile .  Rejection in No:- Reject In/01.

14.Create a credit Note to Shyam automobile against rejection In Voucher No:-Reject In/01. Credit Note No :- Cdt/01.

15.                  Paid to Shyam Automobile Against Credit Note No:-Cdt/01.(cheque)

 

 

 

 

 

2.CO ORDER  VOUCHER

LEDGER :-

·      Kapoor pharma –Sundry Creditor

·      Purchase – Purchase A/c

·      HDFC  - Bank A/c

·      Sale – Sales A/c

·      Jain Medical – Sundry Debtor

UNIT OF MEASURES :-

Symbol – Pcs                   Formal – Pieces

 

Stock Item:-

OLOPAT KT EYE DROP
  

1.Rathore & Company started Business with Rs.50000000 cheque      (HDFC).

2.   Purchase order 50ct. OLOPAT KT EYE Drop from Kapoor Pharma @20000 Purchase order NO:-PO/01.

3.   Create a receipt note against purchase order no. PO/01.(receipt note no. rept/01).

4.   Purchase OLOPAT KT EYE Drop from Kapoor Pharma against receipt no:- rept/01.Purchase invoice no:- P/01.

5.   Paid to Kapoor Pharma against purchase invoice no.P/01 by cheque (HDFC).

6.   Return rejected OLOPAT KT Eye Drop to Kapoor Pharma 10ct. Rejection out no:- RJCT out /01.

7.   Create a debit note against rejection out no: RJCT out /01. Debit note no :- Debit/01.

8.   Rejeipt amount from Kapoor Pharma against Debit note . Dbt/o1.

9.   Receipt sales order from Jain medical 30ct. @ 30000. Sales order No:- SO/01.

10.Deliever OLOPAT KT Eye Drop to Jain Medical against sales order no:-SO/01. Delievery  note no :-Devy/01.

  11.Sold OLOPAT KT Eye Drop to Jain medical against delivery note no:- Devy/01. Sales invoice no :- S/01.

 12.Received cheque from Jain medical against Sales invoice no:-S/01.

13.Return 5ct. Rejection OLOPAT KT Eye Drop to Jain medical . Rejection in No:- Reject In/01.

14.Create a credit (issue) note to Jain medical against rejection in Voucher no:- Reject .In/01. Credit note no:- Cdt/01.

15.Paid to Jain medical against credit note :-cdt/01.(cheque).