Purchases by Division, Department, and Product
Purchases per product by the department (warehouse or outlet) that received the goods. For matching stock-ins at each warehouse to invoices.
Questions It Answers
- What value of goods came into warehouse A from purchases this month?
- Which products were bought directly for a given outlet?
- Does the warehouse stock-in match the purchase invoice lines?
Filters
| Filter | What it does |
|---|---|
| Transaction Date | Date range of the purchase invoices. 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 > product rows. The department is read from the invoice line (where stock came in), not the header.
| Column | Meaning |
|---|---|
| Quantity, Unit | Quantity bought in the unit written on the invoice - not converted to the base unit, so 1 box and 12 pcs show as two rows. |
| Gross | Purchase price x quantity before line discount. |
| Discount | Supplier's discount per product line. Invoice-level discount (at the foot of the invoice) is not here. |
| Net | Gross - Discount. |
| Tax, Extra Tax | Line input VAT, and any extra 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 Purchase invoices (when the approval workflow is on). Purchase returns are not deducted here - see the Purchase Return reports.
Why The Numbers May Differ
- One invoice can be split across departments when its lines go to different warehouses - same total, different grouping.
- The Department filter limits product lines, not the invoice.
- Documents still waiting for approval are not counted. If the approval workflow is on and the figures look low, check the Approval Queue.
- Invoice-level discount (at the foot of the invoice) does not reduce the per-product figures here, so the Subtotal total can exceed the invoice totals in Purchase Summary.
- Quantities are not converted between units: a product bought in boxes and in pieces shows as separate rows with their own quantities.
- Purchase returns are not deducted. For net purchases, subtract the Purchase Return report with the same grouping.
Purchase Price Permission
Columns derived from COGS or purchase prices - COGS, inventory value, purchase prices and totals, and profit - appear only for roles that have the Show Purchase Price History permission in User Roles. For other roles those columns are absent from the screen, prints, and exports, and the server does not send the figures at all - they are not merely hidden by the layout.
- A missing column does not mean the data is empty. If the user should see it, turn the permission on for their role and ask them to log in again so the report layout follows.
- Custom-built reports are not protected automatically; a copy made with Duplicate in Report Designer keeps the settings of the original.
Menu Location
- Procurement / Purchase Reports / Purchases by Division, Department, and Product
/report/purchasedivdeptprod