Hey y'all,
I'm writing a report that needs to output all payments that could have affected a contribution. I've been investigating, and it seems the (only?) foolproof method would be to do a recursive query on T_TRANSACTION, kind of bouncing back and forth between ref_no and transaction_no until we've got all the transaction_nos, and then joining all of those transactions to T_PAYMENT.
Anyone do anything like this before that I can steal, or have any thoughts on the topic?
Assuming that some of your contributions are paid through an on account payment method, you’ll have to match a payment transaction to an on account transaction by amount and date proximity.
Lucie
__________________________________________
Lucie Spieler
IT Development and Training Manager FLORIDA GRAND opera