You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

PeopleSoft invoice amount vs payment amount

1 reply [Last post]
Guest's picture

Hi ...
Anyone knows the query to check if the paid amount is more than the invoice amount?

I think I need to look at PYMNT_VOUCHER_XREF first to get to VOUCHER and PAYMENTS table. Then check if PAYMENT_TBL.PYMNT_AMT > VOUCHER.GROSS_AMT ... Is this the correct way get the information I need?


Thank you

Nitin's picture
User offline. Last seen 5 years 42 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: PeopleSoft invoice amount vs payment amount

there is a delivered view for same.