When a pledge is paid in full....

Options
Jessica Vaughn
Jessica Vaughn ✭
Ancient Membership First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion

Is there some kind of field that will filter by paid in full? I know how to find the balance on a constituent query but now I need the opposite.

Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Jessica Scalese:

    Is there some kind of field that will filter by paid in full? I know how to find the balance on a constituent query but now I need the opposite.

    Jessica, you can use pledge balance field and set criteria equals $0. For the query I also select Gift Type = Pledge, my fund, and as we enter $0 pledges when turned down I also include Gift Amount greater than $0.  Easily pulls a list of pledges that are paid in full.
  • Jessica Vaughn
    Jessica Vaughn ✭
    Ancient Membership First Reply
    JoAnn Strommen:
    Jessica, you can use pledge balance field and set criteria equals $0. For the query I also select Gift Type = Pledge, my fund, and as we enter $0 pledges when turned down I also include Gift Amount greater than $0.  Easily pulls a list of pledges that are paid in full.

     Great! Thanks so much!

Categories