Texada Pay Payment Log

Accounts Receivable Menu

Payments

Reports Menu -> Automatic Reporting -> Function TPLOG01 -> runs Texada Pay Payment Log

This utility can be used to build a list of the payments generated through Texada Pay.
This history can be filtered by Customer selection, Card Type, Date Range, and transaction Status.
This information is also available by specific customer from the TEXADA PAY button on the details of the Customer Account Inquiry, that generates the Texada Pay Payment Log Inquiry.

The report can also be run automatically with the spreadsheet or PDF output emailed to staff by setting up TPLOG01 with the relevant filters and email addresses in the Automatic Reporting.

The report filters are:

CARD TYPE

Select one of the following types of transactions from the drop-down list:

Leave this field blank or click All to list all eligible transactions in the date range.
Click A - ACH (for American) or EFT (for Canadian, New Zealand and Australian) to list the electronic check transactions.
Click C - Credit to list Credit Card transactions.
Type C is also assigned to "Corrections" made to TP payments that cleared the OpenEdge clearing house but had to be re-entered manually to complete the payment transaction in SRM.
Click D - Debit to list American direct Bank card transactions.
This option is only available if your Company is currency is set to a US region.
Click I - Interac to list Canadian direct Bank card transactions
This option is only available if your Company is currency is set to a CDN region.

FROM DATE

Accept the default start day of 10 days ago or enter a preferred starting for the transaction range.

TO DATE

Accept to-day's date for the cut-off transaction date or enter a preferred ending date for the range.

STATUS TO INCLUDE

Select or deselect each of the Status filters for the transaction results:

Check In Progress to include transactions currently being processed such as checks submitted but not yet cleared the bank, or uncheck this box to omit these transaction types from the output.
Check Approved to include processed and approved transactions or uncheck this box to omit successful completed transactions from the output.
Click Declined & Other to include transactions that where declined or failed such as NSF, or uncheck this box to omit rejected transactions from the output.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click the ACCEPT button to begin printing the report, or CANCEL to abort.

Note: Because each check/cheque (ACH/EFT) payment needs to confirm the current status, this process could take a long time if a large date range was selected and ACH/EFT type payments are being included.

Resulting Output
The spreadsheet output includes the following data values:

Card Type (of A = EFT, C = Credit, I = Interac)
Customer# and Customer Name
Source (P for Payment, I for Invoice, C for Contract Deposit, R for Reservation Deposit, O for Sales Order, W for Work Order)
Document # or Capture
Payment Id (system generated ID)
Date, Time, and dollar Amount
* Status of Transaction (Approved, Failed, Submitted, Authorized)
Method Of Payment or VOID flag
Transaction Type (AU -Authorize only or SA -Sale or CR -Credit/Refund or VO -Void)
Card or Banking number
Issuer (for Credit Cards only)
Global Payments (Y or blank for N)
Payer Id (system generated)
Sign-In Division
Operator code
Reference Id (Global Payments only) and Sale Id (Global Payments only)
MOP GL Acct# (Method of Payment post G/L Account)
Card Reader for Terminal transactions

* The 'Status of the Transaction' is determined at the time the report is run so it can accurately reflect the current status of the payment or refund as it changes from “Check Submitted” to “Check Approved”, etc.
If the clearing house Approval fails the payment needs to be manually reversed in SRM as no payment was collected.
Some reasons for a fail to approve are: "Check Daily Amount Exceeded”, “Check Verification Failed”, "Declined".

The PDF report output includes the following data values:

Card Type (of A = EFT, C = Credit, I = Interac)
Customer# and Customer Name
Source (P for Payment, C for Contract Deposit, I for Invoice, R of Reservation Deposit, O for Sales Order, W for Work Order)
Document # or Capture
Payment Id (system generated)
Date, Time, Amount
Status of Transaction (Approved, Failed, Submitted, Authorized)
Issuer (for Credit Cards only)

Topic Keyword: TPLOG01 (7075)