Block Actual Report (rep_actbb_p)

Prerequisite for Actual Business Block Rooms Report

This report compares booked room nights, revenue, and average rate with picked-up room nights, revenue, and average rate.

SELECTION CRITERIA

Property.
  1. When logged into a Property:

    1. The Property filter should be Visible, Required, and displayed at the top of the Parameter.

    2. The logged in Property should be passed (defaulted) to the Property filter.

    3. No other Properties are available for selection.

  2. When logged into a HUB:

    1. The Property filter should be Visible, Required, Multi-Select, and displayed at the top of the Parameter.

    2. The Property selected in the Report Property search filter should be passed (defaulted) to the Property filter.
    3. All Properties in the HUB will be available for selection.
  3. Mandatory when visible.

Stay Date Range. This field allows you to select blocks that have at least one stay day within the selected from and to date.
  1. From Date:

    1. The Date field with formatting based on the configured short date format for the logged in Property or HUB.

    2. This field filters on allotment dates (Stay Dates are the dates between the start date and the end date, for example, one).

    3. The value in this field must be earlier than or equal to the date in the Stay Date To Date field.

    4. No default value when inserting the report.

  2. To Date:

    1. The Date field with format based on the configured short date format for the logged in Property or HUB.

    2. This field will filter on allotment dates (the dates between the start date and end date, for example, one).
    3. The value in this field must be later than or equal to the date in the Stay Date From Date field.
    4. No default value when inserting the report.

Block Type. You must select one of the following values (select only one).

  1. Rooms:

    1. Radio button selection.

    2. Only one of these three values can be selected at one time.

    3. When Rooms is selected, only blocks that are not marked as Catering Only are returned.

  2. Catering:
    1. Radio button selection.

    2. Only one of these three values can be selected at one time.

    3. When Catering is selected, only blocks that are marked as Catering Only are returned.

  3. All:

    1. Radio button selection.

    2. Only one of these three values can be selected at one time.

    3. When selected, all blocks that meet the other filter criteria are returned.

    4. Default ALL when the report is inserted.

Block Status.
  1. The field is defaulted with the ghost text All Codes indicating that all Block Statuses are considered.

  2. The field is displayed with multi select LOV.

  3. After selecting the magnifying glass, open the LOV for Search and select Block Status with an option to select one or multiple Block Statuses.

  4. The list will display all Block Status codes and descriptions.

  5. After selecting Block Status code(s), pass them back to the Report Request Parameter screen.

  6. If multiple Block Statuses are selected, they will appear as comma separated values.

Rooms Owner. Select a room owner.
  1. The field is defaulted with the ghost text All Codes indicating that all Rooms Owners will be considered.

  2. The field is displayed with a multi select LOV.

  3. After selecting the magnifying glass, open the LOV for search and select Rooms Owner with an option to select one or multiple Owners.

  4. The list will appear with all Owner codes, Owner Name.

  5. If multiple properties are selected in the Property field, the list will display the Property code against each Owner.

  6. After selecting Owner code(s), pass the Owner Code(s) back to the Report Request Parameter screen.

  7. If multiple Owners are selected, they will appear as comma separated values.

Change Date Status.
  1. The field is defaulted with no value.

  2. The field is displayed with single select LOV of all Block Status codes and descriptions.

  3. After selecting the magnifying glass, open the LOV for search and select Block Status with the list of all Block Status codes and descriptions.

  4. You have the option to filter a specific Block status. Only one Block Status can be selected from the LOV.

  5. After selecting Block Status code(s), pass the selected Block Status code(s) back to the Report Request Parameter screen.

Sort Order. The following options should be available. Make at least one selection.
  1. Sort by Rooms Owner – renamed from Sales Manager.

  2. Sort by Block Status – renamed from Business Status.

  3. Sort by Start Date – renamed from Arrival Date.

  4. Sort by End Date – renamed from Departure Date.

  5. Sort by Catering Owner – renamed from Catering Manager.

Currency. Visible when the application parameter Rate Management >Ability to Quote Rates in Foreign Currency is Active.

REPORT DATA

For each booking, the report prints the following data:

  • The account name and block, as well as the block ID, current block status, selected change status and status change date, rooms owner, and catering owner of the block.

  • The block start and end date and block currency.

  • The current room nights, revenue, and average rate (printed in the top row of the revenue box).

  • The actual picked-up room nights, revenue, and average rate (printed beneath the current figures).

  • The calculated difference as a third line beneath the actual values.

A sub-total by selected first sort group is printed, as well as a total for the whole report.

Note:

The current block rates are calculated from the value as it appears in the room grid of the booking regardless of any included taxes and package elements, if applicable. The picked-up rates and revenue are NET of taxes and packages. You should keep this in mind when comparing these values.