I've been working on a Pledge Payment Schedule report with our IT department. It appears, from what I've been told, that pledge payment transactions which appear in the Payment Schedule table don't have unique transaction numbers. The transaction numbers for pledge payments in the Transaction window are unique, we've been trying to link a scheduled payment with an actual payment.
Any insight would be greatly appreciated.
Thanks,Chandra
That's a tough nut to crack. But I just had a cup of coffee and I'm tired of working on my lame extraction...
I think it depends on what you're trying to do and what you want to see in your report, so I don't think my answer will necessarily solve your problem. However, if I were to pull a report of pledges and payments and the schedule, I would probably look at joining t_schedule, t_transaction and t_contribution on ref_no. I would restrict the pull from t_transaction to trn_type = 3 (pledge payment) and line up the results by date somehow (trn_dt and due_dt) keeping in mind that the paid rows in t_schedule show up as status 'R'.
Not the cleanest way to do things but its one sloppy solution.
Dale
Thanks Dale. I'll present that to IT as something to consider.