Financial Management - PSFT (MOSC)

MOSC Banner

Information on Suppliers on PreNote

edited Jun 24, 2020 5:00AM in Financial Management - PSFT (MOSC) 8 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center