Texada Pay Pending Refund Queue

Reports Menu -> Automatic Reporting -> Function TPRNT02 -> runs Update TP Pending Refund Queue

This pending refund table automatically logs any failed Texada Pay Refund transactions that could not be processed through the clearing house because the original deposit or payment had not been approved yet.
The refund transactions can then be re-submitted to the clearing house at a later time.

Note: When a refund transaction is written to the "TP Pending Refund Queue" it is not logged in the Texada Pay Payment Log until after it has been fully processed.

This is useful especially for refunds with New Zealand and Australian Texada Pay when a security deposit is taken on a Contract when products go out on rent but then the contract is returned the same day and the contract total is less than the security deposit.
The balance of the deposit needs to be refunded but the initial security deposit may not have cleared the clearing house.
This 'TP Pending Refund Queue' processing is less useful for Canadian and U.S. Texada Pay refunds as the credits are processed through the clearing house immediately.

To use this feature, both the 'Global Payments' and the 'Refund Existing Payment Only' must be activated in the Texada Pay configuration.
Note: The 'Refund Existing Payment Only' feature is automatically activated for Australian & New Zealand currencies.

When the initial payment and the refund are submitted through SRM and Texada Pay the deposit history and payment record are processed as successful. The customer's document prints completed payment information and the postings are all processed in the next Daily Close regardless of their status with the clearing house.

If refunds fail at the clearing house the can be logged in this table and can be re-submitted repeatedly until the are accepted, or the operator can delete them to prevent them from being processed.
If they are deleted from this table, a manual reversal of the refund is required through the capture deposit utility.

View the list of outstanding refund requests as follows:

FROM CREATE DATE

Accept the default starting date or enter a preferred start date for the range.

TO CREATE DATE

Accept the default ending date or enter a preferred cut-off date for the range.

CUSTOMER OR ALL

Accept ALL customers or to narrow the search enter a single customer number or select it from the Customer Search window.

DIVISION OR ALL

Accept ALL Divisions or to narrow the search to a single Division enter the Division code or select it from the Division Search window.

Resulting Outstanding Refund Transactions:

Any negative dollar TP transactions that were rejected at the time they were submitted for a refund are listed with the Created Date, Created Time, Type of Credit or Bank, Amount of refund, Source being type of document, Document number, Customer number, Document Date and Division.
The expanded record displays the URL for the specific refund to be re-submitted.

ACTIONS:
Additional actions provided by buttons on the Texada Pay Pending Refund Queue screen include:

• Delete a Pending Refund Record:
  Focus on the relevant refund transaction and click the DELETE button so that it will not be submitted to the clearing house in an attempt for payment again.
  Confirmation is required.
  Manual reversal is then required to update deposit and payment history and to reverse the refund postings in the G/L.
  An audit record is written to the Delete Log.

• View more information on a Pending Refund Record:
  Click the EXP/CON button to expand the pending refund transactions to view the URL for the refund gateway and click the same EXP/CON button again to contract the data.

• Submit the Pending Refund Transactions to the Clearing House:
  Click the PROCESS button to execute the "Update TP Pending Refund Queue" (TPRTN02) which resends all failed but pending refund requests to the clearing house such as the OpenEdge/Ezidebit portal.
  All outstanding pending refund requests are sent regardless of the current filtered display.

  This process returns a pass or fail response for each transaction as reported on the spreadsheet report response and removes passed refund transactions from the pending refund table (TPRNT01).
  When the update is completed the payment transactions are reflected in the Texada Pay Payment Log.

  Messages include:

  • "Return must reference approved transaction" - indicates that the original payment has not been approved yet and that this refund request will need to be resubmitted again later.
  • "Invalid transaction referenced; transaction does not exist"
  • "Successful refund" - indicates the resubmission of this refund was processed through the clearing house so the customer will receive his refund and that the trx was deleted from the "Texada Pay Pending Refund Queue" table.

  The "Update TP Pending Refund Queue" process can be setup to be run automatically with the spreadsheet results emailed to staff, by setting up TPRNT02 with the relevant email addresses in the Automatic Reporting.