This report shows the profits made per product within the specified period of time. It uses inventory movements to record sales proceeds from invoices related to fulfilment. It will include sales invoices regardless of date as long as the ship date falls within the specified date range. Use this report to see detailed financial information such as COGS, sale proceeds, amounts for non-sale operations (transfers, assembly, etc.) and profit.
Data from this report can be exported in Excel, PDF or RTF format.
|Reporting Period||Allow user to select the reporting 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 need to click More Fields to display them so they can be added to the report.
|Product||The name of the product|
|Unit||Product unit of measure|
|Tags||Comma-separated product tags|
|Family||Product family name|
|Batch #||Batch or Serial number if applicable|
|Expiry Date||Batch Expiry Date if applicable|
|Year||Year of stock movement date|
|Quarter||Quarter of stock movement date|
|Month||Month of stock movement date|
|Product Additional Attribute 1-10||Values of product additional attributes|
|COGS||Total cost of goods sold amount|
|Sale Proceeds||Sale proceeds for the product|
|Production / Inventory / Transfer||Cost of the product spent on non-sale transactions|
|Profit||Profit = "Sale Proceeds" + "Production / Inventory / Transfer" - "COGS"|
NOTE: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.