Group Room Reservation Sheet (Sample_GRMRES_Sales_STD.Rep with Sample_GRMRES_Sales_STD.fmx)

The Group Room Reservation Sheet report details all information about a group block including linked accounts, contact and agent information, room grid with rates and revenue, all major block details, catering event information, sales activities, and deposit information. Additionally, you can include all notes associated with the block and events.

Report Parameters

• Property: Enter or select the property. You can select multiple properties from a Hub location.

• Filter:

  • Start Date. Enter or select a date.

  • Block. Click to search and select a block from the list. The internal booking ID appears in the search field.

    Note:

    When selecting a Master Block, Master Allocation, or Master Tour Series, all sub-booking information prints in the Room and Event sections. If you select only a sub-booking, then only the data for that business block is output.

  • Block Status. Select a block status from the list be included in the report.

  • Event Status. Select event statuses from the list to be included in the report. (Available when the Simple Events or Catering Events OPERA Control is active.)

• Notes:

  • Print Internal Notes. Select the check box to include notes marked as Internal.

  • Print External Notes. Select the check box to include notes marked as External.

  • Types. Select note type(s) from the list.

• Room Grid Type:

  • Original. Select the check box to output the Original room grid.

  • Pickup. Select the check box to output the Pickup room grid.

  • Current. Select the check box to output the Current room grid.

  • Contract. Available when the OPERA Control for Block Contract Grid is active.

• Room Rates:

  • Hide Rates. Select the check box to suppress the output of rate amounts.

  • Print Rooms with Rate and No Inventory. Select the check box to display room types with a rate but no rooms booked. If not selected, room types with a rate but no rooms booked are not included.

• Display (Output):

  • PMS Room Types. Select to output the inventory room types.

  • Room Pools. Select to output the room pools (Available when the Room Pool OPERA Control is active.). For more information, see: Configuring Room Pool.

  • Summary. Select the check box to include a summary of the selected room grids. If selected, a total line for each selected grid type prints, showing only the number of booked rooms per day irrespective of rates or room type. This area prints only if you select at least one grid type to print on the first filter page.

  • Information. Select the check box to include all codes, dates, and miscellaneous information found in the Block Details panel.

  • Activities. Select the check box to include activities linked to the selected business block. (Available when Oracle Hospitality OPERA Cloud Service, Sales and Event Management Standard Edition or Oracle Hospitality OPERA Cloud Service, Sales and Event Management Premium Edition is active.)

    • Activity Notes. Select the check box to include the activity notes.

  • Room Header Display:

    • Code. Select to output the code.

    • Description. Select to output the description.

    • Both. Select to output the code and the description.

  • Extended (multi-byte) Characters. Select to output the alternate name for profiles linked to the block. (Available when the Multi-Language OPERA Control is active.)

  • Events. Select the check box to include catering event information. If the event status filter is used on the first filter page, only events of the selected statuses will be included. (Available when the Simple Events or Catering Events OPERA Control is active.)

  • Address Type. Select an address type other than the primary address to output all linked profiles. If no address of that type is found for one of the profiles attached to the selected bookings, the primary address outputs instead.

• Deposits:

  • Print Deposits. Select the check box to output deposit information. You must have a deposit request for any deposit information to output.

  • Sort By:

    • Type. Select to sort by deposit type.

    • Date. Select to sort by deposit due date.

• Currency. Select a currency to convert revenue amounts based on exchange rate setup (available when the Ability to Quote Rates in Foreign Currencies OPERA Control is active).

  Note:

  Deposit Requests, Payments, and the Due Amount are always reported in your property’s base currency irrespective of the currency selected.

Report Output

Account and Contact Information. Includes the primary account name, address and primary website, primary contact name and primary email for the contact, relationship to booking and address, secondary contact name, relationship to booking and address, and primary agent name and address. The address/phone information for each profile uses up to three lines across the page. If a specific profile is not used, these three lines are suppressed and the subsequent space allotted for this information is collapsed.

Booking General Information. Includes all codes (market, source, booking type, and so on), dates and other information from the business block rooms, catering, and details sections. This section also may include the following details for the booking when the Oracle Hospitality OPERA Cloud Service, Sales and Event Management Premium Edition is active:

• Ranking. (Available when the Block Ranking OPERA Control is active, which is available only with the Oracle Hospitality OPERA Cloud Service, Sales and Event Management Premium Edition). You can apply a ranking code to a business block to indicate the rank (or priority) of the business block. For more information, see: Configuring Block Rankings

• Conversion. (Available when the Block Ranking OPERA Control is active, which is available only with the Oracle Hospitality OPERA Cloud Service, Sales and Event Management Premium Edition). You can apply a conversion value to a business block to indicate a percentage of likelihood that the booking will turn definite. For more information, see: Configuring Block Conversions

• Non Compete and NC Industry. (Available when the Block Ranking OPERA Control is active, which is available only with the Oracle Hospitality OPERA Cloud Service, Sales and Event Management Premium Edition). Non compete means that no competing accounts (accounts having the designated NC Industry code) should be booked at the same time as this block. You can apply the non compete flag to all or selected dates of the flagged block. If all dates are covered, ALL appears here. If only selected dates for the booking are non compete, SOME appears and an additional Dates area shows the dates. Otherwise, NONE appears.

• Rate Protect.(Available when the Block Ranking OPERA Control is active, which is available only with the Oracle Hospitality OPERA Cloud Service, Sales and Event Management Premium Edition). Rate protect means that no other groups should be booked using rates lower than those assigned to the block that is flagged as rate protect. You can apply the rate protect flag to all or selected dates of the flagged block. If all dates are covered, ALL appears here. If only selected dates for the booking are rate protect, SOME appears and an additional Dates area shows the dates. Otherwise, NONE appears.

Current Room Grid Information. Dates output across the page, and room types/occupancy levels as rows. The total number of booked room nights as well as revenue and average rate appear in this area.

Summary Section. If summary section is flagged on the filter screen, a summary of total number of rooms booked per day for each grid will output after the grid details.

Notes and Business Block Info. All selected business block notes output after the summary section on the left hand side of the report. On the right hand side beside the notes, another box containing additional information on overall owner, rooms owner, and catering owner outputs if the business block is lost or canceled. The details, including reason lost and destination lost to, also output in that Business Block Information box.

Events. Catering Event information is output if Events are selected to be included in the report parameters. Details of these events include: Event Type, Function Space and Function Space Rate, Set-up Style, Event Date and Event Time, internal Event ID, and Number of Attendees per Event. The Door-card text (Post As) for each event also outputs underneath the Event Type.

Note:

If no catering events are associated with the selected Business Block, this section is suppressed.

Deposit. Deposit information appears next if deposit requests are attached to the booking and/or deposits are posted to the booking already. This section outputs only if the appropriate flag is checked on the filter form. The sequence for how the deposits are output is governed also by the report parameters, depending on whether you selected print deposit by type or by date. If you select by type, a sub-total outputs after each type. The information output for each deposit includes: deposit type (rooms, catering, all), percentage of total revenue (if entered), deposit amount requested, due date, amount paid, due amount, and description/comment (if entered). Totals of all amount fields output as a summary line below all separate deposit records.

Activities. Displays the following information for activities associated with the selected business block: Activity Start Date, Start and End times, Activity Type, Purpose, Owner, and whether or not the activity is complete.

Note:

If no activities are associated with the selected Business Block, this section is suppressed