This report shows all authorised sale invoices and credit notes applicable to the selected time period. Use this report to see invoices and credit notes for each customer, what products it relates to and amount, tax and total. Amounts can be shown in customer currency or your base currency.
Data from this report can be exported in Excel, PDF or RTF format.
|Time Period||Allow user to select the time period from a list of options are set custom a custom date range.|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets 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.
|Document #||Invoice/Credit note number|
|Customer||Customer name who was issued the invoice/credit note|
|Currency||Currency of the invoice/credit note (customer currency)|
|Date||Date when Invoice/Credit Note was issued.|
|Invoice/Credit Note||Document type|
|Order #||Number of sale order related to the invoice/credit note|
|Order Date||Date the sale order related to the invoice/credit note was issued|
|Sales Representative||Sales Representative associated with the sale|
|Location||Location of stock picking/dispatch|
|Year||Year of invoice date|
|Quarter||Quarter of invoice date|
|Month||Month of invoice date|
|Invoice Due||Date when Invoice is due|
|Unit||Product unit of measure|
|Product Tags||Comma-separated product tags|
|Customer Reference||Customer reference from sale document header|
|Customer Tags||Comma-separated product tags|
|Customer Additional Attribute 1-10||Values of additional customer attributes|
|Product Additional Attribute 1-10||Values of additional product attributes|
|Comment||Notes field of invoice/credit note document header|
|Quantity||SKU quantity on Invoice/Credit note|
|Amount||Invoice/Credit note line amount in customer currency|
|Tax||Tax for invoice/credit note line in customer currency|
|Total||Total for invoice/credit note line (Amount + Tax) in customer currency|
|Base Currency Amount||Invoice/Credit note line amount in base currency|
|Base Currency Tax||Tax for invoice/credit note line in base currency|
|Base Currency Total||Total for invoice/credit note line (Amount + Tax) in base currency|
NOTE: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.