What tables do I need to query to find out the applied payments for each invoice? I'm trying to build a query to return data like the

Customer Receivables > A/R Payment History by Invoice

and the

Vendors/Payable > A/P Payment History by Bill

reports