What you'll do: list every sale line (or purchase line) of a product, with quantity, price, discount and tax.
Before you start:
- Your role needs View purchase & sell report.
- Filters, print and export work as in How reports work.
Open Reports & Analytics → Reports → Product Sell Report.
Press Filter (Filter Sales): Search by product name or SKU, All Locations, All Customers, All Customer Groups, All Categories, All Brands and the date range.
1 Filter · 2 Qty · 3 Subtotal Read the report:
- Product, SKU, Customer, Contact ID, Invoice No. and Date;
- Qty, Unit Price, Discount, Tax, Price (Inc. Tax), Subtotal and Payment Method;
- if you sell modifiers (extras), tick Include modifiers to show them as Modifier lines.
Use Export CSV, Export Excel (XLSX) or Print above the table (Current Page Only or All Records). See How reports work.
Product purchase report
Section titled “Product purchase report”Open Reports & Analytics → Reports → Product Purchase Report. Press Filter (Filter Purchases) for All Locations, All Suppliers, All Brands and the date range. Each row shows the Product, Ref. No., Supplier, Purchase Qty, Qty Adjusted, Unit Price, Subtotal and Date.