# Item Wise Sale Orders

Aggregates sale order activity by item — total ordered quantity, amount, and average unit price for item-level order analysis. Select rows to create Purchase Orders, Purchase Invoices, Material Requests, or a Production Plan.

On this page

Overview Use Cases Filters Columns Actions FAQ

Overview

Go to Sales → Order Reports → Item Wise Sale Orders. Report title in ERP: Item Wise Sale Orders

What it shows. One row per item with total quantity ordered across sale orders, unit of measure, total amount, and average unit amount.

When to use it. Use to identify high-volume ordered items, compare average prices across periods, support inventory planning, and create follow-on documents (purchase, material request, or production plan) from selected items.

How amounts are calculated. Aggregates approved sale order lines within the selected date range and filters.

Use Cases

Demand planning — See which items have the highest order volumes for stock preparation.
Price benchmarking — Compare average unit amounts across date ranges.
Category review — Filter by item group or brand to analyze ordering patterns.
Fulfillment priority — Identify items with large pending order quantities.
Production planning — Select ordered items and create a Production Plan with quantities and BOMs pre-filled.

Filters

Date Range, Status, Employee, Item Type, Show / Hide Value. Advanced Filter: Customer, Customer Group, Center, Form Type, State, Zone, Branch, Item Group, Route, Brand.

Columns

| **Column** | **Description** | |------------|-----------------| | Item | Item name or description. Click to open order-wise detail for that item. | | Item Code | Unique code or SKU. | | Quantity | Total quantity ordered. | | Unit | Measurement unit. | | Amount | Total order amount for the item. | | Avg Unit Amt | Average price per unit (Amount ÷ Quantity). |

Actions

Generate — run the report for the selected filters
Export — export to Excel
Print — print the report
Advanced Filter — open additional filter fields
clear — reset active filters

Select one or more rows to show the selection action bar:

Create Purchase Order — opens a new Purchase Order with the selected items and quantities
Create Purchase Invoice — opens a new Purchase Invoice with the selected items and quantities
Create Material Request — opens a new Material Request (inventory transfer) with the selected items and quantities
Create Production Plan — opens a new Production Plan with selected producible items, quantities, and each item's default active BOM pre-filled

Note: Create Production Plan skips items that are not producible. If none of the selected items are producible, a warning is shown.

FAQ

How is average unit amount calculated?
Total amount divided by total quantity for the selected filters.

Does this include delivered orders?
Use the Status filter (for example Delivered / Not Delivered) to control which orders are included.

Are cancelled orders included?
Use the Status filter. Cancelled can be selected explicitly; the default view excludes cancelled orders.

Can I see which customers ordered an item?
Apply the customer filter or use Order Wise Item Orders for line detail.

Are draft orders included?
Typically only approved (and related active) orders in the date range. Confirm status filter on the report screen.

How is this different from Order Wise Item Orders?
Order Wise Item Orders shows lines per order. This report aggregates quantity by item across orders.

How do I create a Production Plan from this report?
Select the items → Create Production Plan. The plan opens with plan name, start date, item lines, quantities, and default BOMs filled. Complete center and end date, then save.

What BOM is used when creating a Production Plan?
The first active BOM for each item is applied automatically. Change it on the plan form if the item has more than one BOM.

Order Wise Item Orders
Sale Order
Production Plan

Overview

Use Cases

Filters

Columns

Actions

FAQ

Related