Sales Order by Division, Invoice, and Product
Product detail of every Sales Order, grouped by division. The SO version of "Sales by Division, Invoice, and Product" - for seeing what was ordered, not what was delivered.
Questions It Answers
- Which products were ordered most this period?
- What order value came in per division?
- Which SOs contain orders for a given product?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Date range of the orders. Empty means the whole history - slow on years of data, so always fill it. |
| Division | Pre-filled from the user role's default division. A role locked to one division cannot change it. |
| Department | Limits to one department (warehouse/outlet) inside the division; pre-filled from the role default when set. |
| Product Code | One product only - handy for tracing the history of a single item. |
How To Read It
Nested result: Division > SO (number, customer, rep, date, total) > product rows with Quantity, Unit, Gross, Discount, Net, Tax, Extra Tax, Subtotal.
Unlike the Sales Order report, there is no Received column and no Invoiced toggle here: every SO in the period is listed, open or already invoiced.
Why The Numbers May Differ
- SO value is not sales value: cancelled or never-shipped orders still count here. For sales that actually happened, use the Sales reports.
- The Product Code and Department filters limit product lines, not the SO; the SO still shows with only the matching lines.
Menu Location
- Sales & POS / Sales Reports / Sales Order by Division, Invoice, and Product
/report/salesorderdivtransprod