Gift Card / Store Credit History

Item

Filter by item. Select a gift card or store credit item. Optional if a Serial/Card # is provided.

Serial/Card #

The serial number or card number to look up. Supports partial matching (case-insensitive). Either this or Item is required.

Range

Pre-set date range (All, Today, This Week, This Month, etc.). Selecting a range automatically sets the From and To dates.

From

Start date filter. Transactions before this date are excluded from the list but contribute to the Beginning Balance.

To

End date filter. Transactions after this date are excluded entirely.

Store

Filter by store where the transaction occurred. Leave blank to show transactions across all stores.

The list shows all transactions affecting the card's value, in chronological order:

Transaction List

The list displays all transactions matching the selected filters.

Transaction #

The source transaction number. For initial load rows, this is the transaction that created the serial.

Date

Post date of the transaction.

Store

Store where the transaction occurred.

Type

Transaction type:
• Initial Load — The activation/creation of the card with its initial value
• Invoice — A sale that redeemed value from the card
• Return — A customer return that refunded value back to the card
• Top Up — A tender adjustment that added value to the card

Number

The serial/card number.

Amount In

Value added to the card (initial loads, returns, top-ups).

Amount Out

Value removed from the card (invoice redemptions).

Double-click any row to open the source transaction for editing.

The balance bar at the bottom provides a financial summary:

Beginning Balance

The card balance as of the From date. Includes all activity prior to the date range (initial loads minus redemptions). Shows 0.00 when Range is “All”.

Total In

Sum of all Amount In values within the date range (initial loads + returns + top-ups).

Total Out

Sum of all Amount Out values within the date range (invoice redemptions).

End Balance

Calculated as Beginning Balance + Total In − Total Out. This is the card's remaining value.

The history is assembled from two data sources:

1. Initial Amount (i_s_extra) — The “Initial Amount” metadata stored with the serial record when the card was activated. This appears as the “Initial Load” row.
2. Tender Transactions (gltx_tender) — All posted, active tender lines where the serial number matches. Negative amounts represent value flowing back onto the card (returns, top-ups); positive amounts represent redemptions (sales).

Refresh

Re-queries the database with the current filter settings and recalculates all balances.

Print

Generates a printable report of the current history including all title information, balance summary, and transaction rows.

Close

Closes the history window.