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