Purchases by Product Brand
Purchases per product grouped by brand. For seeing how much is spent on each brand - the basis for principal rebate claims and brand review.
Questions It Answers
- What was the total spend on brand X this period, for a rebate claim?
- Which brand has the largest purchase value?
- Which products within a brand 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. |
| Brand | One brand from the Product Brand master. |
How To Read It
Nested result: Brand > 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.
- Products without a brand in the master belong to no brand and are not shown.
- 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 Brand
/report/purchaseperproductbrand