Support Centre

Report Example 4: Transaction Code Usage

Updated on

The following article provides an example of how to create a report using the Report Wizard.

Report

The Transaction Code Usage Report can help with finding when specific Transaction Codes were used in the PMS.  It will show when the code was used, whom the posting was made by, and what reservation it posted to.

This report will be Based On Transactions.

Report
Header

Fields

Fields

Filter

The filter expression is set to search for a specific Transaction Code that will need to be entered when this report is run. It will then filter based on the date the transaction was posted.

Transactions.[Tran Date] >= '{d|Date From:}' AND  Transactions.[Tran Date] <= '{d|Date To:}' AND  Transactions.[Tran Code] = '{s|Enter Transaction Code:}'

Filter

Columns

Columns

Group By

Group By

Order By

This report does not require to be ordered in any specific format.

Order By

Transaction Code Usage Report

The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).

Transaction Code Usage Report
Previous Article Report Example 3: Room Nights & Revenue by Room Type
Next Article Report Example 5: Unassigned Rooms Report
Have a question for us? Submit a Support Case