1. Create a new record query.
  2. On the Criteria tab, select the following:
Activity, Charge, Charge Billing Item/Product ID [equals] [Billing Item ID]
AND Activity, Charge, Charge Payer information, Percentage of Charge Paid [does not equal] [100%]
  1. On the Output tab select the fields you would like to see in your results.
  2. Run the query.