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



Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format

 

Output:

After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report 



SKU

 Product SKU.

Product

 The name of the product.

Order #

 Sale Order Number identifying the sale.

Order Date

 Sale Order date.

Invoice #

 Invoice Number identifying sale invoice.

Invoice Date

 Invoice issue date.

Credit Note Date

 Credit Note issue date.

Shipment Date

 Date of the shipment.

Customer

 Customer name.

Sales Representative

 Name of sales representative associated with the sale.

Quantity

 Quantity of the product sold (by invoice - credit note restock).

Weight

 Weight of the product Quantity.
Invoice
 Invoice Line Total - Credit Note Line Total including tax in base currency. Will include "Invoice Line Total" only when Invoice Date is within specified From - To date range

Sale

 Invoice Line Total - Credit Note Line Total excluding tax in base currency. Will include "Invoice Line Total" only when Invoice Date is within specified From - To date range

Tax

 Invoice Line Tax - Credit Note Tax in base currency. Will include "Invoice Line Tax" only when Invoice Date is within specified From - To date range

COGS

 Cost of Goods Sold in base currency = Invoice COGS - Credit Note COGS. Will include Invoice COGS only when Max Ship date from Ship tab is within specified From - To date range. Will include -Credit Note COGS only when Credit Note date is within 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

 Product unit of measure.

Category

 Product category.

Brand

 Product brand.

Product Tags

 Comma-separated product tags.

Family

 Product family name.

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

 Values of product additional attributes.

Customer Additional Attribute 1-10

 Values of customer additional attributes.