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.
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 Product Brand
/report/purchaseperproductbrand