Thanks for your quick response.
So sad to hear that Quickbooks does not currently have that kind of report as I expect. Another concern is for the display of report that I mentioned before. I don't absolutely delete any invoices on Quickbooks since they have been sent to our clients.
I assume it might be that I didn't record invoice numbers for some of them, so Quickbooks couldn't understand to show them as invoices on the report?
Hope you can think about this.