The following article provides an example of how to create a report using the Report Wizard.
Report
This report shows all the reversals & adjustments made in the PMS for a selected time period.
Header
Fields
Filter
This filter searches for transactions during specific transaction dates, where the amount is less than $0.01.
Transactions.[Tran Date] >= '{d|Date From:}' AND Transactions.[Tran Date] <= '{d|Date To:}' AND Transactions.[Amount] <= 0.01 AND Transactions.[Tran Type] = 'CHG'
Columns
Group By
Order By
Adjustments on Charges Report
The report will now appear in the Report Wizard (Reports > Report Wizard) as well as the Custom Reports (Reports > Custom Reports).
