How to monitor voucher usage
The system provides two methods for viewing the usage of vouchers. There is a tab in the Administration program plus there are WBR system reports and a couple of WBR views available so that reports can be run to monitor usage.
The following article explains how to use both methods.
Electronic ID Tab
Start the Administration program and go to the Electronic ID's tab and change the filter type to Barcode.
From this tab you can see all bar codes processed in ticketing and also any that have been scanned through the Scan function on this page. The system will break out each part of the code and present it in the appropriate fields.
Code: This is the raw code as scanned into the system.
Reference: This is the reference part of the code.
Limit: This indicates the number of times that a voucher can be used as coded. If the limit part is not included then the limit defaults to 1.
Used: This field shows the number of times this bar code has been used.
Payment Type: This is the payment type that is indicated by the type part.
Voucher Season: This shows the season category that is associated to the bar code.
Scanning codes in Administration
It is possible to scan a voucher code in the administration program so it can easily have its parts reviewed.
- To do this click on the scan button at the bottom of the screen.
- Once pressed for the first time you will be presented with a list of devices that can accept electronic ID's, this could be bar code scanner, dallas tag or RFID readers. When you select your bar code scanner the Scan button will go yellow which means the system is ready to accept scans.
- Scan a code with the scanner to add it to the list of bar codes. While the scan button is yellow you can continue to scan other bar codes.
- Press the Scan button to stop using the scanner to in Administration.
Web Based Reporting Voucher Reports
The Web Based Reporting system includes 6 system reports that can be used to monitor voucher usage.
Resident Voucher Usage
Resident Voucher Usage by Season
Season Location Voucher Statistics
Season Voucher Statistics
Voucher Usage
Voucher Usage Statistics
The Resident Voucher reports are based on barcodes that are listed in the Electronic ID's tab. This means they can show barcodes that have been scanned in Admin but have not yet been used. The other reports derive their data from transaction records so will only report on vouchers used in Ticketing.
Resident Voucher Usage Reports
There are 2 Resident Voucher Usage reports available.
Resident Voucher Usage
This report shows each bar code that has been scanned by either the ticketing system by an operator when a client uses a bar code or by the Administration system when an administrator scans a code. If the resident is reissued a bar code with a new issue number then it will appear under the residents reference number.
Resident Voucher Usage by Season
This report provides a summary of each residents usage of bar codes through out a season. This is an aggregated value and will include reissued codes and multiple types.
Season Voucher Statistics
The 2 reports available for providing statistics on voucher seasons.
Season Location Voucher Statistics
This report provides a summary of the number of vouchers used from a particular source location during a season.
Season Voucher Statistics
This report is similar to the one above but it is not grouped by source location.
Voucher Usage Reports
These reports are based on vouchers redeemed during a specific period.
Voucher Usage
The number of vouchers redeemed of a period, including the statistics about how many times vouchers were redeemed, broken down per suburb.
Voucher Usage Statistics
This is that same as the Voucher Usage report by also grouped by source location
WBR views available for advanced vouchers
Voucher Details
Listing of the advanced vouchers recorded in the system.
Name Description
Voucher The full voucher code include season, resident, product and total use used allowed
Reference The resident ID encoded in the voucher
UseLimit Indicates the maximum number of times a multiple user voucher can be presented
UseCount Indicates the number of times a multiple user voucher has been presented
PaymentTypeID Mandalay unique key for the payment type
PaymentTypeName Preset or customer assigned payment type name
PaymentTypeCode Preset or customer assigned payment type code
VoucherSeasonID Mandalay unique key for the voucher season
VoucherSeason Customer assigned voucher season name
VoucherSeasonCode Customer assigned season code
VoucherCancelled Indicates that the voucher has been cancelled
Voucher Season Stats
Statistics that allow users to determine the popularity of advanced vouchers.
Name Description
NumberofVouchers The number of vouchers that were are in this category
UseCount Indicates number of times a multiple user voucher was redeemed
SourceLocationID Mandalay unique key for the source location
SourceLocation The origin of the waste that the voucher was redemmed against suburb or other external location as configured in administration
PaymentTypeID Mandalay unique key for the payment type
PaymentTypeCode Preset or customer assigned payment type code
PaymentTypeName Preset or customer assigned payment type name
VoucherSeasonID Mandalay unique key for the voucher season
VoucherSeason Customer assigned voucher season name
VoucherSeasonCode Customer assigned voucher season code
Voucher Usage
Details of voucher use (does not include ticket information).
Name Description
Date Indicates date voucher was redeemed
Voucher The full voucher code include season, resident, product and total use used allowed
Reference The resident ID encoded in the voucher
UseCount Indicates number of times a multiple user voucher was used this time
UseLimit Indicates the maximum number of times a multiple user voucher can be presented
TotalUseCount Indicates number of times a multiple user voucher has been presented
SourceLocationID Mandalay unique key for the source location
SourceLocation The origin of the waste that the voucher was redemmed against suburb or other external location as configured in administration
PaymentTypeID Mandalay unique key for the payment type
PaymentTypeCode Preset or customer assigned payment type code
PaymentTypeName Preset or customer assigned payment type name
VoucherSeasonID Mandalay unique key for the voucher season
VoucherSeason Customer assigned voucher season name
VoucherSeasonCode Customer assigned voucher season code
Voucher Usage Details
Details about transactions paid for using advanced vouchers.
Name Description
Date Indicates date voucher was redeemed
DateOut Date the ticket / transaction was completed
TransactionLogID Mandalay unique key for the transaction / ticket
TicketNumber Unique receipt / ticket number printed on the ticket
LicensePlate License plate of the vehicle
Notes Customer assigned additional information
ClientID Mandalay unique key for the client
AccountNumber The account number of the client that used the voucher
Client The name of the client that used the voucher
SourceLocationID Mandalay unique key for the source location
SourceLocation The origin of the waste that the voucher was redemmed against suburb or other external location as configured in administration
ProductID Mandalay unique key for the product
ProductCode Customer assigned product code
Product The product the voucher was used to purchase
PaymentTypeID Mandalay unique key for the payment type
PaymentTypeName Preset or customer assigned payment type name
PaymentTypeCode Preset or customer assigned payment type code
Voucher The full voucher code include season, resident, product and total use used allowed
Reference The resident ID encoded in the voucher
UseCount Indicates number of times a multiple user voucher was used this time
UseLimit Indicates the maximum number of times a multiple user voucher can be presented
TotalUseCount Indicates number of times a multiple user voucher has been presented
VoucherSeasonID Mandalay unique key for the voucher season
VoucherSeason Customer assigned voucher season name
VoucherSeasonCode Customer assigned season code
VoucherCancelled Indicates that the voucher has been cancelled