Skip to main content

Transactions

The Transactions tab provides a history of transactions associated with the member, along with controls to filter the list or view details for any transaction. The view displays all loyalty transactions for the member for up to the past 24 months and provides an explanation for balance increases and decreases. The agent can filter by start and end dates to find specific transactions.

There is no explicit limit on the quantity of rewards a member account may hold. However, there is usually a client-determined limit on the rewards that can be redeemed in a given period. If the number of points or rewards exceeds the maximum, those maximum values are displayed in the Redeemable Household and Redeemable Value shown in the header of the member page. This limit is also reflected in redemption transactions.

There are also limits on the maximum number of points that customer service agents can add or subtract in a single transaction through discretionary credits, depending on the agent's role and permission levels.

If an unregistered account is merged into the current user's active account, the transactions from the unregistered card are added to those in the active account.

List of transactions​

The main part of the tab shows a list of transactions involving the member. By default, a maximum of 20 transactions are shown in the list, but this can be changed using the Show selector in the lower corner of the tab. The details for each transaction include some or all of the following, depending on the transaction type.

Heading information:​

  • Date and Time stamp: The date and time when the transaction occurred. The time zone may also be shown.
  • Channel Detail: The channel through which the transaction occurred (for example, "POS/7426" indicates a point-of-sale transaction at store 7426, or the transaction occurred through the "SYSTEM").
  • Business Unit: The business unit (if any) associated with the transaction.
  • Transaction Type: For example: Activity (such as member registration), Ad Hoc Redemption (redemption provided to all specified members), Ad Hoc Rewards (rewards processed for all specified members), Adjustment (to correct a rewards balance), Balance Expiry (when the account balance expires), Discretionary (to award points, for instance, for goodwill), Finalize (completion of an in-store transaction, may include other transaction types), First-In First-Out (FIFO) (expiry of points), Points Transfer (to another member), Post Purchase Earn (PPE, adjustment when a card number wasn't available for the original transaction), Purchase (when a buying transaction is executed), SAF (a temporarily stored transaction sent after an in-store transaction when the network connection isn't available), Scheduled Redeem (redemption on a set date), or Tier Reward (rewards associated with an achieved tier).
  • Transaction ID: A unique identifier for the transaction.
  • Amount: The number of reward credits in monetary value involved (which may be positive or negative).
  • Points: The amount of points involved (which may be positive or negative).

Selecting a transaction reveals its in-depth details. These may include the following, depending on the transaction type:

  • Processed on date and time stamp
  • Card Number: Unique card number associated with a loyalty card used for the transaction
  • Internal Transaction ID: Unique identifier for the transaction
  • Void Transaction ID: Used for a void transaction
  • Transaction Status: Such as Completed
  • Issuer ID: Identifier for the issuer of a payment card
  • Payment Card(s): Cards used for payment and the associated partner links (identifiers for the partners whose payment cards are linked for transactions)
  • Employee Discount Applied: Yes or No
  • Redeemer ID: Business unit for a redemption
  • Price Matrix Applied: A code for the price matrix applied
  • Spend Details: Shows cart total and sometimes eligible total (both in dollars), including a link to show card details (also in dollars) and possibly a link for catalogue redemption details if the transaction involves a redemption using a catalogue item
  • Sender Info: If points were transferred, includes the amount of points and details of the sender (such as first name, last name, email, and so on)

Depending on the transaction type, a transaction may contain details of a reward issued for it. Details of the reward can be seen by navigating to the Reward Summary section in the Transaction details and selecting the Click to view details button. Possible details to be seen include:

  • Base earn and/or bonus earn
  • Balance Expiry: If applicable, the quantity of rewards removed from the account upon expiry
  • Expiry: Applicable if points are set to expire at the end of a period
  • Redemption amount (and, if from a household, details of redemption contribution showing each household member's share)
  • Reason Code: Any messages that further describe the transaction. For example, if any or all expected points were not rewarded due to a rewards cap for that period (month, quarter, or year depending on the client's requirements), the message shown is: Rewards limit reached
  • Non Points Bonus Earn (Dollar): Represents real-time monetary discounts (such as $ off or % off) applied directly at the POS during checkout, rather than points.
  • Redemptions: Represents points redeemed and the amount of monetary value that was redeemed in the process.
  • Redemption Contributor (LoyaltyId): Represents a household member whose points are drawn upon when a household-level redemption occurs.

Filtering transactions in the list​

  1. From the top menu of the Console, select Membership > Member Search. Select a search method and enter the required information. Click Search, then click the record returned to open the member details page.

  2. In the vertical menu, select Transactions.

  3. Click Filters in the upper right corner of the Transactions tab (availability of this button depends on configuration).

  4. Select the type of filtering (all, two, or one of the following options may be shown depending on configuration):

    • To filter by date, enter a date range by selecting a start date and time in the first date selector (click the calendar button) and an end date and time in the second date selector. Both must be selected for the filter to return results. If only one is selected, an error message appears for the other and no results are returned.
    • If enabled, to filter by external transaction identifier, enter the external (client) transaction ID value in the field provided. If this field is displayed but left empty, all transactions are returned (subject to other filter settings) regardless of whether they have an external transaction identifier.
    • If enabled, to filter by transaction type, select the value in the filter window. The available values are determined by configuration settings but may include values identifying different transaction types such as Adhoc Redeem, Finalize, SAF, and PPE.
  1. Click Apply Filters. Any transactions that meet the criteria are shown in the list.

To clear any filter settings, click Clear in the filters window.

Viewing Transaction Details​

To view a member's transaction details:

  1. In the member's profile, click the Transactions tab.
  2. Select a transaction to view its details.
note
  • For Finalize transactions, the Price Matrix Applied is included to indicate the formula used (E = Employee, R = Regular, or a customer code may apply).
  • For Discretionary, Activity, Points Transfer, or Points Expiry transactions, the loyaltyId (card number) doesn't appear as there is no card number associated with these transaction types.
  • If the client uses a unique external ID or order ID for the transaction that the member needs when interacting with the client's service desk, it is also included in the transaction details for Finalize, SAF, Void, Adjustment, PPE, and in the transaction history.
  • If the member has reached their points earning cap for a given period, a Reason Code appears on the transaction page with the message "Reached rewards limit." The transaction reflects the provisions made to comply with the cap, which may include awarding zero points if the member is already at the cap, or awarding fewer points to bring the member up to the cap.
  • For Adhoc Redeem transactions only, an additional link may be provided in the expanded transaction details section at the bottom (the link is labelled Click here for payment details). Clicking this link opens a window with additional details about the transaction such as the batch ID, a reference code, the payout amount, and details about the event (event type, event date, and event details). The exact information shown depends on the payment status: Submitted, Deferred, Cancelled, Error, or Completed.

Examples of finalize transaction and cart details​

Exporting transaction histories​

note

This functionality can only be used by users with the correct permission enabled. Contact your Technology Solutions Architect (TSA) for more information.

This feature enables users to pull a member's complete transaction history directly from the Console, whether it consists of a few transactions or hundreds.

To export all transactions for a specific member:

  1. Navigate to the member details page.
  2. Click the Transactions tab. A list of the member's transactions is displayed.
  3. Click Export View. This button only appears if you have the correct permissions enabled. The Transaction History Export window opens.

  1. In the Transaction History Export window, click Generate Export. File generation begins and the status is shown as PROCESSING.

    note

    Depending on the number of transactions, this process may take some time. The file doesn't include any transactions that are currently on hold, even if they are shown in the Console.

  1. You can close the Transaction History Export window and return later (by clicking Generate Export) to check the status. The status changes from PENDING to PROCESSING to GENERATED as the file is generated.

    note

    If you click Generate File again within the same 24-hour period, no new file is generated — the most recently generated file is returned instead.

  1. When the file is ready (status shows GENERATED), click the Action menu and select Download. A message confirms that generation of the history has been initiated.

    note

    If the status changes to FAILED, the file won't be generated. Close the window and try again. Report any issues to your Technology Solutions Architect (TSA).

  1. Provide a local download location and file name, click Save As, choose where you want to save the file, and click to confirm. The CSV file is saved to that location.

The file can be generated once per day. To access a generated file, click Generate Export, then select Download from the menu.

Last updated on