Mag Card Reports

From Rts
Jump to: navigation, search

Contained below is a comprehensive list of all reports involving mag cards. These can be accessed by navigating to Reports -> Magcards -> REPORT NAME.


Card Details

Shows balance information of cards.

Number - Card Number
Issue Balance - Balance on the card when it was originally issued
Issue Date - Date card was issued
Last Debit Change Date - Last time money was removed from the card
Balance as of - Balance before the last transaction
Current Balance - Current balance of the card
Balance Date - Date used for current balance


GiftCardDetailReport.png


Daily Log

Shows all transaction types performed by cards within a time frame.

Log Types:
  • Debit - Money added or removed
  • Point - Loyalty points added or removed
  • Item Credit - Rewards item added
  • Item Redeem - item redeemed from card
  • Super Saver Sold - Super savers added to card
  • Super Saver Redeem - redeemed a super saver ticket from card
  • Clear Card - Card information cleared
  • Card Transferred - Card information transferred to another card


Rts reports magcards dailyLog.png


Report Info:
Card - Card number
Date Used - Date card was used
Amount - Transaction amount
Receipt - Receipt number
Type - Transaction type
Manual - If this was a manual transaction
Item - Item related to transaction
User - User involed with transaction
Expiration - Expiration of item added
Reason - Reason given for transaction


DailyLog.png


Mag Card Expire Summary

Shows information about cards that were last used before a specified date

Card Number - Card number
Balance - Current Balance
Last Used - Date card was last used


MagCardExpireSummary.png


Individual Log

Displays all card transactions for the specified card during the last year


Date used - Transaction Date
Amount - Tansaction amount
Receipt - Receipt number
Type - Transaction type (See above for list of transaction types)
Manual - If this was a manual transaction
Item - Item related to transaction
User - User involed with transaction
Expiration - Expiration of item added
Reason - Reason given for transaction


IndividualCardLog.png


Look Up Registered Card

This window enables the lookup of registered mag cards. The search can be performed by the name, address, zip code, or ID fields. Search entries are case insensitive. If multiple search entries are used, the returned card numbers must match all entries. You may update the customer's information on this screen as well.


LookupRegisteredCard.png


Member Information

Shows a filterable list of members and their registered info


Rts reports magcards memberInfo.png


Member Name - Name of member
Card Numnber - Card number associated with that member
Address Information - address information of member
Id Information - member id information
Date of Birth - members birthday
Email - email associated with that member
Email Authorized - Whether or not


Rts reports magcards memberInfo report.png


Online Gift Purchases

This is a log of online gift card purchases. It allows you to view data relating to each purchase and the ability to resend cards.


OnlineGiftPurchases.png


System Total

This window shows total values from all cards in the system

Number of cards - Number of cards in the system
Debit Total - Total dollar amount on all cards
Vaild Supers - Valid super savers across all cards
Expired Supers - Expired super savers across all cards
Valid Ticket Credits - Tickets on cards not yet redeemed
Expired Ticket Credits - Expired tickets on cards


SystemTotal.png