We need a report that can be filtered by SALESPERSON
For a monthly date range
Which shows invoices raised within that date range
AND invoices PAID within that date range but may be dated before the date range.
We cannot filter by the monthly date range as this will exclude those invoices that were dated before the monthly date range.
I need the figures for invoices paid that month, regardless of when they were raised.
If we include ALL invoices, we get all these lines with ZEROS in them for every invoice ever raised by that salesperson, paid or not!