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:
Check Number | Payment Date | Payment Type | Vendor Name | Payment Amount | Bill Number | Bill Date | Due Date | Bill Memo | Bill Amount |
|---|
00000010/32 | 12/18/2024 | ACH | Test Vendor 1 | (11,368.79) | 4004300149 | 11/25/2024 | 12/18/2024 | 10622920 | 810.09 |
00000010/32 | 12/18/2024 | ACH | Test Vendor 1 | (11,368.79) | 6001718759 | 12/1/2024 | 12/24/2024 | 0010480636 Amortization | 1,393.08 |
00000010/32 | 12/18/2024 | ACH | Test Vendor 1 | (11,368.79) | 4004304474 | 12/1/2024 | 12/24/2024 | 10480636 | 9,165.62 |
00000008/30 | 12/12/2024 | ACH | Test Vendor 1 | (8,903.08) | 4004297213 | 11/20/2024 | 12/15/2024 | 10605678 | 8,555.74 |
00000008/30 | 12/12/2024 | ACH | Test Vendor 1 | (8,903.08) | 4004299462 | 11/22/2024 | 12/17/2024 | 10558971 | 347.34 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004291747 | 11/11/2024 | 12/4/2024 | 10437489 | 160.52 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004293178 - Late Fee | 11/13/2024 | 12/8/2024 | 0010480636 - Late Fee | 44.60 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004293408 | 11/13/2024 | 12/28/2024 | 10440309 | 1,834.60 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004293178 | 11/13/2024 | 12/18/2024 | 10480636 | 2,044.83 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004294411 - Late Fee | 11/19/2024 | 12/24/2024 | 10622920 | 17.52 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004291747-Late Fee | 11/11/2024 | 12/24/2024 | 0010440309-Late Fee | 41.24 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004294411 | 11/15/2024 | 12/15/2024 | 10622920 | 327.33 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004294326 - Late Fee | 11/15/2024 | 12/17/2024 | 10552090 | 1,126.82 |
00000007/31 | 12/5/2024 | ACH | Test Vendor 1 | (27,873.18) | 4004294326 | 11/15/2024 | 12/4/2024 | 10552090 | 22,275.72 |
Thanks for your help!!!!!
Kind Regards,