We use department codes on most sales invoices. We would like to run a report on amounts Invoiced breaking down the invoiced amount by department dimension.
1. Cannot do it by searching on Sales > invoicing > Archive, because Department is kept at invoice line level, not invoice header level.
2. Cannot do it by Reports > Customers > Turnover Statistics as I get the totals but not the line by line, invoice, by invoice, detail.
3. Cannot do it by Accounting > Searches & Lists > Find entries, because department selection not an option.
4. Can sort of do it by running an Export and then analysis in Excel, but takes 5 mins+ each time.
Have we missed something? Is this something others would want? Our preference would be 3. Add department code as a selection criteria; 2. Add an option to see Invoice header details.