Incorrect receipt numbers issued to donors when Raiser's Edge eReceipts fail

Receipt numbers are mismatched when users run a failed or invalid eReceipt parameter.  This specifically occurs if the email address for donors is incorrectly formatted, containing no extension, invalid characters, or invalid extension, i.e. .con instead of .com

7.96, patch 8 included changes to improve the way The Raiser's Edge handles invalid email data when sending eReceipts, which resolved this issue in internal testing. For more information on the release, see What is in patch 8 for The Raiser's Edge 7.96?

eReceipt mailings are tested to assign receipt numbers as expected when the mail parameters and data used in the mailing is accurate. When invalid or corrupt email addresses are included, this could lead to unexpected results.

It is imperative that Raiser's Edge mail merges are set up per the user guidelines and contains accurate data to ensure consistency and assurance the software is functioning as designed.

Steps to Duplicate

  1. Create a query of donors with un-receipted gifts (in this example the donors Receipt type=Consolidated) and ensure there is a mixture of valid and invalid email addresses (email address with no extension or improperly formatted, i.e. jane@yahoo; or jane@yahoo.con)
  2. Navigate to Raiser's Edge> Mail> Receipts
  3. On the General tab, include Query from step 1 and choose to Create custom data file
  4. On the eReceipts tab mark the checkbox to Send as eReceipt
  5. Click Merge and choose to Acknowledge and Receipt gifts
  6. View message:  Error: the next available receipt number for the receipt stack is 257 The number you entered will result in receipt numbers being skipped. Would you like to continue and skip the receipt numbers? Click Yes or No
  7. Users can verify when comparing the results of the eReceipt to the Raiser's Edge gift record(s) that the records were assigned receipts numbers in order despite issues with invalid email addresses. The eReceipt results show donors with invalid emails were skipped and the next available number was assigned to the next valid email address despite the fact that the number was already assigned to a different donor in the database view.

Environment

 Raiser's Edge
 7.96
 7.96
 8

Was this article helpful?