Hi there, BenTam.
QuickBooks can only generate the numbers per transaction type. If you've entered the payment number on the Memo field, then we can add the Memo column on any sales report. Otherwise, you'd have to open each transaction to get the data you need.
You can run the Transaction List by Customer report to get the invoice numbers.
You can also export this report to Excel, edit the columns there, and then add the payment numbers. To do this, click the Excel button at the top of the report and select Create New Worksheet.
You can always get back to me if you need anything else. Thanks for dropping by.