The constituent's rejected payment history displays, as shown below. Data in the grid is sorted by ORDER_NO (descending), ORDER_LINE_NO (ascending), and then DUE_DATE (descending).
As of 7.5.2, you can view information about scheduled payments being paid by EFT that have been rejected by EFT681.
To view rejected payment history:
1. From the Financial
Data task category in CRM360,
click EFT Bank Acct Information.
The Bank Account Information and Rejected Payment History tabs displays.
For more information on the Bank Account Information tab, please see Adding
a Constituent's EFT Bank Account Information.
2. Click the Rejected
Payment History tab.
The constituent's rejected payment history displays, as shown below. Data
in the grid is sorted by ORDER_NO (descending), ORDER_LINE_NO (ascending),
and then DUE_DATE (descending).
The following information is displayed in the grid:
Column |
Description |
|---|---|
Order No |
The rejected order number (Order_Detail_Eft_Rejected_Pymt.ORDER_NO). Double-click the order number to open the ORD001 screen for non-ADV or FND orders. For advertising orders, the Insertion Orders screen (ADV002) screen will open. For fundraising orders, the Donation Entry (FND002) screen will open. |
Line |
The line number on the rejected order (Order_Detail_Eft_Rejected_Pymt. ORDER_LINE_NO). |
Description |
The line number description on the rejected order (Order_Detail.DESCRIPTION where Order_Detail.ORDER_NO = Order_Detail_Eft_Rejected_Pymt.ORDER_NO and Order_Detail.ORDER_LINE_NO = Order_Detail_Eft_Rejected_Pymt. ORDER_LINE_NO). |
Due Date |
The due date of the scheduled payment for which the direct debit payment failed. |
Amount |
The amount due for the scheduled payment for which the direct debit payment failed. |
Bank Account |
The description of customer’s bank account used for the direct debit payment. |
Attempts |
The number of collection attempts that have been made to collect the direct debit payment. This is set by EFT681.
|
Collected? |
If the payment status code of the scheduled payment is PAID, a "Y" is displayed. If the payment status code is PENDING, an "N" is displayed.
If the due date no longer exists in the payment schedule, “NA” is displayed. |
The following information is displayed when you expand a row in the grid:
Column |
Description |
|---|---|
Collection Attempt Date |
The date that EFT680 attempted to collect the scheduled payment. If a payment is applied manually, a new record is also created in this table, and the collection attempt date is set to the receipt batch date. |
ACH Return Code |
If the record is being created for a rejected direct-debit payment, the ACH return code is recorded here. Values in the grid column are populated based on the description of the fixed codes defined for the EFT "RETURN_RSN" system type. |
EFT681 Job ID |
The TRS Job ID of the EFT681 job that created the record is recorded here. |
The total number of times a rejected
bank draft is resubmitted for collection by the organization’s
bank before the bank notifies the organization that the bank draft
was rejected (