- Create a query of all pledges.
- Navigate to Query and choose to create a new Gift query.
- Select the following Criteria:
- Gift Information > Gift Type equals Pledge (or Gift Type is one of Pledge, MG Pledge)
- Save and close query.
- Run the Written-Off Report and on the General tab of the report, mark "Create Gift output query."
- Preview the report and save the output query when prompted.
- Merge the queries using Sub as the merge operator. The output query from the pledge query will be used as the secondary query to find all pledges that do not have write offs.
Connect and collaborate with fellow Blackbaud users.