AISLAMIENTO Y CARACTERIZACIÓN DE SOBREVIENTES

Reorder Level signifies the quantity of a Stock Item in hand, after reaching which you must place orders for your supplies. The

importance of Reorder Level arises from the desire to have sufficient stocks to service customer orders and, at the same time, not to unnecessarily accumulate stock.

Therefore, the points to be considered while deciding the reorder levels are as follows.

o The lead-time for suppliers to deliver the stock.

o The delivery time specified by the customer.

o The stock-in-hand to satisfy orders in the meantime.

In simple mode, Tally accepts the quantities that you specify. In

advanced mode, it considers the past consumption patterns to suggest reorder levels. You can however, choose to define your own reorder levels. You may also specify the minimum quantity of the item to be ordered, either in simple or advanced mode.

The purpose of specifying reorder levels is to obtain a report that indicates the quantity of a Stock Item that you must order.

Specifying Reorder Levels

Go to Gateway of Tally > Inventory Info > Reorder Levels

Select a group of Stock Items from the List of Groups, to specify Reorder Levels for the

Stock Items in the Specify Reorder Levels screen.

For each item in stock, you can define a Reorder Level and the Minimum Order Quantity. If

you click Simple Reorder button, the consumption alternatives will not be available and

hence you have to input the quantities.

Note: The option Reorder Levels is displayed in the Inventory Info. menu only if Allow

Purchase Order Processing is enabled in F11: Features.

The Reorder level screen appears as follows:

The options that you have while defining Reorder Level and Minimum Order Quantity for

individual stock items are as follows.

Reorder Level/Quantity

Enter the level/quantity in this field.

Advance Parameter for Reorder Level (Consumption for the Last) This field lets Tally calculate the reorder level/order quantity based on the total consumption in the past for a chosen period.

Period

The choices for periods are: Days, Weeks, Months and Years. Note that it is not the average

consumption for the period but the total consumption. Enter zero (0), if you do not want

Tally to calculate the reorder level based on the consumption of the item in the past.

Criteria

Choose whether you want the higher/lower of the two, i.e., input/calculated level/quantity.

Rounding Method

Specify whether the calculated level/quantity must be rounded and also the method of

rounding.

Minimum order quantity

You can specify the minimum order quantity required.

Tracking Number

You were buying and selling goods or services where the stock would be affected

when making the purchase or sales entry. Many businesses deliver stock with a

delivery note or a challan. The bill is raised later. The bill has to be linked or tracked with the goods already delivered. In Tally, tracking numbers do the job.

Tracking numbers allow Goods Receipt and Goods Delivery Notes for goods not

accompanied by an invoice to be linked with the invoice that is raised later.

Of

course, Tally permits the opposite too. A bill can be raised first and the goods delivered. Again, tracking numbers do the trick.

Tally walk-through for using tracking numbers 1. Go to voucher entry.

2. Select Purchase, Receipt Note.

3. Enter the following transaction:

4. On 12/12/98 - Ref GRN/UB - 1000 Pcs of Bricks received from Universal Bricks @2 per Pc.

5. For Bricks, select Tracking Number GRN/UB and give item details.

6. Press Enter on the blank Tracking number to return to the main voucher.

7. Accept the voucher and Return to Gateway of Tally

8. Select 'Display', 'Statements of Inventory', and then 'Purchase Bills Pending'.

Purchase Bills Pending screen:

1. Tally tracks down the Goods received but whose bills have not been received.

2. View the Profit & Loss Account and the Purchase Accounts.

3. Tally provides the purchase so that the profits are correctly arrived at.

4. View the Balance Sheet, Sundry Creditors. Has Tally provided for the liability?

5.

Tracking numbers - track bills with goods delivered Now go back to Voucher Entry

1. On 15/12/08, you receive the purchase bill no UB/15 from Universal Bricks for their Delivery Note no GRN/UB for 1000 Pcs of Bricks @ 2 per Pc. You get

30 days credit.

2. Select Purchase, Purchase Ref: UB/15

Cr Universal Bricks 2000 Billwise UB/15 30 days 2000 Dr Project Purchase 2000 3. Inventory Allocation

• Tracking Number: Select GRN/UB. Note UB/15 is also listed there. Do not select this.

• Accept the other information that is filled up. Press Enter on the blank Tracking number to return to the main voucher.

4. Cost Centre is activated for Project Purchase. Select Projects and Assignments Category and Buildings Cost centre.

5. Accept the voucher.

6. Now go back to Purchase Bills Pending. Is there anything pending?

Exercise No: 22

a)

1.4.2008 Received Capital By Cash Rs.5,00,000 1.4.2008 Cash Deposited in SBI Rs.2,00,000

5.4.2008 Purchase Order Made to Rahul Textiles [P.O.N0.101]

5.4.2009 Due 12.4

Cotton Sarees 50 nos at Rs.300 Chudithar 50 nos at Rs.400

7.4.2008 Purchase Order Made to Kiran Textiles [P.O.N0.102]

Due 15.4

Cotton Sarees 75 nos at Rs.300 Chudithar 60 nos at Rs.400

10.4.2008 Purchase Order Made to Sona Textiles [P.O.N0.103]

Due 25.4

T-Shirts 100 nos at Rs.100 Jeans 100 nos at Rs.1000

10.4.2008 Purchase invoice raised for the Order 102 [Bill No.1234]

12.4.2008 Received Materials For the Purchase Order From Sona Textiles [P.O.N0.103] [RN.NO 567]

15-4-2008 Returned T-Shirts 10 nos, Jeans 5 nos [RN.NO.567]

20-4-2008 Purchase invoice raised for Sona Textiles [Bill No.5678]

18-4-2008 Sales Order Received From Arjun Stores [SO.NO.111]

Due Date 25/4

Cotton Sarees 60 nos 500 Chudithar 40 nos 750

22.4.2008 Sales Order Received From Brinkley Garments [SO.NO.118] Due Date 30/4

T-Shirts 60 nos 150 Jeans 60 nos 1300

27.4.2008 Sales Invoice Raised For Sales Order NO 111 [Arjun Stores] + TNGST 4%

29.4.2008 Delivery Note Given For Brinkley Garments For Sales Order No.118 [DN.NO.556]

1-5-2008 Returns From Brinkley Garments T-Shirts 10 nos

Jeans 5 nos

5.5.2008 Sales Invoice Raised For The Delivery Note 556

b)

Kiran Electricals Started Business of Electrical items 1.8.2002 Received Cash For Capital Rs.8,00,000/-1.8.2002 Deposited in UCO Bank

Rs.3,00,000/-7.8.2002 Purchase Order Made to Nithya Fan House [NO.124] [Due Date 14/8]

Ceiling Fan 500 nos @ Rs.1500 Table Fan 500 nos @ Rs.1200

10.8.2002 Purchase Order Made to Athi Electricals [NO.111] [Due Date 18/8]

Ceiling Fan 150 nos @ Rs.1500 Table Fan 150 nos @ Rs.1200

14.8.2002 Purchase Invoice Raised For Order NO.124

19.8.2002 Received Materials For the Purchase Order NO.111 through Receipt

Note NO.12

20.8.2002 Returned 10 nos of the Ceiling Fan & 5 nos of Table Fan For the Order

NO.124

22.8.2002 Sales Order Received From Akshai Traders [NO.2,Due Date 1/9]

Ceiling Fan 300 nos @ Rs.2000 Table Fan 300 nos @ Rs.1500

1-9-2002 Raised Sales Invoice For the Order NO.2 with Sales Tax @ 4%

2.9.2002 Sales Order Received From ABI Traders [3.Due Date 10/9]

Ceiling Fan 200 nos Table Fan 200 nos

10-9-2002 Delivery Note Raised For the Order NO.3 12.9.2002 Returned 5 nos of Ceiling Fan.Table Fan 14-9-2002 Sales Invoice raised For the Order NO.3