# Order Wise Item Orders
Line-level detail of every item on sale orders — ordered, delivered, and balance quantities, rates, taxes, and fulfillment status per order.
Overview
Go to Sales → Order Reports → Order Wise Item Orders.
Report title in ERP: Order Wise Item Orders
What it shows. Each row is one item line on a sale order, with order date, customer, order number, item attributes, ordered quantity, delivered quantity, balance quantity, rate, tax, total, and line status. Turn on Show Description to add the line description entered on the sale order item.
When to use it. Use to audit item-level order commitments, check pending or partially delivered lines, and analyze orders by item group or brand.
How quantities are calculated. Order Qty is the quantity on the sale order line. Delivered Qty is the net quantity delivered against that order item (delivery notes minus returns), including service completion notes for service items. Balance Qty is Order Qty minus Delivered Qty.
Use Cases
- Line-level fulfillment — Compare Order Qty, Delivered Qty, and Balance Qty to find lines still pending or partially delivered before customer follow-up.
- HSN and tax review — Verify HSN codes and tax amounts on ordered items.
- Brand or category analysis — Filter by item group or brand to review ordered value by segment.
- Rate verification — Compare ordered rates against customer pricing agreements before invoicing.
Filters
- Date Range — Limit order dates to a specific period.
- Employee — Limit to orders for a selected employee.
- Order Status — Filter by fulfillment status. Status filters apply at item line level using delivered and balance quantities, not only the order header status:
- Delivered — lines with Delivered Qty greater than zero
- Partial Delivered — lines that are partially delivered (some delivered, balance remaining)
- Returned — lines with returned quantity
- Approved — lines not yet delivered
- Not Cancelled / Cancelled / Status-All — include or exclude cancelled orders as selected
- Not Purchased — lines not yet linked to a purchase order (shows stock columns when inventory access is enabled)
- Advanced Filter — Customer, item, item group, route, branch, center, sale type, and related fields.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Order Date | Date of the sale order. |
| Party | Customer on the order. |
| Order No. | Sale order number. |
| Due Date | Expected delivery date. |
| Item | Ordered item name. |
| Description | Line description from the sale order item (shown when Show Description is on). |
| HSN | HSN code. |
| Item Group | Item category. |
| Order Qty | Quantity ordered. |
| Delivered Qty | Net quantity delivered against the order item (delivery notes minus returns). |
| Balance Qty | Order Qty minus Delivered Qty. |
| Unit | Unit of measure. |
| Stock Qty | Current stock quantity (shown when status is Not Purchased and inventory access is enabled). |
| Stock Unit | Stock unit of measure (shown when status is Not Purchased and inventory access is enabled). |
| Rate | Price per unit (shown when Show Value is on). |
| Taxable Value | Taxable amount for the line (shown when Show Value is on). |
| Tax Amount | Tax on the line (shown when Show Value is on). |
| Total | Line total including tax (shown when Show Value is on). |
| Status | Fulfillment status (Approved, Delivered, Partial Delivered, Returned, Cancelled, Closed, etc.). |
Rows use the same status colors as lists elsewhere in FreeSpace: cancelled and void statuses in red, draft in grey, and pending / multi-level approval in orange/warning.
Actions
- Generate — run the report for the selected filters
- Show Value / Hide Value — toggle rate, taxable value, tax amount, and total columns
- Show Description / Hide Description — toggle the line description column
- Export — export the current report view to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active filters
FAQ
How is this different from Order Wise Sale?
Order Wise Sale summarizes at invoice level. This report shows every item line on each order.
How are Delivered Qty and Balance Qty calculated?
Delivered Qty is net delivery quantity for the order item (from delivery notes, reduced by returns, plus service completion notes for service items). Balance Qty is Order Qty minus Delivered Qty.
Why does a Partially Delivered order not show every item when I filter Delivered?
Status filters apply per item line. Under Delivered, only lines with Delivered Qty greater than zero appear. Undelivered sibling lines on the same order are excluded.
What does Partial Delivered mean?
The line has some delivered quantity and a remaining balance (Delivered Qty > 0 and Balance Qty > 0).
Can I filter to one order number?
Use Order No. in Advanced Filter.
Are cancelled order lines included?
Only lines matching your active filters and order status appear. Use the Cancelled status filter to include them. Cancelled rows are shown in red.
Can I see pending quantities?
Yes. Use the Balance Qty column on this report. For delivery-note-level detail, use Order Wise Item Wise Delivery.
How do I see the item description entered on the order line?
Turn on Show Description to add the description column for each order item line.