Hi all.
I'm trying to find a list of people who have funds on a specific On Account payment method. I feel good about this tiny bit of code, but I need to exclude those patrons with $0.00 balance. Anything I try with pmt_amt either < or > $0.00 removes specific transactions, not those with $0.00 on account.
(As a side note - I am trying to use this in either a list or an extraction, if that matters at all...)
Thanks in advance,
Lesley
The report is great, but will I need to use it in a list and then use the list in the extraction?
You'd have to run it manually and then save it as a List to then use the output with Extractions. Not going to work for any sort of automated process, for sure.
Thanks Gawain.
Hey Lesley - You may want to check out this recipe for on account funds which you could use for lists/output sets
www.tessituranetwork.com/.../Tessitura.htm
Thank you Jennifer!