This report shows detailed financial and quantity-related information about each sale credit note.



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.

Invoice #

 Invoice Number identifying sale invoice.

Credit Note #

 Credit Note Number identifying sale credit note.

Credit Note Date

 Credit Note issue date.

Invoice Date

 Invoice issue date.

Customer

 Customer name.

Location

 Name of the location from where goods were picked/dispatched.

Quantity

 Quantity of the product credited.

Credited

 Credit Note Line Total including tax in base currency.

Sale

 Credit Note Line Total excluding tax in base currency.

Discount

 Average Discount applied to credit note line.

COGS

 Cost of Goods Sold in base currency = Credit Note COGS.

Invoice Due Date

 Invoice due date.

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.

Country

 Shipment address country.

State

 Shipment address state.

City

 Shipment address city.

Postcode

 Shipment address postcode.

Sales Representative

 Name of sales representative associated with the sale.

Customer Reference

 Customer Reference associated with the sale.