How to create a sales report for items sold that doesn't include non-stock items
To see sales figures for stock items only, you can use the 'Stock Turn Summary' report. This report is located under 'Reports Menu'/'Sales Reports'/'SAL007 - Stock Turn Summary'. To ensure non-stock item figures are not included in the report, select 'No', next to 'Show Non Stock' on the reporting options page.
The columns shown are Department, Total Sales ($), % Total, No. of Sales, % Total, Avg. Sale ($), Total Cost ($), Avg. Days to Sell, Qty. in Stock, Closing Stock Cost, % Total Stock, Gross Profit ($), GP Margin (%), % Total GP, Avg. Markup, ROI [Return on Investment], Stock Turn. The report can be sorted by department, supplier or category.