I do believe a query such as the following might get one somewhat closer to the desired result...
SELECT PM80500_2.TRXSORCE, PM80500_2.VCHRNMBR, PM80500_2.DOCTYPE, PM80500_2.APFRDCNM, PM80500_2.VENDORID,
PM80500_2.APTVCHNM, PM80500_2.APTODCTY, PM80500_2.APTODCNM...
I'm working on a similar issue trying to give users a quick view/lookup of all invoices and credits documented on a check remittance to the vendor. I'm not quite sure, but it looks like you could kind of piece this together using the info from the 80500.TRXSORCE field coupled with the VendorID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.