Purchases by Product Group
Purchases per product grouped by product group (category). For seeing which categories absorb most of the buying budget.
Questions It Answers
- Which category has the largest purchase value this month?
- How much was spent on category X versus last month?
- Which products within a category are bought most often?
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. |
| Product Group | One group from the Product Group master. |
How To Read It
Nested result: Product Group > product rows with Quantity, Unit, Gross, Discount, Net, Tax, Extra Tax, Subtotal (= Net + taxes). No COGS or profit columns - these are purchases.
Why The Numbers May Differ
- Counts every Purchase invoice in the period, including those still awaiting approval when the workflow is on - unlike the "by Division" reports, which count approved documents only.
- A product whose group is changed in the master moves its whole history to the new group - the report reads today's group.
- Purchase returns are not deducted. For net purchases, subtract the Purchase Return report with the same grouping.
- Quantities are not converted between units: a product bought in boxes and in pieces shows as separate rows with their own quantities.
Menu Location
- Procurement / Purchase Reports / Purchases by Product Group
/report/purchaseperproductgroup