Texada Pay Payment Log
Accounts Receivable Menu -> Payments -> Texada Pay Payment Log
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)