Skip to Content
Former Member
Mar 15, 2015 at 08:13 AM

Payment File Query


Hi all,

I'm trying to generate a query to compile all payment listing. While I'm able to retrieve most of the vendor information from the table OCRD & OCPR and invoice payment amount from OVPM or VPM2, the listing generated will show every single line of invoice paid. Is it possible to show a total transaction by the vendor itself? Is there any other table available to retrieve the information from? Thanks in advance for any helps.