Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Pull more detail for consolidated receipts

Last post 07-15-2008 4:57 PM by William Da Silva. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 07-15-2008 4:57 PM

    • William Da Silva
    • Top 200 Contributor
    • Posts 36
    • Organization: Lakeshore General Hospital Foundation
    • Products:  The Financial Edge, The Raiser's Edge

    Pull more detail for consolidated receipts

    Has anyone been able to use VBA to pull out extra data during a receipt run? More precisely for consolidated receipts?

     My problem lies within consolidated receipts. Since RE does not export any kind of detail on camp fund appeal... for consolidated receipts, I have tried to devise a way to pull it out with VBA. Basically, I need to have the fund(s) appear on the receipt, so basically, I want a summary by fund for consolidated receipts. I was able to find a nice little event that fires after the export and before the merge (in mail). I started writing code to open the data file exported and update the amounts. When I came to test the code, I realized that the event is triggered before the "mark gifts as receipted" operation. This means that the code I added is useless as I was looking up the amounts in RE based on receipt number (and receipt numbers in RE are only assigned after the "mark as receipted" operation).

    Has anyone figured out how RE marks as receipted? If there is a listing of gift IDs and receipt numbers somewhere that I can hack into (or investigate for David Wink  ), I will be able to complete my procedure.

    Thanks in advance,

    William

     

    William da Silva
    eSimpleIT.com
Page 1 of 1 (1 items)