Customer Product Detail Report

Lists line by line every product sold to each customer in a date range, with quantity, unit, original price, discounts, price and amount.

Menu: Reports › Partner Reports › Customer Product Detail Report

Required permission

Reports › Customer Product Detail Report › View

What it's for

Use it to answer "what exactly did this customer buy, and at what price?", for example for a dispute, a rebate calculation or a customer's own reconciliation.

Example

A customer disputes the price of Detergent 1 kg on a May invoice. The report shows O. Price 98.00, Discount 1 5%, Price 93.10 on sheet SO…0412, as agreed.

Filters

Click Filters to narrow the report. You can filter by:

Transaction Date, Customer, Walk-in Customer.

Columns

Column	What it shows
Customer	The customer.
Transaction Date	The transaction's date.
Product Name	The product name.
Sheet No.	The transaction's sheet number; click it to open the transaction.
Qty	Quantity on the line.
UOM	The unit of measure used on the line.
Unit Specs	The unit used on the line and how many default units it holds.
Total Qty	Total quantity, in default units.
O. Price	Original price: the price before the line's discounts.
Price	Price per unit on the transaction line, after line discounts.
Discount 1	First discount on the line, in %.
Discount 2	Second discount on the line, in %, applied after the first.
Discount 3	Third discount on the line, in %.
Discount 4	Fourth discount on the line, in %.
Disc/Adj	Discount or adjustment type used on the line.
Amount	Line amount: quantity × price.

Also shows: Chinese Name, Description, Stock No., Barcode.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.