OpenEdge Transaction Query
What is the Transaction Query?
The Transaction Query gives you a way to research payments and get payment information without the OpenEdge View. It can be used to research open carts on the Point of Sale or quickly see if a transaction settled without using the OpenEdge View.
Where can I find the Transaction Query?
The OpenEdge Transaction Query is found in the Payment Processing module under the Payment Accounts tab. There’s a Transaction Query for Card Present and not Present.
How do I use the Transaction Query?
You can search by Transaction or Order Id.
- Transaction ID is a 12-digit number
- Example: 000000078378
- Order ID’s always have the Cart Id or Order Number built in them. However, they do come in different formats depending on where the order was made.
- Example from the POS: 88883333.2022100500004.1
- Example from the Backend: 7499.0.220928134928_856
- Order Id’s can very in the way they look when the order source. Stick to using the Transaction Id for Card not Present transactions.
How do I find the Transaction and Order ID’s?
For orders made on the Point of Sale, the ID’s will be found in the Basket Event History.
- In the Basket Event History Order ID is called “reference_id” and the Transaction ID is called “sale_id” or “auth_id”
- In a circumstance where there isn’t a “Save payment in OrderPort system” response, you may need to look in the “body log” of a “Log payment transaction” response.
- Click “body log” à open the Notepad file when it downloads à find the “reference_id”, “sale_id”, or “auth_id” à input the Id into the Transaction Query.
Order ID:
Transaction ID:
For orders made on the Backend, you will need to go to the Customer Service à History à click on “api resp” à Find the “transactionid” or “orderid”
What information can I get from the Transaction Query?
Transaction Query shows you most of the information that would be on a transaction receipt. For example, see the screenshot below:
