Linking donation form transactions to committed revenue records.

Harry Frank

I am trying to reconcile records that come from our advanced donation form into the donationtransactions table with revenue records in the financialtransaction table that were committed through the web transaction download to batch process. The closest I have been able to get is the batchid field in the financialtransactionlineitem table, but this does not let me tie back to a specific row in the batch. Has anyone had any success with this or can anyone provide any insight into this puzzle?

Thanks!

Chris Kastner

@Harry Frank Sorry a little late on this one… there is a magic missing link I found recently on this one…

The table dbo.REVENUEBBNC includes both the revenue ID, and the NETCOMMUNITYTRANSACTIONID field which maps to the dbo.DonationTransactions DonationTransactionID field.

It also gives you the BBIS page, and/or email message that was associated with the payment.

Harry Frank

@Chris Kastner
Wonderful. Works like a charm, thanks!