The Transaction Lines report allows you to view all line items ordered. It is accessed form the Tools Menu -> Reports.
The report lists variant items (of matrix styles) as line items, so there is no need to drill down on styles to see the details on variant items ordered (as in the Item Orders report in the reports section).
This report is very useful when exported to Excel and can be manipulated to provide you with grouping by brand, store, style, subtotals and totals.
You can also filter the report to show only the lines that you require. For details on the report filter syntax see: Transaction Lines Report Filtering
Export to Excel
You may export to Excel in order to manipulate the data and create any reports you need.
Configure the columns and headings of the report. Select the columns from the available fields list. The fields include Account fields, and custom fields.