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.
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.