In your business, if you are following the process of raising a sales order for each sales transaction, you can do the same in Tally.ERP 9. You can record a sales order, raise a delivery note and link it to this order, and then link them to the sales invoice. You can use the reports to track the outstanding sales orders. You can generate and print a sales order as quotation, and it will not affect your books of accounts. You can also pre-close the orders, if needed.
On this page
● Record Delivery Note Against Sales Order
● Record Partial Cancellation of Goods
● Reports | Know Your Sales Orders
When you receive an order from a customer, you may need to provide the details of items, quantities, date of delivery, and so on, with a Sales Order Number. When these goods are delivered, this sales order number will be used to track the order details either in the delivery note or in the sales invoice.
1. Enable sales order processing.
a. Press F11 (Features) > F2 (Inventory).
b. Set the option Enable sales order processing to Yes .
2. Open the sales order voucher screen.
a. Gateway of Tally > Inventory Vouchers > Alt + F5 (Sales Order).
b. Press Alt + I and select the invoice mode as per your business needs.
3. Specify the buyer details.
a. Party A/c Name : Select the party name.
b. Party Details : Provide the Despatch , Order , and Buyer details as per your invoice requirements.
If you do not see the Party Details screen, press F12 (Configure), and set Enable supplementary details to Yes .
As always, you can press Ctrl + A to save and proceed.
4. Enter the sales Order no. for the voucher.
If you want to enter an order number for each item, press F12 (Configure) > set Use Order No. for every Item to Yes . The Order no. field will appear in the Stock Items Allocation screen. It will not appear on the main screen of the invoice.
5. Select the Sales ledger to allocate the stock items.
6. Provide the stock item details.
As in other transactions, you can create the item on the fly by pressing Alt + C .
a. Select the stock item.
b. Enter the Due on date and Quantity . The Rate will be auto-filled, if available for the stock item. However, you may choose to enter the Rate . The Amount appears automatically.
c. If orders are split with different due dates, specify the appropriate due date for each lot to be sold.
Note: In F11 (Features) > F2 (Inventory), you can enable the feature of godown/location and batches to provide these details in the Stock Item Allocations screen.
d. After entering the due dates for all the lots, press Enter on the Due on field to return to the Voucher Creation screen.
7. Select additional ledgers, like transportation charges, insurance, or discount, if any.
8. Provide Narration , if needed, and accept the screen. As always, you can press Ctrl + A to save.
Click here to see the possible F12 configurations for Sales Order.
9. To print the sales order, press Alt + P (Print) and press Enter .
The following is a sample preview screen of the sales order.
The sales order details will be printed in the invoice.
In your business, you may be following a process of raising sales order first and then recording a sales invoice without any delivery challan. In Tally.ERP 9, you can record transactions in the same order. If you want to raise a delivery note at any point in time, you can do it by linking it to a sales order, and then to a sales invoice.
1. Open a sales invoice and enable supplementary details.
a. Gateway of Tally > Accounting Vouchers > F8 (Sales).
b. Press F12 (Configure) > set Enable Supplementary Details to Yes .
Henceforth, you can enter the supplementary details in the sales voucher, until you change the option in (Configure).
2. Select the order number and record the invoice.
a. In the Party Details screen, select the order number.
The details from the sales order will be listed in the sales voucher.
b. Make the required changes in the items/quantities, if required.
c. Save the sales invoice. As always, you can press Ctrl+A to save.
The sales order will get closed, if completely billed. Otherwise, it will be partially closed, and the details can be viewed in the Sales Order Outstandings report.
In your business, you may be following a process of raising a sales order first, then recording a delivery note, and then a sales invoice against the delivery note. In Tally.ERP 9, you can record transactions in the same order. You can also link all the three invoices.
Here is an example of recording a delivery note against a sales order.
1. Enable the delivery note feature.
● Press F11 (Features) > F2 (Inventory) > set Use tracking numbers (enables delivery and receipt notes) to Yes .
2. Enable supplementary details screen for delivery note.
a. Gateway of Tally > Inventory Vouchers > Alt+ F8 (Delivery Note).
b. Press F12 (Configure) > ensure the option Enable Supplementary Details is set to Yes .
Henceforth, you can enter the supplementary details in the delivery note, until you change the option in (Configure).
3. Select the party ledger, sales order details, and record the transaction.
a. In the Party Details screen, select the order number.
b. The details from the sales order will be displayed in the delivery note.
c. Select an existing Tracking No. or create a new Tracking No. .
d. Make the required changes in the items/quantities, if required.
e. Save the delivery note. As always, you can press Ctrl+A to save.
Note: A Delivery Note with Tracking No. marked as Not Applicable will be an inventory document, affecting only the inventory values. This will not affect the accounts. Click here for more details on delivery note.
The sales order will get closed, if completely delivered. Otherwise, it will be partially closed, and the details can be viewed in the Sales Order Outstandings report .
Orders can be pre-closed when goods are delivered or received. This can be recorded in a delivery note or receipt note.
1. Open a delivery note voucher and select the party details.
a. Gateway of Tally > Inventory Vouchers > press Alt+F8 (Delivery Note).
a. Press F12 (Configure) > set the option Use Pre-Closure order details to Yes .
Henceforth, you can enter the details of pre-closure of orders in delivery note, until you change the option in (Configure).
b. Select Party A/c Name .
2. Select the sales order details.
a. Press F12 (Configure) > ensure the option Enable Supplementary Details is set to Yes .
b. Select Order No(s) from the List of Orders .
3. Record the delivery note with details of partial cancellation of order.
a. Select the stock item. The Stock Item Allocations screen appears.
b. Select the Tracking Number . The stock item, quantity and rate will appear automatically as the sales order number has been selected.
c. Select the Godown .
d. Enter the Quantity delivered, the Pre-Close Quantity and the Reason for Pre-Close .
e. Accept the Stock Item Allocations screen.
f. Accept the voucher. As always, you can press Ctrl+A to save.
The sales order is cleared as the required quantity of stock items are delivered after pre-closing the partially cancelled order.
If you want to generate a quotation, in Tally.ERP 9, you can mark the sales order as optional, and print it.
1. In the sales order, press Ctrl+L (Optional) > record the invoice > and save the transaction.
2. Press Alt+P (Print). The title appears as QUOTATION.
You can print the quotation for each sales order by marking it as optional voucher.
You may have to close orders that have negligible quantities left, or you are not planning to supply those pending items to the customers. Pending references of such orders will continue to exist in Tally.ERP 9 until you close them. You can pre-close an order either from Sales Order Outstanding reports or from the transactions, sales order, delivery note, or sales.
1. Open the sales order voucher screen in alteration mode and configure it for pre-closure of order.
a. Gateway of Tally > Display > Day Book > select the Sales Order voucher > press Enter .
b. Press F12 (Configure) > set the option Use pre-closure order details to Yes .
2. In the Stock Item Allocations screen, enter the Pre-Close Quantity and the Reason for Pre-Close .
Based on your convenience, you can pre-close the orders from the sales order voucher or delivery note or sales voucher.
You may want to know the sales orders outstandings, and account for the partially or completely cancelled orders. You can use the reports of Sales Orders Outstandings and Pre-closure of orders report and pre-close the cancelled orders at any point in time. There are different reports that show the sales orders outstanding. The outstanding orders can be viewed Stock Group-wise, Stock Category-wise, Stock Item-wise, account Group-wise, ledger-wise or from All Orders.
● Gateway of Tally > Display > Statement of Inventory > Sales Order Outstandings > choose the report to view.
In this section
● Ageing Analysis Report for Sales Orders
● Pre-close orders from reports
This report displays the Sales Order Outstandings summary of all or a selected Stock Group .
1. Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Stock Group > select Primary or the required Stock Group .
2. Drill down from a Stock Group to view the Sales Order Outstandings of stock items.
Click here to see the possible F12 configurations for Stock Groups, Stock Items, Account Groups and Ledgers, to view the required details
You can view the details of the required orders for each stock group.
This report displays the Sales Order Outstandings summary of stock items.
1. Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Stock Item .
2. Select the stock item.
3. Drill down from a stock item to view the order detail screen. It displays the order number, date of order, party, quantity, undelivered order, rate, value of ordered stock, due 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.
You may have created sub groups for your sundry debtors based on region, type of party, city, location, or for each salesman, as per your business need. You can use this report to view the order outstanding for that group.
1. Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Group .
2. Select the Group .
3. Select the stock item and press Enter to view the Order Details .
You can press F12 (Configure) and set the options as needed , to view the details of the required orders for each account group.
This report displays the Sales Order Outstanding summary of ledgers.
1. Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Ledger .
2. Select a Ledger .
3. Select the stock item to view the Order Details .
4. Press F12 (Configure) and set the options as needed.
You can press F12 (Configure) and set the options as needed , to view the details of the required orders for each ledger.
This report displays the Sales Order Outstanding of all the pending orders. It provides information on the order number, date of order, party, ordered Quantity, undelivered order, rate, value of ordered stock, due date for delivering the goods and the number of days overdue. It also provides information on goods delivered but orders not received.
1. Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > All Orders .
● Press Alt+F1 (Detailed) to view the Sales Order details.
● Press F7 (Due Only) to view only the orders that are due. This button can be used to view All Orders and Due only orders .
● Press Alt+F6 (Age-wise) to view the age-wise analysis report.
● Press Ctrl+C (Pre-Close) to pre-close the sales order.
● Press F12 (Configure) and set the options as needed.
Click here to see the possible F12 configuration options for Sales Order - All Orders report.
You can view the required information of All Orders of Sales Orders Outstandings .
You can analyse the Order Details report based on Bill date or Due date.
1. Press Alt+F6 in the Order Details screen.
2. Select the option Ageing by Bill Date or Ageing by Due Date for Methods of Ageing .
3. Set the age periods required for the report. Age-wise Analysis report will be displayed as shown below:
Click here to see the possible F12 configuration options for Ageing Analysis report.
Based on your reporting requirements, you can set the ageing anaysis as needed.
This report displays all the sales orders for each month. You can view this report in browser .
1. View and configure Sales Orders Book .
a. Gateway of Tally > Display > Inventory Books > Sales Orders Book .
b. Press F12 (Configure), and set the options as needed.
2. View estimated profits/losses and monthly summary of Sales Orders Book monthly summary.
a. Press F7 (Show/Hide Profit) to view the report with estimated gross profit/loss.
b. Press Alt+N (Auto Column) and select the options in the Auto Repeat Columns sub-screen.
The Sales Orders Book appears as shown below:
Click here to see the possible F12 configuration options for Sales Orders Book.
You can view the required information related to sales orders from the Sales Orders Book .
You can pre-close the orders from the Order Details report of Sales Order Outstandings .
1. Gateway of Tally > Display > Statement of Inventory > Sales Order Outstandings > All Orders .
2. Press F12 (Configure).
a. Set the option Show Pre-Closure order details to Yes .
b. Set the option Show Reason to Yes .
Note: If you set the option Show Pre-Closed orders only to Yes , only the pre-closed orders will appear in the report.
The Order Details screen appears with Pre-Closed Qty (Closed on) column and Reason for Pre-Close field.
Pre-close order - partial cancellation of orders
1. Select the sales orders (press Spacebar to select more than one order), and press Ctrl+C (Pre-Close).
2. Enter the Pre-Close Quantity , and the Reason for Pre-Close .
Pre-close order - complete cancellation of orders
1. Press Ctrl+C (Pre-Close) > press Alt+S (Set All Quantity).
2. The balance quantity will be displayed under pre-close quantity column. Accept or modify the quantity and press Ctrl+A to accept.
