As we already know, a product can be tracked or non-tracked goods. With Deskera Books system, users can now generate the sales by product report, and it's only applicable for tangible goods.
Firstly, to view the sales by product report, go to the 'Reports' tab on the sidebar menu. Under the Sales section, click on the 'Sales by Product Report.'
You will be directed to the Sales by Product Report page where you can input your search criteria here. You can choose to view this report based on the date range and also product code. Once you put in the details, click on the 'Generate' button.
The sales by product report will be generated based on what you have input in the search criteria. You can view the list of product ID, product name, the number of products sold, total amount, percentage of sales, average sales price, gross margin, and % of gross margin.
To edit, share, and export the quote report, click on the drop-down arrow next to the Sales by Product Report title. You can choose to view the report, share the report via the link, embed link or snapshots, export the file as CSV or copy the panel JSON to clipboard.
Users can also choose to download the report in excel file by clicking on the arrow at the top right of the page and select the "Export Excel" or "Export PDF" button.
You can also set a Product custom filter by clicking on the "Filters" option.
You might find these articles helpful: