I would like to have a generic enquiry that lists out any AP invoices that are still open and have multiple payments applied. Can someone advise how to get started. I don’t know which tables I would need and how to join them.
Thanks
Here is an example of the data I am looking for:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a8016804-c7e3-4375-a117-e8a37bba267d.png)