How do I identify the ticket from the transaction number used in my detailed data file?
In order to maintain the integrity of the data being sent to the QLD government in the detailed data file, we made the decision to use the system identifier for the transaction or the original transaction if its a replacement. This number is not easily identifiable in Mandalay CS and can make it a bit difficult to locate the ticket when you need to make corrections. It is possible to search for the ticket using a report in WBR or use the detailed data file to identify the license plate and date out of the transaction. This article explains how to use the detailed data file and how to setup a report in WBR to locate the transaction using the transaction number reported to the government.
Using the Detailed Data File
The third column in the details data file is the Transaction Log ID in Mandalay CS. If the government report issues in your submission they will reference this number. When they do the fastest way to identify the transaction is to locate it in the detailed data file and then use the License Plate and Date time as filters in Ticket History found in Mandalay CS Ticketing.
If the number shows in red then this means its a replaced transaction and you should select this ticket first and then navigate to the replacement transaction use the transaction audit buttons.
Create Report
Alternatively a report in WBR can be created to allow for this number to be searched for.
Access your WBR and create a new custom report.
General Details
Set the general details to anything you prefer buy make sure to use the Ticket Details view.
Columns
Add the TransactionLogID and Ticket Number to the columns list and ensure the columns have a width of at least 30.
Add any other fields you feel are necessary.
Filters
Skip the Sorting tab and move to the filter tab and tick Allow Filter against the TransactionLogID column.
View the Report
You can skip the rest of the WBR report creating process and just press the View button.
Locating a ticket by transaction log ID
From the report viewing page use the edit option on the TransactionLogID report critieria then do the following.
- Press the add button.
- Enter the transaction log ID in the value field presented.
- Press Ok
In some cases the transaction log ID may be to long for the field and it will keep defaulting to the maximum value possible. In these cases you should use the first option presented in this article and use the detailed data file to locate the transaction.
Multiple Transactions
If you wish to locate multiple transaction then you should select the OR option at the top of the transaction log ID criteria entry screen and add a new entry for each transaction you wish to locate.
Locate the ticket
Press the generate report button and a the results will return with the list of ticket numbers and any other details you have added to the report..
