This report shows detailed financial and quantity-related information about each product sold.
The report inputs are shown in the table below.
|Beginning date of the report|
|Closing/end date of the report|
|Refreshes the report results based on the latest data|
|Sets filter on fields used in the report|
|Allows export of report data to Excel, PDF or RTF|
|Set to the Default layout. Allows selection of saved layouts, if any.|
After setting the inputs described above, pressing the Update button refreshes the report based on the selected inputs. The output fields are shown in the table below.
|Customer Reference associated with the sale|
|Name of the sales representative associated with the sale|
|Tax||Tax on sale order|
|Shipment Date||Shipment date of the sale order|
|Year||Year of sale order|
|Quarter||Quarter of sale order|
|Month||Month of sale order|
Name of the product
|Invoice Number identifying sale invoice|
|Invoice issue date|
|City||City where the customer resides|
|Country||Country where the customer resides|
|Name of the location from where goods were picked/dispatched|
|Quantity of the product sold (by invoice - credit note restock)|
|Invoice Line Total - Credit Note Line Total including tax in base currency|
|Invoice Line Total - Credit Note Line Total excluding tax in base currency|
|Average Discount applied to the invoice line|
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.
Total of all Additional Transactions associated with the sale in base currency distributed by invoice lines using Total amount
Profit = Invoice - COGS. In base currency.
|Grand total of sale orders|