Purchase & Sales Order Processing in Tally Prime
Complete Study Material, Examples, Practical Exercises & Viva Questions
Table of Contents
- Purpose of Order Processing
- Enabling Order Processing
- Creating Sales Orders
- Creating Purchase Orders
- Converting Orders into Invoices
- Reports for Order Tracking
- Complete Order Processing Workflow
- Worked Example
- Sales Order vs Purchase Order
- Practice Questions
- Practical Assignment
- Viva Questions
- Quick Revision
1. Purpose of Order Processing
Order processing is the process of recording, tracking and fulfilling customer orders and supplier orders. It helps an organization know what has been ordered, what has been delivered or received, and what quantity is still pending.
| Document | Meaning | Issued By | Purpose |
|---|---|---|---|
| Sales Order | Request/order received for goods or services | Customer | Records what the customer wants to purchase |
| Purchase Order | Order placed for purchasing goods or services | Buyer | Records what the business wants to purchase |
| Delivery Note | Records goods delivered | Seller | Tracks goods delivered against a Sales Order |
| Receipt Note | Records goods received | Buyer | Tracks goods received against a Purchase Order |
Why is Order Processing Important?
- Tracks pending customer orders.
- Tracks pending purchase orders.
- Helps monitor delivery and receipt status.
- Reduces the possibility of missed orders.
- Helps plan inventory requirements.
- Provides information for outstanding reports.
- Creates a systematic flow from order to invoice.
2. Enabling Order Processing
Before entering Sales Orders or Purchase Orders, the relevant order processing features must be enabled in the company.
Steps
3. Creating Sales Orders
A Sales Order records the goods or services that a customer has ordered. It is useful for tracking what needs to be delivered and by when.
Navigation
Shortcut: Alt + F5
Steps to Create a Sales Order
- Select the Customer Ledger.
- Enter the Order Number.
- Enter the Order Date.
- Select the required Stock Item.
- Enter the Quantity.
- Enter the Rate.
- Enter applicable GST/tax details, where relevant.
- Enter delivery-related details if required.
- Accept and save the voucher.
Customer: ABC Traders
Product A: 100 units @ ₹50
Order Value: 100 × ₹50 = ₹5,000
The Sales Order records the customer’s requirement. It does not by itself mean that all 100 units have been delivered.
4. Creating Purchase Orders
A Purchase Order records the goods or services that a business intends to purchase from a supplier.
Navigation
Shortcut: Alt + F4
Steps to Create a Purchase Order
- Select the Supplier Ledger.
- Enter the Order Number.
- Enter the Order Date.
- Select the required Stock Item.
- Enter the Quantity.
- Enter the Rate.
- Enter applicable GST/tax details, where relevant.
- Enter expected receipt/delivery details if required.
- Accept and save the voucher.
Supplier: XYZ Suppliers
Raw Material X: 200 units @ ₹40
Purchase Order Value: 200 × ₹40 = ₹8,000
The Purchase Order shows what the business has ordered from the supplier. The goods are considered received only when the appropriate receipt transaction is recorded.
5. Converting Orders into Invoices
Orders can be followed by inventory documents and finally by invoices. This allows the business to track the entire transaction.
Sales Process
| Stage | Purpose |
|---|---|
| Sales Order | Records what the customer ordered. |
| Delivery Note | Records what has actually been delivered. |
| Sales Invoice | Records the sale and amount to be collected. |
Purchase Process
| Stage | Purpose |
|---|---|
| Purchase Order | Records what the business ordered from the supplier. |
| Receipt Note | Records what goods have actually been received. |
| Purchase Invoice | Records the purchase and amount payable to the supplier. |
6. Reports for Order Tracking
Outstanding reports help identify orders that have not been fully fulfilled.
Sales Order Outstanding
Purchase Order Outstanding
Information Commonly Tracked
| Information | Purpose |
|---|---|
| Order Number | Identifies the order |
| Party Name | Identifies customer or supplier |
| Item | Identifies the ordered stock item |
| Ordered Quantity | Shows the original order quantity |
| Pending Quantity | Shows the quantity still outstanding |
| Due Date | Helps monitor expected fulfillment |
7. Complete Order Processing Workflow
Sales Order Workflow
Purchase Order Workflow
Order = What was requested?
Delivery/Receipt = What actually moved?
Invoice = What was financially recorded?
Outstanding = What is still pending?
8. Worked Example – Sales Order
Step 1 – Sales Order
A customer orders 100 units at ₹50 per unit.
Step 2 – Delivery Note
The business delivers only 60 units.
Step 3 – Sales Invoice
A Sales Invoice is raised for the quantity actually being invoiced, according to the transaction and configuration.
| Particular | Quantity | Rate | Value |
|---|---|---|---|
| Product A | 60 | ₹50 | ₹3,000 |
| Pending | 40 | ₹50 | ₹2,000 |
The order still has 40 units pending.
Step 4 – Remaining Delivery
If the remaining 40 units are delivered later:
9. Sales Order vs Purchase Order
| Basis | Sales Order | Purchase Order |
|---|---|---|
| Purpose | Records customer order | Records supplier order |
| Party | Customer | Supplier |
| Goods Movement | Goods are delivered | Goods are received |
| Next Document | Delivery Note | Receipt Note |
| Final Invoice | Sales Invoice | Purchase Invoice |
| Outstanding Report | Sales Order Outstanding | Purchase Order Outstanding |
10. Practice Questions
Question 1 – Sales Order
- 50 units of Product A @ ₹200
- 30 units of Product B @ ₹150
- Create the Sales Order.
- Calculate the total order value.
- Identify the initial outstanding quantities.
Question 2 – Partial Delivery
- 30 units of Product A
- 20 units of Product B
Product B: 30 − 20 = 10 units
Total Pending: 30 units
Question 3 – Purchase Order
- 200 units of Raw Material X @ ₹75
- Create the Purchase Order.
- Calculate the order value.
- Identify the initial outstanding quantity.
Initial Outstanding: 200 units
Question 4 – Partial Receipt
Task: Calculate the pending quantity and pending value.
Pending Value: 80 × ₹75 = ₹6,000
Question 5 – Complete Fulfillment
Task: What quantity will remain outstanding?
Question 6 – Multiple Orders
- Order 101: 100 units of Item A
- Order 102: 150 units of Item B
- Order 103: 200 units of Item C
- Order 101: 70 units
- Order 102: 100 units
- Order 103: 200 units
- Order 101 → 30 units pending
- Order 102 → 50 units pending
- Order 103 → 0 units pending
Question 7 – Due Date Tracking
Task:
- Calculate the pending quantity.
- Calculate the pending value if the rate is ₹100 per unit.
- Explain why the due date is important in order tracking.
Pending Value: 80 × ₹100 = ₹8,000
Question 8 – Mixed Order Processing
- Sales Order for 100 units.
- Delivery Note for 60 units.
- Sales Invoice for the delivered quantity.
- Delivery Note for the remaining quantity.
- Complete the Sales Order.
- Check the Sales Order Outstanding Report.
11. Practical Assignment
Company: ABC Traders
Complete the following complete Order Processing cycle in Tally Prime.
Part A – Sales Order
| Item | Quantity | Rate |
|---|---|---|
| Product A | 100 | ₹250 |
| Product B | 50 | ₹400 |
- Create the customer ledger.
- Create the required stock items.
- Enter the Sales Order.
- Record a Delivery Note for 60 units of Product A and 30 units of Product B.
- Check Sales Order Outstanding.
- Deliver the remaining quantities.
- Generate the Sales Invoice.
- Verify that no order quantity remains outstanding.
Part B – Purchase Order
| Item | Quantity | Rate |
|---|---|---|
| Raw Material X | 200 | ₹80 |
| Raw Material Y | 100 | ₹120 |
- Create the supplier ledger.
- Create the stock items.
- Enter the Purchase Order.
- Record a Receipt Note for 150 units of Raw Material X and 60 units of Raw Material Y.
- Check Purchase Order Outstanding.
- Receive the remaining quantities.
- Generate the Purchase Invoice.
- Verify the final outstanding quantity.
- Ordered Quantity
- Delivered/Received Quantity
- Pending Quantity
- Invoice Quantity
- Final Outstanding Quantity
12. Viva Questions
13. Quick Revision Chart
| Document | Question It Answers | Follow-Up |
|---|---|---|
| Sales Order | What did the customer order? | Delivery Note |
| Delivery Note | What did we deliver? | Sales Invoice |
| Sales Invoice | What did we bill the customer? | Payment |
| Purchase Order | What did we order from the supplier? | Receipt Note |
| Receipt Note | What did we receive? | Purchase Invoice |
| Purchase Invoice | What did the supplier bill us? | Payment |
| Outstanding Report | What quantity is still pending? | Further fulfillment |
Remember the Golden Formula
Order = 100 units
Delivered = 60 units
Outstanding = 100 − 60 = 40 units
Remaining 40 units delivered later:
Outstanding = 100 − 100 = 0 units
14. Conclusion
Purchase and Sales Order Processing in Tally Prime provides a systematic method for managing customer orders and supplier commitments. By linking orders with delivery or receipt documents and subsequently with invoices, businesses can monitor the complete transaction cycle.
The most important concept for students to remember is that an Outstanding Report shows the unfulfilled portion of an order.