# Order Wise Sale
Lists sales linked to each sale order with financial totals, customer details, and outstanding balances.
Overview
Go to Sales → Order Reports → Order Wise Sale.
Report title in ERP: Order Wise Sale
What it shows. One row per sale linked to a sale order, including order number, dates, in-charge employee, customer, and full financial breakdown.
When to use it. Use to track how much has been invoiced against each order, identify orders with pending balances, and monitor sales activity.
How amounts are calculated. Includes approved sale invoices linked to sale orders within the selected date range.
Use Cases
- Order fulfillment review — Compare billed amounts and balances against open sale orders.
- Customer order tracking — Filter by customer to see all order-linked sales and outstanding balances.
- Employee accountability — Filter by in-charge to review sales processed by each employee.
- Audit trail — Export to verify that invoices match approved sale orders.
Filters
Date Range, Order No., Customer, InCharge. Advanced Filter: Branch, Center, Payment Mode, Customer Group.
Columns
| **Column** | **Description** |
|------------|-----------------|
| # | Serial number. |
| Date | Sale invoice date. |
| Order No. | Sale order number linked to the sale. |
| Due Date | Expected delivery or fulfillment date. |
| InCharge | Employee responsible. |
| Customer | Customer on the order. |
| Tax Reg.No | Customer tax registration number. |
| Amount | Sale amount before discount and tax. |
| Discount | Total discount applied. |
| Taxable Amount | Amount subject to tax. |
| Tax Amount | Tax amount. |
| Sub Total | Subtotal before rounding. |
| Bill Total | Final bill total. |
| Balance | Remaining balance on the order. |
Actions
- Generate — run the report for the selected filters
- Export / Export All — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active filters
- View Details — open the sale invoice linked to the order
FAQ
Why does an order show a balance?
A balance appears when invoiced amount is less than the order total, or partial billing leaves an outstanding amount.
Can I see sales for a single order?
Yes. Use the Order No. filter.
Does this include sale returns?
It focuses on sale invoices linked to orders. Use return reports for return analysis.
How is bill total different from sub total?
Sub total is pre-rounding; bill total is the final payable amount after rounding.
Does this show invoice status?
Order header view — open Delivered Not Invoiced for billing backlog.
Can I filter partial delivered?
Use status or advanced filters on the report screen for open pipeline review.