Rate Override .ng
Rate Override
Report Description: The Rate Override Report compiles a comprehensive list of all rate overrides executed on a specified date. It includes transaction details such as the modification date, stay date, time, confirmation number, check-in and check-out dates, guest name, number of adults and children, room number, charge type, adjustment code, sold rate, new rate, rate plan, market segment, override amount, username of the user who performed the override, and any remarks.
Date Range: Data will be rendered for the date selected up to 365 days in the past or future
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Modification Date | Date of the rate override transaction | Not Applicable | Not Applicable |
Stay Date | Date of the guest's stay | Not Applicable | Not Applicable |
Time | Time when the rate override was executed | Not Applicable | Not Applicable |
Confirmation Number | Unique identifier for the reservation confirmation | Not Applicable | Not Applicable |
Check In Date | Date of guest check-in | Not Applicable | Not Applicable |
Check Out Date | Date of guest check-out | Not Applicable | Not Applicable |
Guest Name | Name of the guest associated with the reservation | Not Applicable | Not Applicable |
Adult(s) | Number of adult guests | Not Applicable | =sum(adults) |
Children | Number of child guests | Not Applicable | =sum(children) |
Room Number | Assigned room number | Not Applicable | Not Applicable |
Charge Type | Type of charge associated with the rate | Not Applicable | Not Applicable |
Adjustment Code | Code representing the adjustment made | Not Applicable | Not Applicable |
Sold Rate | Original rate before the override | NO | Not Applicable |
New Rate | New rate applied after the override | NO | Not Applicable |
Rate Plan | Plan associated with the rate | Not Applicable | Not Applicable |
Market Segment | Segment to which the reservation belongs | Not Applicable | Not Applicable |
Override Amount | Difference between the new and sold rates | NO | =sum(sold rate) - (new rate) |
Username | Username of the user who performed the override | Not Applicable | Not Applicable |
Remarks | Additional notes or comments regarding the override transaction | Not Applicable | Not Applicable |
Misc Report Information:
Available Features:
Export: ability to download and save the file into an alternate format.
Filter: filter a range of data based on criteria defined by the user.
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Group By: ability to group data All, Confirmation Number, Charge Type, Adjustment Code, Username
Pie Chart: ability to view grouped data in a Pie Chart view.
Available Configuration:
User Preferences: allows the user to customize their report view by repositioning or removing columns.
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
Not Applicable