Searching for Transactions

The Transactions Datagrid enables merchant users with appropriate permissions to view the transactions of an Organization's child Locations. By default, Dex displays the newest transactions by received date and time first, but you can choose to sort the results from Oldest to Newest or Newest to Oldest or can filter the displayed results by Received Date, Locations, Status, Method, Action, Amount,Order ID, Response, and/or the Last 4 digits of an account number. You can customize the number of items that display using the display dropdown in the bottom left corner.

To access the Transactions Datagrid, click Transactions in the Dex main menu. The most recent transactions display first.

To view a specific transaction without having to filter through a long list, enter one of the following values in the search bar on the Transaction Datagrid:

Billing Company Name
Billing First Name
Billing Last Name
Transaction Trace Number
Location
Customer ID

Dex auto-populates the list of results, which you can further refine by using the search filters described below.

The following table provides a brief description of what each column displays on the Transactions Datagrid:

Column	Description
Received	The date and time when Forte received the transaction (e.g., March 31, 2018 04:23 PM). This timestamp data displays for the timezone of the merchant location that processed the transaction. If the location has not designated a timezone, Dex defaults to Pacific Standard Time (PST).
Status	The status of the transaction. The following values are supported: In Progress - The transaction was received and is awaiting origination (echecks) or settlement (credit cards). If authorized, this field also displays the Status, Response, Return, and/or Settlement Code that returned with the response. Completed - The transaction was funded to or from the merchant's bank account. Failed - The transaction was declined, rejected, voided, or failed verification for reasons detailed in the Status, Response, Return, and/or Settlement Code that returned with the response.
Customer	The Company Name or First and Last Name of the customer associated with this transaction. If applicable, this field also includes the merchant-specified Consumer ID.
Order Info	If supplied, the merchant-defined Order Number and Reference ID included with the transaction. These parameters can include anything from invoice IDs, ticket numbers, or P.O. Box numbers.
Amount/Action	Displays the transaction amount and type of transaction. Dex supports the following transaction types: Debit/Sale Auth Refund/Credit Force/External Auth Verify Balance Inquiry NOTE: The Auth action also displays either a D or C to indicate if the transaction was a Debit or Credit.
Method	The payment method used plus the last four digits of the credit card or bank account number. The following values are supported: eCheck American Express Discover MasterCard Visa PayPal
Authorization Info	Displays the authorization result and the transaction source. If the transaction was approved, this column displays the Authorization Number and the Approval Code. If the transaction was declined, an "Auth Decline" message displays. If the authorization is still in progress, the column remains blank.
Location	The name and ID of the merchant location that processed the transaction.

If you would like to view more data related to your transactions, you can expand the Transactions Datagrid by clicking and selecting the additional columns of data to display. The following table provides a brief description of these additional data columns:

Column	Description
Bank Account Status Verification	Displays the P-codes associated with a Validate Plus transaction. The following options display: P15 - High Risk P20 - Negative Reports P21 - No Negative Reports P23 - Invalid Account/ABA Number P40 - No Negative Info P41 - Negative Info P50 - No Info P70 - Validated P71 - Low Risk Approval P73 - Medium Risk Approval P80 - Vendor Busy P90 - Preauth Vendor Unavailable P91 - Preauth Vendor Error P92 - Preauth Server Unavailable
Bank Account Owner Verification	Displays the P-codes associated with an Authenticate transaction. The following options display: P10 - No Match P50 - No Info P60 - Match P75 - Conditional Match P90 - Preauth Vendor Unavailable P91 - Preauth Vendor Error P93 - Error P94 - Invalid Routing Number P94 - Invalid Account Number P95 - Bad Account
Principal	The authorized amount of a transaction, which includes taxes (if applicable) but not service fees.
Service Fee	The service/convenience fee for the transaction. Service fees are either a percentage of the principal or a set amount.

Filtering the Transaction Display List

Apply the following general filters to customize the displayed transaction list:

Filter	Description
Received	The Received Date of the transaction. Use the date picker in both the Start Date and End Date fields to customize the date range of your listed transactions or manually enter the desired dates in MM/DD/YYYY format in the provided data fields. If a date range is not provided, the End Date defaults to today's date and the Start Date defaults to yesterday. You can also choose one of the following pre-set dates/date ranges: Since Yesterday Last 7 days (the previous six days plus today) Last 30 days Last 60 days Last 90 days Last 180 days This week (starting from Sunday to Saturday) This month Custom This field saves the last date filter option so that you don't have to put the same option in every time you search for transactions. Note: This date filter allows only last two years of transactions to be filtered on grid.A message is displayed if the date range is entered outside this two-year limit.
Location	Wording for Merchant Guide: Search the name or ID of the merchant location that processed the transaction. At the Merchant level the location filter will display the first 10 Locations in a dropdown list for the user to select. If there are more than 10 locations under the Merchant Organization, users can search for additional locations using the search function in the location filter modal. To limit performance issues, no locations will be displayed in the Location filter at the Enterprise level. The search bar within the filter can be used to search for specific locations to select.
Amount	The amount of the transaction. Enter only the number(s) and/or decimal point. Do not enter currency symbols. The maximum allowable amount is $100,000.
Status	The status of the transaction. The following values are supported: In Progress Authorized Ready Settling Review Conditional Match Successful Complete Settled Funded Match Unsuccessful Declined Failed Rejected Voided Unfunded No Match No Info
Last 4	The last four digits of the credit card or echeck account number.
Account Number	The full credit card PAN or bank account number associated with the payment method.
Order ID	The unique, merchant-defined identification number associated with this transaction. The following option is provided: Exact Match: Select this checkbox option to only filter out the display results to match and fetch the exact Order ID data.

If you would like to refine the results of a transaction list further, you can use more specific filter parameters located under the More Filters dropdown field. The following filters are available.

Filter	Description
Authorization Number	The numeric authorization number generated for the transaction (e.g., 244234).
Action	The type of transaction. The following values are supported: All Debit/Sale Auth Refund/Credit Force/External Auth Verify Balance Inquiry
Methods	The payment method used for the transaction. The following values are supported: Echeck American Express Discover MasterCard Visa Diners JCB PayPal
Order ID	The unique, merchant-defined identification number associated with this transaction.
Source	The terminal hardware, software, or integration method used to connect to Forte. Enter a source in the free-text search field and click Update. Supported search values include the following: RESTAPI FCO (Forte Checkout) Scheduled CONSOLE (Dex) VX520 FORTECO SPLITTRANS N/A
Response	The transaction response. Users can filter transactions results by the following supported response values: All Approved Declined
Bank Account Status Verification	Displays the P-codes associated with a Validate Plus transaction. The following options display: P15 - High Risk P20 - Negative Reports P21 - No Negative Reports P23 - Invalid Account/ABA Number P40 - No Negative Info P41 - Negative Info P50 - No Info P70 - Validated P71 - Low Risk Approval P73 - Medium Risk Approval P80 - Vendor Busy P90 - Preauth Vendor Unavailable P91 - Preauth Vendor Error P92 - Preauth Server Unavailable
Bank Account Owner Verification	Displays the P-codes associated with an Authenticate transaction. The following options display: P10 - No Match P50 - No Info P60 - Match P75 - Conditional Match P90 - Preauth Vendor Unavailable P91 - Preauth Vendor Error P93 - Error P94 - Invalid Routing Number P94 - Invalid Account Number P95 - Bad Account
Wallets	The wallet type used for the transaction. Users can filter transactions by the following wallet types: Apple Pay Google Pay

Dex has a 2048 character limit for filters applied. If the filters applied to the data grid exceed the 2048 character limit, dex will display a warning message to inform the user to reduce the number of filters and try the search again.