Information on Suppliers on PreNote
Hi,
We are on PeopleSoft 9.2. I need to find those suppliers who have PreNote as "Not Required" in their profile but have got paid already. I am looking at two records : PS_VENDOR_PAY & PS_PYMNT_VCHR_XREF. The first record gives me the suppliers with PreNote info and the second record gives payment information related to that supplier. I created the below query to check if these suppliers have been paid or not ( having clause). Am I correct ?
SELECT DISTINCT A.VENDOR_ID, A.VNDR_LOC, A.PYMNT_METHOD, A.PRENOTE_REQD, COUNT( B.PYMNT_ID), A.EFF_STATUS