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

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.

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.

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.

Procurement / Purchase Reports / Purchases by Division, Department, and Product
/report/purchasedivdeptprod