Detailed Product Description

Overview:

• e-Rewards can be used to provide web based reports. it leverages latest Microsoft ASP. Net and Reporting Service Technology to offer web based reporting functionality. Role capability can be defined and let people with different responsibility see the most relevant reports tailored for them.
•  e-Rewards Reports is bundled with iBonus Server package. Microsoft SQL Server 2005 and Microsoft Reporting Services is required. If Microsoft SQL Server is not expected to be used in the iBonus System, the report application bundled with iBonus Server can be used for generating report without any further development.

Available Reports:

Reports for Administrator:

• Number of blacklisted staff cards

• Number of non expired card which is blacklisted

• Number of expired card which is blacklisted

• Number of replace which can be grouped by month

• Number of pending and authorized requests

• Number of active (not-expired) and inactive (expired) user

• Terminal status which shows whether all terminals are online

• Number of records in each table

• Number of member card which is issued at different Terminal

Reports for Financial Controller:

• Total cash from member retained
• Cash paid by member in advance in any particular month
• Cash Clearing by Branch
• Sum of the bonus of all member cards retained
• Bonus point monthly balance in any particular month
• Summary of balance prepaid and bonus by branch which can be used for clearing

Reports for Financial Controller:

• Average days from last visit by Accumulated spending
• Purchase frequency by Accumulated spending
• Customers reload range per transaction
• Sales by Branch
• Daily Sales
• Hourly Sales
• Monthly Sales
• Weekly Sales
• Yearly Sales
• Number of transaction by month
• Number of transaction whose amount is within a specified range
• Transaction Detail
• Member Detail

Reports for Branch Manager :

• Branch sales by month
• Replace card detail
• Repair card detail
• Renew card detail
• Replace count of branch
• Cash collected by Terminal
• Terminal Status

Reports for Branch Operator:

• Cash collected
• Transaction completed
• Expiry date and final card balance

Reports for Member:

• Card balance
• Transaction history
• Renew, repair and replace status