Linking donation form transactions to committed revenue records.

Harry Frank
Harry Frank
Eighth Anniversary Kudos 1 Name Dropper Participant
in Blackbaud CRM Developer Discussions

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!

Comments

  • Chris Kastner
    Chris Kastner Blackbaud Employee
    Tenth Anniversary Kudos 1 Name Dropper Participant

    @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
    Harry Frank
    Eighth Anniversary Kudos 1 Name Dropper Participant

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

Categories