The report shows detailed financial and quantity-related information about each sale credit note. Use this report to see how many credit notes are being raised for your products and which customers are raising them.
Data from this report can be exported in Excel, PDF or RTF format.
|Time Period||Allows the user to select the time period from a list of options or set a custom date range.|
|Show COGS||Choose whether COGS are calculated from COGS with the selected time period only or all COGS on the record.|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving a layout for potential future use.|
|Reset Layout||Resets the layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|Product||Name of the product|
|Invoice #||Invoice Number identifying the sale invoice|
|Credit Note #||Credit Note number|
|Invoice Date||Date the invoice was issued|
|Invoice Due Date||Date the payment is due for the invoice|
|Credit Note Date||Date the credit note was issued|
|Location||Name of the location from where goods were picked/dispatched|
|Customer Reference||Customer Reference associated with the sale|
|Sales Representative||Name of the sales representative associated with the sale|
|Customer Tags||Comma-separated Customer Tags|
|Customer Additional Attributes 1-10||Values of customer additional attributes|
|Year||Year of the sale order|
|Quarter||Quarter of the sale order|
|Month||Month of the sale order|
|Family||Product Family name|
|Unit||Product unit of measure|
|Product Additional Attributes 1-10||Values of product additional attributes|
|Product Tags||Invoice issue date|
|City||Customer address city|
|Country||Customer address country|
|State||Customer address state|
|Postcode||Customer address postcode|
|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 the credit note line|
|COGS||Cost of Goods Sold in base currency = Credit Note COGS|
NOTE: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.