I have a vendor that is requesting we send them information for all the payments we made in the last year. I know that there is the already build report "AP Payment History by Invoice," but I do not like the way that report give the information and I need a few customizations.

I've tried doing my own saved search but I'm not sure how to pull in the "related records" data. I would like a report that shows me the bill payment check number, payment date, Vendor, Payment amount, the bill document number, date & due date, and the bill memo line (not the bill payment memo line) and finally the amount of the bill. If that bill payment has more than 1 bill applied to it, I want it to list them all, here is an example of three different bill payments for the same vendor and the related bills: