1. Create a new Record query (Student Billing) or new Client query (Accounts Receivable).
  2. On the Criteria tab, select Activity, Summary, Record balance (Student Billing) or Summary, Client balance (Accounts Receivable).
  3. Select the Operator of Less than and enter a value of $0.
  4. Select the Filter tab on the Edit Field Criteria screen.
  5. Highlight As of date equals [date] and click Change.
  6. Enter the specific date for the query in the Value field.
  7. Click OK, and then click OK again.
  8. Select the Output tab and select any appropriate Output fields.
  9. Save the query.
  10. Create an Account Balance Report (Student Billing) or a Client Account Balance Report (Accounts Receivable).
  11. On the General tab of the report parameter, make sure to check the box to include records with a credit balance.
  12. On the Filters tab, use the query you just created to filter the Account Balance Report's "Assigned to" filter.
  13. Preview the report.