Understanding the Payment Due Column on Registration Lists
review the actual payment transaction, use the Payment Received Activity join, then join from Payment Received Activity to the Payment base.
This allows the registration list to display payment-specific details from the payment record, such as payment amount, payment