Purchases by Division, Invoice, and Product

Product detail of every purchase invoice, invoice by invoice. The most complete report for matching purchases to the supplier's paper 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.
Supplier	One supplier only; pre-filled from the role's default when set.
Buyer	The employee recorded as buyer on the invoice header; pre-filled from the role's default employee when set.
Serial Number	Match a serial number exactly (=) or partially (like). Only meaningful when the company uses serial numbers.

Nested result: Division > Invoice (number, supplier, buyer, date, invoice total) > product rows. Invoices are ordered by date and time.

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.

The invoice total in the header is the final amount (after invoice discount and expenses); the sum of its line Subtotals can differ because the invoice discount isn't spread across lines.
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 bought in boxes and in pieces shows as separate rows with their own quantities.
Values here are invoice purchase prices, not inventory COGS; COGS can differ because of purchase expenses charged to stock and the costing method.

Procurement / Purchase Reports / Purchases by Division, Invoice, and Product
/report/purchasedivtransprod