Sales by Division, Service Staff, and Product

Questions It Answers

Which services and products did each staff member deliver, and for how much?
What is a staff member's commission base this period?
Who is the most productive staff member in each division?

Filters

Filter	What it does
Transaction Date	Date range of the sales. 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.
Product Code	One product only - handy for tracing the history of a single item.
Service Staff	One service staff member; pre-filled from the role default when set.
Customer	One customer only. A role locked to a specific customer gets it pre-filled and read-only.
Sales Representative	One sales rep only; pre-filled from the role's default when set.
Serial Number	Match a serial number exactly (=) or partially (like). Only meaningful when the company uses serial numbers.

How To Read It

Nested result: Division > Service Staff > product rows. Unlike the sales rep, service staff is recorded per line - one invoice can be split across several staff.

Column	Meaning
Quantity, Unit	Quantity sold in the unit written on the invoice - not converted to the base unit, so 1 box and 12 pcs show as two rows.
Gross	Price x quantity before line discount.
Discount	Discount per product line. Invoice-level discount (at the foot of the invoice) is not here.
Net	Gross - Discount.
Tax, Extra Tax	Line VAT, and any extra tax (e.g. restaurant tax) computed per product.
Subtotal	Net + Tax + Extra Tax.
Profit, Profit Margin	Shown only to roles allowed to see purchase prices. Profit = Gross - Discount - tax included in the price - COGS at the time of sale. Profit Margin = Profit / (Gross - tax included in the price) x 100%.
Serial Number, Expiration Date	Shown only when the company uses product serial numbers/expiry; otherwise the columns are absent.

Source: Sales invoices and POS cashier receipts that are approved (when the approval workflow is on). Returns are not deducted here - see the Sales Return reports.

Why The Numbers May Differ

Invoice lines without service staff are grouped under a blank staff member; fill the Service Staff column on the invoice for them to show here.
Service-staff commission rules read the same data, but the commission itself is in the commission report - this report is sales value only.
POS cashier receipts are included here. Sales Summary and Sales Trend read Sales invoices only, so their totals are lower than this report whenever there are cashier sales.
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 Sales Summary.
Profit and Profit Margin disappear from the table when the user's role may not see purchase prices - not because the data is empty.

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

Sales & POS / Sales Reports / Sales by Division, Service Staff, and Product
/report/salesdivservicedoerprod