I've had a client request a summary report by Customer and by Supplier. They would like to know what they have invoiced to each customer for the month and what they have purchased from each supplier for the month.
The Customer report that we are seeking would show on one line the total sales to Customer A and total sales to Customer B, for the given period. The current available report (e.g. Sales by Customer report) show more detail than this. The current report shows each invoice issued to Customer A and then a total for Customer A, for the given period. We just want the one line i.e. the Total line.
The client has also requsted a summary of Supplier purchases for the month. There is no report that shows a summary of purchases, by client i.e. the current reports are more detailed than that.
The idea would be to produce two one-page reports (i.e. Customer report and Supplier report) rather than multi-page reports, which is what you potentially end up with if you've invoiced a customer multiple times during a period.