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.
The input fields/buttons on the report and their descriptions are listed in the table below.
|From||Start date of report|
|To||Closing/end date of report|
|Update||Refreshes the report|
|Apply Filter||Sets filter on the report fields|
|Export||Exports report data to Excel, PDF or RTF|
The output fields on the report and their descriptions are listed in the table below.
|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|
|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|
|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|