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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
there is a delivered view for same.