Fund Raising Order Created

Generated when a donation is entered into the back office. An email is sent to the Bill-To customer of the donation and provides him/her with the order number of the donation and a summary of the order.

This will generate the email if the date the order was added is greater than the last time this process was scheduled to run. The schedule is determined by the Event Interval setup on the Notification Maintenance screen.

Event Stored Procedure Name:  usp_NOTIFY_NEW_FUND_RAISING_DONATION

As of 7.6.1, if any order confirmation text has been defined for the product or the product class, the text will be added as the last paragraph to the stored procedure for the notification. For more information, please see Defining Fundraising Gift Order Confirmation Text. 

Trigger on Table

None

Business Change Options

The original intention of the notification is to acknowledge orders entered by staff in the back office.  This stored procedure filters out all Web orders by the Order Method column.  If a special notification is needed for Web donations, then copy this stored procedure into a new one and change the filter to be ORDER_METHOD_CODE = ‘WEB’.  Create a different message template for your new notification.

Sample Message Template

Dear ##ORDERS.BILL_CUSTOMER_FULL_NAME##,
Thank you for your donation to [Insert Your Association Name]. Your reference number, which can be used when contacting us regarding this donation, is ##ORDERS.ORDER_NUMBER##. Below is a summary of your donation: