Accurate Sales Person Reporting

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!

1 person likes this idea
Login or Signup to post a comment