Sales Return by Division, Department, and Product
Returned goods per product by the department (warehouse/outlet) that took them back. For reconciling return stock-ins at each warehouse.
Questions It Answers
- Which warehouse receives the most returns, and of which products?
- What return value came into a given outlet this month?
- Does the return stock-in at the warehouse match the return notes?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Date range of the returns. 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. |
| Serial Number | Match a serial number exactly (=) or partially (like). Only meaningful when the company uses serial numbers. |
How To Read It
Nested result: Division > Department > returned product rows. No Profit column - returns have no profit.
| Column | Meaning |
|---|---|
| Quantity, Unit | Quantity returned, in the unit written on the return note. |
| Gross | Price x quantity before line discount. |
| Discount | Discount per product line. Invoice-level discount (at the foot of the invoice) is not here. |
| Net | Gross - Discount. |
| Tax, Extra Tax | Line VAT, and any extra tax (e.g. restaurant tax) computed per product. |
| Subtotal | Net + Tax + Extra Tax. |
| Serial Number, Expiration Date | Shown only when the company uses product serial numbers/expiry; otherwise the columns are absent. |
Source: approved Sales Return notes (when the approval workflow is on). Figures are positive; subtract them from the sales reports yourself for net sales.
Why The Numbers May Differ
- The department comes from the return line (where stock came back), so one return note can be split across departments.
- The Department filter limits product lines, not notes: a note with some lines in another department still shows, with the matching lines only.
- Documents still waiting for approval are not counted. If the approval workflow is on and the figures look low, check the Approval Queue.
- Quantities are not converted between units: a product sold in boxes and in pieces shows as separate rows with their own quantities.
Menu Location
- Sales & POS / Sales Reports / Sales Return by Division, Department, and Product
/report/salesreturndivdeptprod