Sales Order Outstandings

Sales Order Summary statement gives detailed information on outstanding sales orders. The outstanding orders can be viewed Stock Group wise, Stock Category wise, Stock Item wise, account Group wise,  Ledger wise or All Orders.  

To view Sales Order Outstandings:

Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings

A menu bar has been provided to make the navigation easier, as shown:

Sales Order - Stock Group

This report displays the Sales Order Outstandings summary of all or a selected Stock Group.

To view Sales Order Stock Group Outstandings summary:

Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Stock Group

Drilling down from a selected Stock Group displays the Sales Order Outstanding of Stock Items.

Sales Order - Stock Item

This report displays the Sales Order Outstandings summary of a selected Stock Item.

To view Sales Order Stock Item Outstandings summary:

Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Stock Item

Drilling down from a selected Stock Item displays the order detail screen which provides information on 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.

The Order Details screen appears as shown:

Sales Order - Group

This report displays the Sales Order Outstanding summary of a selected Group.

To view Sales Order Group Outstandings summary:

Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Group

Sales Order - Ledger

This report displays the Sales Order Outstanding summary of a selected Ledger.

To view Sales Order Ledger Outstandings summary:

Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > Ledger

The Sales Order Stock Group Outstandings, Sales Order Stock Category Outstandings, Sales Order Stock Item Outstandings, Sales Order Group Outstandings and Sales Order Ledger Outstandings screens can be configured using the F12: Configure button, as shown:

Show Opening Orders

By default this option is set to No. If set to Yes - Tally.ERP 9 displays the opening orders for the given period.

Show Orders Booked

By default this option is set to No. If set to Yes - Tally.ERP 9 displays the orders books during the during the selected period.

Show Cleared Orders

By default this option is set to No. If set to Yes - Tally.ERP 9 displays the orders which have been cleared during the selected period.

Show Pending Orders

By default this option is set to Yes. Tally.ERP 9 displays the orders which are pending for the given period.

The Sales Order Stock Outstandings report of a selected Item with the options Show Opening Orders, Show Orders Booked, Show Cleared Orders and Show Pending Orders enabled, for a given period appears as shown:

Sales Order - All Orders

This report displays the Sales Order Outstanding of all the orders which are pending. 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.

To view All Orders:

Go to Gateway of Tally > Display > Statements of Inventory > Sales Order Outstandings > All Orders

The Order Details screen appears as shown:

Note: This button toggles between All Orders and Due Only.

The Order Details screen can be configured using the F12: Configure button.

Pre-Closure of Orders

Displaying the Pre-Closed order in Order Details screen

Go to Gateway of Tally > Display > Statement of Inventory > Sales Order Outstandings > All Orders

To view the pre-closed quantity and reason for pre-close, press F12: Configure button and set the following options to Yes:

Show Pre-Closure order details - On enabling this options, an additional column - Pre-Closed Qty (Closed on) will be displayed. In this column, the details of pre-closed quantity with the date gets captured.

Show Reason - On enabling this option, the reason entered in the Reason for Pre-Close field gets displayed in this report.

Show Pre-Closed orders only - On enabling this option, only the orders which are pre-closed will be displayed.

The Order Details screen displays as shown:

Selection of Orders to be Pre-Closed using Pre-close Button

After recording a sales order, the same can be closed from Order Details screen. In the Order Details screen, select the required order (press space bar to select) which need to be pre-closed. Click on Pre-Close button to view the report in edit mode.

Enter the quantity in Pre-Close Quantity column and accept the screen.

Using Pre-Close Button to Pre-Close all Orders as Fully Cancelled

In the Order Details screen, click on Pre-Close button.

In the editable screen, click on Set All Quantity button (Alt+S). The balance quantity will be displayed under pre-close quantity column. Accept or modify the quantity and accept the screen.

Ageing Analysis Report

Now user can analyse the Order Details report Ageing wise, based on Bill date or Due date.

Select F6: Age wise from the button bar in the Order Details screen.

Select either the option Ageing by Bill Date or Ageing by Due Date for Methods of Ageing.

Set the age periods required for the report.

Age-wise Analysis report will be displayed as shown.

Note: You will get the option for Sales Order Outstandings only if you have activated the option Enable sales order processing under Order Processing in F11: Inventory Features.