Purchase Order Processing in TallyPrime 4

Order Processing in TallyPrime can be classified into ..

1. Purchase Order Processing
2. Sales Order Processing and

In TallyPrime, Order Processing is linked to Inventory. This allows tracking of the order position for a Stock Item. Using this you can track the arrival of goods ordered and whether the ordered Stock Item are delivered on time etc.

In this lesson, you will learn the method of recording and linking purchase orders to purchase invoice and sales orders to sales invoices. You will also learn how to display outstanding orders and the effect of orders on stocks.

1. Purchase Order (Ctrl+F9) Processing in TallyPrime-3

When the order is placed with the suppliers for the supply of goods, the items, quantities, date of receipt, and so on, details are given with the Purchase Order Number. Later, when these goods are received, the Purchase Order is tracked for the Order Details either in the Receipt Note or in the Purchase Invoice.

The Outstanding Purchase Order reports are available in TallyPrime. It is possible to know the order position of any item in the Stock Summary. Separate Purchase Order Outstanding report and Purchase Order Summary report are also available.

Example:

Raise a Purchase Order on 1-4-2023 on ACER India Ltd. (vide Order No. 1)  for the following items  with GST as applicable. The due date is 1-5-2023 and additional Delivery Charges on Purchase of Rs.500  is applicable before GST.

Laptop ACER 4720Z                             1 Nos.              32500

Laptop Compaq A901TU                     1 Nos.              38500

Laptop HCL Mileap                             1 Nos.              35000

Solutions:

1. Open the Purchase Order Voucher screen

Gateway of Tally > Vouchers > F10 (Other Vouchers) > Select Show Inactive and Press Enter > type or select Purchase Order (Ctrl+F9).

In case the voucher is inactive, you will be prompted to activate the Purchase Order voucher type. Select Yes or press Y to proceed.

Enter the Purchase Order Voucher like Purchase Voucher as screen appears as shown below:

[13-1-Purchase Order Processing in TallyPrime-3]

Note :

Order No: 1 This particular Order No. field is an additional field to record the order number if different from the voucher number.

Due on: 1-5-2023 (It is the due date for the delivery of the item. This will enable the monitoring of outstanding deliveries. The order can be split for delivery on different dates). Multiple Godown is get enabled by default and you can select your Godown.

[13-2-Purchase Order Processing in TallyPrime-3]

1.1. Receipt Note Voucher (GRN) (Alt+F9) against Purchase Order

A Receipt Note voucher is used to record receipt of goods/items at stores. For example , the Company receives new stock item from a Supplier. If a Purchase Order exists for that supply, selecting the PO reference in the Receipt Note will display its particulars.

The details recorded in the Receipt Note are the PO reference, Ledger account, Supplier’s name and address, Name of stock item, Stock location, quantity, rate, amount and the transaction narration.

The Receipt Note is similar to the Goods Receipt Note (GRN) type of entry. When the Receipt Note is passed it updates the inventory levels.

Purchase includes Accounting and Inventory.

In Tally when a Receipt Note is tagged to a Purchase entry the whole transaction is completed.

Example :

In the earlier section, we have recorded Purchase Order No-1 on 1-4-2023 with due date 1-5-2023 with following products from ACER India Ltd. All the given Products as per Purchase Order is received on 01-5-2023.

Laptop ACER 4720Z                             1 Nos.              32500

Laptop Compaq A901TU                     1 Nos.              38500

Laptop HCL Mileap                             1 Nos.              35000

Let us raise a Receipt Note for the PO/1 raised on 1-4-2023 with due date 1-5-2023.

Solutions:

1. Gateway of Tally> Vouchers > press F10 (Other Vouchers) > type or select Receipt Note or Press ALT+F9.

Alternatively, Alt+G (Go To) > Create Voucher > press F10 (Other Vouchers) > type or select Receipt Note.

In case the voucher is inactive, you will be prompted to activate the voucher type. Select Yes or press Y to proceed.

[13-3-Purchase Order Processing in TallyPrime-3]

2. Enter the Reference No if required and Date.
3. Select Party A/c Name from the List of Ledger Accounts against which you are recording the receipt note.
4. Select Order No(s) from the List of Orders , if a purchase order exists for that supplier. If the Order No(s)is selected, the item name, quantity, rate and amount will be displayed automatically.

[13-4-Purchase Order Processing in TallyPrime-3]

The Party Details screen appears as shown:

[13-5-Purchase Order Processing in TallyPrime-3]

5. Enter the required information in the Party Details screen.
6. Press F12 (Configuration) and set the options Provide Separate Buyer and Consignee details, Mailing Name, Pincode, GST Registration Details, Place of Supply etc… to Yes to provide the supplier details.

[13-6-Purchase Order Processing in TallyPrime-3]

If you need to use this option only for the current voucher, press Ctrl+I (More Details) > type or select Order details> and press Enter.

7. Press Enter . The Stock Item Allocations screen appears as shown:

[13-7-Purchase Order Processing in TallyPrime-3]

8. Select existing Tracking No. or create a new tracking number.

Note: A Receipt Note with Tracking No. marked as Not Applicable will be an inventory document, affecting only the inventory values. This will not affect the accounts. A purchase voucher with Tracking No. marked as Not Applicable will update the accounts without increasing the stock. The Purchase Bills Pending list is generated as Bills recd. but Goods not recd.

9. Select the items and include the item details like quantity, rate, and any specific location

The Receipt Note appear as shown below:

[13-8-Purchase Order Processing in TallyPrime-3]

10. Press Enter to save.

1.2. Purchase Voucher (F9) against Receipt Note Voucher (GRN)

In Tally when a Receipt Note is tagged to a Purchase entry the whole transaction is completed.

• If Receipt Note is accounted but the Purchase entry is not, it is treated as Goods Received but Bills are not received.
• If the Purchase entry is accounted and the Receipt Note is not, it is treated as Bills Received but Goods are not received.
• One Purchase entry can be tagged to many Receipt Notes. Similarly, one Receipt Note can be tagged to many Purchase bills. It is not necessary for all Receipt Notes to be tagged with Purchase entries and vice versa.
• When the stock received is a part of purchase and we wish to keep track of the purchase bill for accounting, a Tracking No. is assigned while accounting the Receipt Note. The Tracking No. is selected while accounting the Purchase bill/invoice. Similarly, we can assign a Tracking No in the Purchase voucher and  select it while accounting the Receipt  Note.
• A Receipt Note or Purchase Entry can be prepared first. It is not compulsory that a Receipt Note should be prepared before accounting the Purchase Entry or the Purchase entry should be accounted before preparing a Receipt Note.

Example :

In the earlier section, we have recorded Receipt Note Voucher No-1 on 1-5-2023 on the basis of Purchase Order No-1 (recorded earlier) with following products from ACER India Ltd.

Laptop ACER 4720Z                             1 Nos.              32500

Laptop Compaq A901TU                     1 Nos.              38500

Laptop HCL Mileap                             1 Nos.              35000

Let us record a Purchase Bill for the Receipt Note No.- 1 received & entered on 1-5-2023.

Solutions:

1. Gateway of Tally > Vouchers > press F9 (Purchase).

Alternatively, press Alt+G (Go To) > Create Voucher > press F9 (Purchase).

4. Select Party A/c Name from the List of Ledger Accounts .
5. Select Receipt Note No. from the List of Tracking Numbers , if a Receipt Note exists for that supplier.

The Receipt Details screen appears as shown:

[13-9-Purchase Order Processing in TallyPrime-3]

6. Enter the required information in the Receipt Details screen.
7. Select the Receipt Note No(s) . If the Receipt Note No(s) is selected, the item name, quantity, rate and amount will be displayed automatically.
8. Press Enter . The Stock Item Allocations screen appears as shown:

[13-10-Purchase Order Processing in TallyPrime-3]

9. Select existing Tracking No. or create a new tracking number.

The Purchase Voucher appear as shown below:

[13-11-Purchase Order Processing in TallyPrime-3]

10. Press Enter to save.

1.3. Purchase Order Outstanding

In some business cases, after you record a purchase order, the supply might get partially or completely cancelled. Also, you may want to keep a track of the purchase orders outstanding and account for the partially or completely cancelled orders. TallyPrime provides you with the Purchase Order Outstanding report to view all such outstanding orders. You can also pre-close the outstanding orders and cancelled orders at any point in time.

There are different reports under Purchase Order Outstandings. The outstanding orders can be viewed Stock Group-wise, Stock Item-wise, Group-wise, Ledger-wise, or from All Orders.

• Press Alt+G (Go To) > type or select any of the Purchase Order Reports.

Alternatively, Gateway of Tally > Display More Reports > Statements of Inventory > Purchase Order Outstandings > choose the report to view

[13-12-Purchase Order Processing in TallyPrime-3]

1.3.1. Purchase Order – Stock Group

This report displays the Purchase Order Outstanding summary of all or a selected Stock Group.

1. Press Alt+G (Go To) > type or select Stock Group Purchase Order Outstanding.

Alternatively, Gateway of Tally > Display More Reports > Statements of Inventory > Purchase Order Outstandings > Stock Group > select Primary or the required Stock Group.

If you want to know how to record a Purchase Order, then click here.

2. Drill down from any stock item to view the Purchase Orders Outstanding of the stock item in the Order Details screen.

[13-13-Purchase Order Processing in TallyPrime-3]

It displays the Date of the order, Order Number, Name of Party, Ordered Quantity, Balance Quantity, Rate, Value of the ordered stock, Due on date for delivering the goods, and the number of days overdue.

You can press F12 (Configure) and set the options as needed, to view the details of the required orders for each account group.

1.3.2. Purchase Order – Stock Item

This report displays the Purchase Order Outstanding summary of Stock Items.

1. Press Alt+G (Go To) > type or select Stock Item Purchase Order Outstanding.

Alternatively, Gateway of Tally > Display More Reports > Statements of Inventory > Purchase Order Outstandings > Stock Item.

2. Select the stock item from the List of Stock Items and press Enter.
3. Drill down from the stock item to view the Purchase Orders Outstanding of the stock item in the Order Details screen.

[13-14-Purchase Order Processing in TallyPrime-3]

It displays the Date of the order, Order Number, Name of Party, Ordered Quantity, Balance Quantity, Rate, Value of the ordered stock, Due on date for delivering the goods, and the number of days overdue.

You can press F12 (Configure) and set the options as needed, to view the details of the required orders for each stock item.

1.3.3. Purchase Order – Group

You may have created subgroups for your Sundry Creditors based on the region, type of party, city, location, or for each salesman, as per your business need. You can use this report to view the Purchase Order Outstanding for such groups.

1. Press Alt+G (Go To) > type or select Group Purchase Order Outstanding.

Alternatively, Gateway of Tally > Display More Reports > Statements of Inventory > Purchase Order Outstandings > Group.

2. Select Sundry Creditors and press Enter.
3. Drill down from the stock item to view the Purchase Orders Outstanding of the stock item in the Order Details screen.

[13-15-Purchase Order Processing in TallyPrime-3]

It displays the Date of the order, Order Number, Name of Party, Ordered Quantity, Balance Quantity, Rate, Value of the ordered stock, Due on date for delivering the goods, and the number of days overdue.

You can press F12 (Configure) and set the options as needed, to view the details of the required orders for each stock item.

1.3.4. Purchase Order – Ledger

This report displays the Purchase Order Outstanding summary of ledgers.

1. Press Alt+G (Go To) > type or select Ledger Purchase Order Outstanding.

Alternatively, Gateway of Tally > Display More Reports > Statements of Inventory > Purchase Order Outstandings > Ledger.

2. Select the Ledger and press Enter.

[13-16-Purchase Order Processing in TallyPrime-3]

Press F12 (Configure) and set the below options to get a comparison of the number of Orders Booked, Orders Cleared, Pending Orders, and also Opening Orders, if any.

1. Show Opening Orders to Yes.
2. Show Orders Booked to Yes.
3. Show Cleared Orders to Yes.
4. Show Pending Orders to Yes.

[13-17-Purchase Order Processing in TallyPrime-3]

[13-18-Purchase Order Processing in TallyPrime-3]

You can also set other options as needed from F12 (Configure), to view the required order details for each ledger.

Drill down from the stock item to view the Purchase Orders Outstanding of the stock item in the Order Details screen.