1. User Guide
  2. OPERA Cloud
  3. Reports
  4. Report Descriptions
  5. Blocks and Groups Reports
  6. Contract Merge Report (Based on Sample_Cont_Merge.RTF with Rep_Cont_Merge.FMX)

Contract Merge Report (Based on Sample_Cont_Merge.RTF with Rep_Cont_Merge.FMX)

Prerequisites for Contract Merge Reports

The Contract Merge Report (rep_cont_merge.rep) outputs group room block and catering event details. Although Contract Merge is mainly used to produce group contracts, there is a much wider scope of possibilities for this customizable report. It is possible to customize sample_cont_merge into multiple report templates linked to the parameter form. The additional options to define which room grid and event template merge into the document and the possibility of merging deposit information make the report very flexible

In multi-property operations the Contract Merge Report can generate details for blocks and events in multiple properties.

Note:

When you output events belonging to a sub-block, all events output on one contract as if they were one booking; not as separate contracts.

Report Parameters

Property. If your location is a property, the property code appears automatically. If your location is a hub, select one or more properties from the list.

Block. Click to select the block to include in the report.

Event Property. Select or confirm the property name.

Event Status. (Available with Simple Events or Catering Events OPERA Control). Select the statuses of events to include in the report.

Print Account. Defaults to the block’s default print Account. The Linked Profiles dialog opens enabling you to select other accounts or contacts linked to the selected block.

Print Contact. When a block is selected in the Block filter, the print contact defaults to the block's default Print Contact. The Linked Profiles dialog opens enabling you to select other accounts or contacts linked to the selected block.

Grid Type. Select one of the following options from the list:

  • Current

  • Contract

  • Pickup

Event Templates. Select one of the following values from the list:

Full Event Templates (when the Catering Events OPERA Control is active)

  • Template1. Date, Time, Event Name, Space Name, Attendees.

  • Template2. Date, Time, Event Name, Attendees, Function Space Rental.

  • Template3. Date, Time, Event Name, Space Name, Attendees (Double Spaced).

  • Template4. Date, Time, Event Name, Space Name, Setup Style, Attendees, Food Revenue, Beverage Revenue, Rental Revenue, Other Revenue. The amounts are calculated from the revenue types that have been selected on the report parameters for each column.

  • Template5. Date, Time, Event Name, Space Name, Setup Style, Attendees, Function Space Rental.

  • Template6. Date, Time, Event Name, Space Name, Setup Style, Attendees, F and B Minimum.

  • Template7. Date, Time, Event Name, Space Name, Attendees, Resources, and Price. Price is based on the Total Expected Revenue, even if the Use Forecast Only check box is selected on the Event Search or Event screen (Available when the Event Resources OPERA Control is active).

  • Template 8. Similar to Template #7, but with less resource details. This template includes the Date, Time, Event Name, Space Name, Attendees, Limited Resources, and Price. Price is based on the Total Expected Revenue. (Available when the Event Resources OPERA Control is active).

    Catering Package Events in Template #8:

    • Item Rate Codes will NOT print.

    • Included Items will NOT print.

    • Additional Items and their Rate (but not Rate Code) will print.

    • Included Menu Names will print; the ‘Included’ tag will NOT print.

    • Excluded Menus and their Rate will print.

    • Excluded Menu Container will NOT print.

    • Included Menu Items will NOT print (whether attached to an Included or Excluded Menu).

    • Excluded Menu Items and their Rate will print (whether attached to an Included or Excluded Menu).

    • Excluded Menu Item Containers will NOT print.

    • Function Space Rate Code or the Included tag will NOT print.

    • Items with a 0 Quantity will NOT print.

    Non Catering Package Events in Template #8:

    • Item Rate Codes will NOT print.

    • Included Menu Names will print.

    • Menu Containers will NOT print.

    • Included Menu Items will NOT print.

    • Excluded Menu Items and their Rate will print.

    • Excluded Menu Item Containers will NOT print.

    • Function Space Rate Code will NOT print.

    • Items with a 0 Quantity will NOT print.

Partial Event Templates (when the Simple Events OPERA Control is active):

  • The following template values are available:

    • Template1. Date, Time, Event Name, Space Name, Attendees.

    • Template2. Date, Time, Event Name, Attendees, Function Space Rental.

    • Template3. Date, Time, Event Name, Space Name, Attendees (Double Spaced).

    • Template 5. Date, Time, Event Name, Space Name, Setup Style, Attendees, Function Space Rental.

Block Notes. Select block note types from the list to include in the report output.

Deposit. Select one of the following sort options: By Date, By Time, or No Deposit. If sorted by deposit type, a sub-total for each deposit type will output.

Currency. Select a currency from the list. This is available when the Ability to Quote Rates in Foreign Currency OPERA Control is active.

Revenue Values. Select an option from the list. Also see: Examples of Rev. Values.

  • Gross Rates/Revenue. Gross Room Rate is calculated as:

    • Included generates are not deducted.

    • Excluded generates are added.

    • Excluded packages are not added. Gross Catering Price is calculated based on the Transaction Codes mapped in Revenue Type Mapping.

  • Net Rates/Revenue. Net Room Rate is calculated as:

    • Included generates are deducted.

    • Excluded generates are not added.

    • Included packages stay included.

    • Included generates on included or excluded packages are calculated out. Net Catering Price is calculated based on the Transaction Codes mapped in Revenue Type Mapping.

  • Gross and Net Rates/Revenue. When this option is selected, both the Gross and Net room rates and catering prices are reported and displayed.

    Note:

    If you do not select an option, the room rates and catering prices appear as they are in OPERA Cloud.
Select revenue types. If you select the Template values as Template 4: Date/Time-Event-Space-Setup-Att-Rev1-Rev2-Rev3-Rev4, all Revenue Types are required fields. (Available when the Simple Events or Catering Events OPERA Control is active.)

  • Rooms with Rate and No Inventory. If selected, room types where no inventory has been booked are included.

  • PMS Room Types. If selected, PMS room types output on the contract instead of the Room Pools. If the Room Pools OPERA Control is not active and room pools are not configured for the property, you must select PMS Room Types to display the rooms in the contract output. For more information, see: Configuring Room Pools

  • Room and Rate Separately. If selected, room nights and room rates are included in separate grids. If not selected, they output in the same grid. This option is available only when both the Rate and the Occupancy flags are selected.

  • Room Rates. Select to output room rates, otherwise, Room and Rates Separately, Inline Currency, and Show Decimals are disabled.

  • Inline Currency. Enabled when Room Rates is selected. If selected, the currency symbol is included with the rate in the grid cells in the Room Grid and Event Templates.

  • Show Decimals. Enabled when Room Rates is selected. If selected, the rates in the Room Grid and Event Templates with decimals outputs as set up in the Property Details. If not selected, the rounded rate outputs without decimals.

  • Print Space Between Currency and Amount. Select the check box to print in the report (available when Room Rates and Inline Currency are selected). When selected, a space will be added between the currency symbol/code and the rate amounts displayed in the grid.

  • Hide Property Code. Select to suppress the property code from output in the report. The Property name will output.

  • Occupancy. If selected, the number per occupancy level per day is included on the report when the Occupancy Split OPERA Control is activated. If not selected, the total number of rooms per day per room type per day is output.

  • Internal Notes. If selected, internal block notes are included on the report.

  • External Notes. If selected, external block notes are included on the report.

  • Event and Resources Notes. (Available with Simple Events or Catering Events OPERA Control). If selected, event and resource notes are included on the report.

Revenue Values Calculation Examples

The following are examples for the Rev. Values options in the report parameters.

Table 9-2 Occ1 Net Rate = 48.91

Trx Code Description Amount

1000

Room Charge

38.00

2200

Package Breakfast Included

10.91

5000

Package Golf Excluded

62.50

8310

Generate on Room – Excluded at 10%

3.80

8000

Generate on Breakfast – Included at 10%

1.09

8200

Generate on Golf – Included at 20%

12.50
   

48.91

Table 9-3 Occ1 Gross Rate = 53.80

Trx Code Description Amount

1000

Room Charge

38.00

2200

Package Breakfast Included

10.91

5000

Package Golf Excluded

62.50

8310

Generate on Room – Excluded at 10%

3.80

8000

Generate on Breakfast – Included at 10%

1.09

8200

Generate on Golf – Included at 20%

12.50
   

53.80

Table 9-4 Occ2 Net Rate = 47.82

Trx Code Description Amount

1000

Room Charge

26.00

2200

Package Breakfast Included

21.82

5000

Package Golf Excluded

125.00

8310

Generate on Room – Excluded at 10%

2.60

8000

Generate on Breakfast – Included at 10%

2.18

8200

Generate on Golf – Included at 20%

25.00
   

47.82

Table 9-5 Occ2 Gross Rate = 52.60

Trx Code Description Amount

1000

Room Charge

26.00

2200

Package Breakfast Included

21.82

5000

Package Golf Excluded

125.00

8310

Generate on Room – Excluded at 10%

2.60

8000

Generate on Breakfast – Included at 10%

2.18

8200

Generate on Golf – Included at 20%

25.00
   

52.60

Table 9-6 Occ3 Net Rate — 46.73

Trx Code Description Amount

1000

Room Charge

14.00

2200

Package Breakfast Included

32.73

5000

Package Golf Excluded

187.50

8310

Generate on Room – Excluded at 10%

1.40

8000

Generate on Breakfast – Included at 10%

3.27

8200

Generate on Golf – Included at 20%

37.50
   

46.73

Table 9-7 Occ3 Gross Rate = 51.40

Trx Code Description Amount

1000

Room Charge

14.00

2200

Package Breakfast Included

32.73

5000

Package Golf Excluded

187.50

8310

Generate on Room – Excluded at 10%

1.40

8000

Generate on Breakfast – Included at 10%

3.27

8200

Generate on Golf – Included at 20%

37.50
   

51.40

Table 9-8 Occ4 Net Rate = 45.64

Trx Code Description Amount

1000

Room Charge

2.00

2200

Package Breakfast Included

43.64

5000

Package Golf Excluded

250.00

8310

Generate on Room – Excluded at 10%

.20

8000

Generate on Breakfast – Included at 10%

4.36

8200

Generate on Golf – Included at 20%

50.00
   

45.64

Table 9-9 Occ4 Gross Rate = 50.20

Trx Code Description Amount

1000

Room Charge

2.00

2200

Package Breakfast Included

43.64

5000

Package Golf Excluded

250.00

8310

Generate on Room – Excluded at 10%

.20

8000

Generate on Breakfast – Included at 10%

4.36

8200

Generate on Golf – Included at 20%

50.00
   

50.20

Related Topics