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
Guest

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?

PYMNT_VOUCHER_XREF.VOUCHER_ID = VOUCHER.VOUCHER_ID
PYMNT_VOUCHER_XREF.PYMNT_ID = PAYMENTS_TBL.PYMNT_ID ?

Thank you

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

there is a delivered view for same.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
1 + 11 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.