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

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

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

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

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

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

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