Pull more detail for consolidated receipts

William Da Silva — Tue, 15 Jul 2008 20:57:07 GMT

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 ), I will be able to complete my procedure.

Thanks in advance,

William

VBA/API

Pull more detail for consolidated receipts