1. Create a Record Query.
  2. On the Criteria tab, select the following:
    Activity, Payment, Student Billing Payment, Paid Charges, Payment charge billing item ID/product ID and choose the appropriate item.
    AND Record, Record type equals the appropriate [record type], such as student.
  3. On the Output tab, select any additional desired output information. 
  4. On the Sort tab, select a field to sort the query results.
  5. Run the Query.