As
of 7.4.1SP1, the GetProrateFactor stored procedure called by FND680 has
been updated to allow for rounding up to 6 decimal points.This batch process is for donors who have made recurring gifts to be paid by credit card. This process captures the payment when it is due, creates the receipt record, and then creates the donation order line. It creates a new donation order line in the same order. This process generates two reports: Processed Receipts and Failed Receipts.
The process selects all recurring gift donations where the status is ACTIVE and the next recurring gift date is less than or equal to the value entered in the PROCESS DATE parameter. A recurring gift can be identified when the recurring gift flag is YES (i.e., when the Order_FND_Detail.RECURRING_GIFT_FLAG equals “Y”). Fundraising credits are also created for recurring gift donors.
As of 7.6.1, for organizations using Vantiv as their payment handler, FND680 checks the PROCESS_EXPIRED_CC merchant parameter to determine whether expired credit cards should be selected for processing. If the credit card defined for a recurring donation has expired, if the PROCESS_EXPIRED_CC merchant parameter is set to "N", FND680 will not select recurring donations with expired credit cards that are due to be paid. Ccp_Req_Ans.REJECT_REASON will be filled with “Credit card is expired.” Ccp_Req_Ans.ERROR_CODE will be set to 24 for Verisign, 202 for Cybersource, and 305 for Vantiv. If the PROCESS_EXPIRED_CC merchant parameter is set to "Y", FND680 will transmit credit card payments to Vantiv even if the credit card is expired. When Vantiv returns the authorization request response, if the organization is using Vantiv’s "Account Updater" service, the response file will include the updated credit card expiration date, as well as any other changes that may have been made to the credit card, such as change of name, change of credit card number or change of credit card type.
FND680 is typically run once a week unless an organization needs a different schedule based on the volume of recurring gift donations.
If there is an error in capturing the payment, then the information appears on the error report and no receipt or donation order lines are created.
As
of 7.4.1SP1, the GetProrateFactor stored procedure called by FND680 has
been updated to allow for rounding up to 6 decimal points.
Parameter |
Description |
Required? |
|---|---|---|
Organization ID |
Read-only. Set to the organization ID of the person running the report. |
Read-only |
Organization Unit ID |
Read-only. Sets to the organization ID of the person running the report. |
Read-only |
Run Mode |
Mode in which the report runs: · EDIT – prints the report. · PROD – prints the report and updates the database tables. |
Yes |
Batch |
This field becomes enabled if the Create Batch checkbox is not checked. Enter the batch number you want to use for this process (or look-up). |
Yes, only if Create Batch is unchecked |
Process Date |
Date drop-down. The process is selecting all recurring gift donations where the status is ACTIVE and the next recurring gift date is less than or equal to the value entered in the PROCESS DATE parameter. For the date value entered here, the process will select |
Yes |
Create Batch |
Checkbox. Checking this will cause the system to automatically generate a direct batch for the recurring gift receipts created from this process. The batch is posted when the process completes. |
Yes |
Advanced Job Parameter |
||
Filter |
Reduces the record selection further based on the SQL statement entered. Standard filter rules apply here. Goes against order detail. |
Yes |
Order_Master
Order_Detail
Order_FND_Detail
