TALLY TUTORIAL
 
Advanced Inventory
In
the first volume, you learnt some basic inventory operations.
You learnt to record movement of goods - goods in and goods out.
There are many other aspects to stocks
that are being taken up now.
Order
Processing
In
Tally, order processing is linked to inventories.
You can track the order position of a stock item, know what goods
that were ordered have arrived, whether you have fulfilled the orders on
time and what is the delay, if any.
In
this module, you learn how to record purchase orders, and to call the
orders while
entering a purchase invoice and likewise with sales orders and sales
invoices.
You
will also learn how to display outstanding orders position and the effect
of
orders on stocks.
Remember,
orders do not affect financial records nor do they update inventories.
Activate
Sales and Purchase Order Processing in F11: Company Features.
-
Activate
Tracking numbers in F11: Company Features, if it is not already
activated. In this unit, you will use Not Applicable for Tracking
Numbers. We will take up entries using Tracking numbers in the next
unit.
-
Create
a stock item Bricks with unit of measure Pcs. This is tradeable item
as well as to be used for construction. Stock will be maintained.
Hence, Treat all Purchases as Consumed should be set to No.
-
Create
a Supplier - Universal Bricks with bill-wise activated and no interest
calculation.
Purchase
Order Processing
Purchase
Order details will also depend on configuration settings.
Hence, have a look at the configuration and voucher types.
Activate Accounting allocations in Order Entry.
Enter
a Purchase Order
1.
Return to Gateway of Tally.
2. Select Voucher Entry->F9:
Purchase ->Select Purchase Order
3. Voucher date: 15/12/98.
Party's A/c Name: Universal Bricks
4. Order No: The voucher number will
be your Purchase Order number. This
particular Order No. field is an additional field to record order number
if different from the voucher number.
5. Name of the item: Bricks. (Once
the name is given the Item Allocations subscreen pops-up that needs to
be filled in.)
6. Due on: 25/12/98 - The due date
for delivery of the item. This
will enable monitoring of outstanding deliveries.
The order can be split for delivery on different dates.
7. Location: Warehouse. (in case
multiple location feature is active, this field is required to be given,
else it does not appear.)
8. Quantity, Rate and Amount - 5000
Pcs @ 3 per Pc. The amount is
calculated but is modifiable to enable rounding off.
Item
allocation sub-screen:
-
Next
Item: Since no other item is required, press [Enter] on the blank
field to take the cursor to the tax/expense field.
-
Expense/Tax:
Once the item details have been entered, you might specify tax to be
charged and other expenses like freight, if any.
The tax or expense has to exist as a ledger account or it may
be created using [alt]+[C]. Select
Freight @3% on the item values.
-
Narration:
Optional.
Alter
a Purchase Order
You
can alter a Purchase Order by displaying it from a variety of places but
is easier through the Purchase Orders Book or the Day Book.
Gateway
of Tally ->Display -> Day Book or Gateway of Tally, Inventory Books,
Purchase Order Book.
Sales
Order Processing :--
Create
Sales Orders
Sales
order entry is exactly like Purchase Orders.
Sales
Order details will also depend on configuration settings.
Hence, have a look at the configuration and voucher types.
1.
Gateway of Tally->Voucher Entry ->F8:Sales ->Select Sales Order
2. Voucher date: 16/12/98.
Party's A/c Name: Wimbledon Properties
3. Order No: The voucher number will
be your internal serial number. This
particular Order No. field is for the customer's order number
which is different from the voucher number.
Enter WP/5.
4. Name of the item: Bricks.
5. Due on: 26/12/98.The due date for
delivery of the item. This
will enable monitoring of outstanding deliveries.
The order can be split for delivery on different dates.
6. Location: Warehouse.
7. Quantity, Rate and Amount - 4000
Pcs @ 5 per Pc.
8. Next Item: Since no other item is
required, press [Enter] on the blank field to take the cursor to the
tax/expense field.
9. Expense/Tax: Once the item
details have been entered, you might specify tax to be charged and other
expenses like freight, if any.
The tax or expense has to exist as a ledger account or it may be
created using [alt]+[C]. Select
or create Tax @ 17.5% to
be charged on the item values.
Alter
a Sales Order
You
can alter a Sales Order by displaying it from a variety of places but is
easier through the Sales Orders Book or the Day Book.
Gateway
of Tally->Display-> Day Book or Display, Inventory Books, Sales
Order Book.
View
Order position
Stock
summary is perhaps the best place to view the order position.
Gateway
of Tally -> Stock Summary ->Detailed [F1]
Currently,
all you see is the closing balances or stock in hand as on the last day of
the period. However, you do
not know how much stock is on order both inward and outward. if you knew
that, you could take plan your stocks better and not lose out on
orders.
1.
Press the Orders button [alt]+[F7]
2. Select Sales Orders Outstanding
3. Type No for Due orders only.
You are now in Sales Order Outstanding screen showing On Order items.
Of course, you have only Bricks on order
4. Select the line Bricks and press Enter.
The outstanding Sales order for Bricks is detailed.
5. Select F12:Configuration.
6.
Select Yes to all options.
You
now see your Order Analysis with Sales and Purchase Orders outstanding
position for the stock item Bricks.
1.
Return to the Stock Summary screen
2. Select Detailed
3. Press [alt]+[n] Auto-Column
Button.
4. Select Orders & Stock
Details.
5. Remove Rate and item from display by configuring it using F12.
This will enable all columns to fit in one screen.
Take note of the change in figures.
Can you accept an order for 2000 bricks ?
6. You may
further drill down into each column to view greater detail.
In the Stock
Summary screen, you can even bring up a new column using [alt]+[C] the New
Column button and get more options for detail.
Experiment with Types of Values to get familiar with them.
They are powerful and give great business information.
Adjust
Orders
You
adjust orders at the time of raising delivery notes and invoices.
1.
Select Voucher Entry
2. Select Purchase -> Purchase
3. Enter a Purchase invoice no UB/6
4. Voucher date: 25/12/98.
Party's A/c Name: Universal Bricks
5. Name of the item: Bricks. (Once
the name is given the Item Allocations subscreen pops-up that needs to
be filled in.)
6. Tracking number : Not Applicable
as goods are accompanying the bill.
7. Order No: Select the order
number.
8. All fields are filled up.
9. Now enter as you would normally
in a Purchase voucher. Quantity,
Rate and Amount - 5000 Pcs @ 3 per Pc.
10. Expense/Tax: Freight @3% on the
item values.
|
