Sales By Product Details Report

This report shows quantities, profit and additional financial summary if sales by product.


NOTE: Products with Type = Service, Gift Cards, or Non-Inventory are not included in this report.


Inputs


The input fields/buttons on the report and their descriptions are listed in the table below.


Field/ButtonDescription
FromStart date of report
ToClosing/end date of report
UpdateRefreshes the report
Apply FilterSets filter on the report fields
ExportExports report data to Excel, PDF or RTF


Outputs


The output fields on the report and their descriptions are listed in the table below


Column Name
Description
SKU
Product SKU
Product
Product name
Order #
Sale Order number
Order Date
Sale Order date
Invoice #
Invoice number
Credit Note Date
Credit note issue date
Shipment Date
Date of the shipment
Customer
Customer name
Sales Representative
Name of the Sales Representative associated with the sale
Quantity
Quantity sold (by Invoice-credit note restock)
Weight
Weight of the sold quantity
Invoice
Invoice Line Total - Credit Note Line Total, including tax in base currency. Invoice Line Total is only included when the Invoice Date is within the specified From - To date range.
Sale
 Invoice Line Total-Credit Note Line Total, excluding tax in base currency. Invoice Line Total is only included when the Invoice Date is within the specified From - To date range.
Tax
Invoice Line Tax-Credit Note Tax in base currency. Invoice Line Tax is only included when the Invoice Date is within the specified From - To date range.
COGS
Cost of Goods Sold in base currency=Invoice COGS-Credit Note COGS. Invoice COGS is only included when Max Ship date under Ship tab is within the specified From-To date range.
-Credit Note COGS is only included when Credit Note date is within the specified From - To date range.
Journals
Total of all Additional Transactions associated with the sale in base currency distributed by invoice lines using Total amount
Profit
Profit = Invoice-COGS-Tax. In base currency.
Customer Tags
Comma-separated customer tags.
Unit
Unit of measure of the product
Category
Product category
Brand
Product brand
Product Tags
Comma-separated product tags
Family
Name of Product Family
Invoice Status
 Status of the Invoice in sale
Shipment Status
Shipment status in Sale
Country
Shipment address country
State
Shipment address state
City
 Shipment address city
Postcode
Shipment address postcode
Shipping Address 1
Shipment address line 1
Product Additional Attribute 1-10
Additional attributes of the product
Customer Additional Attribute 1-10
Additional attributes of the customer


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.