Block Pick Up Report (REP_ACTBB_P.REP with REP_ACTBB.FMX)

This report compares booked group rooms and revenue and average rate, and picked-up group rooms revenue and average rate, and prints the variance between those values.

This is a slightly different model of the Actual Business Block Rooms Report (REP_ACTBH.REP) with a different lay-out and filter options, but essentially the same information is included.

Note: This report requires that the user be granted the BLOCK PRINT permission in the selected property to run the report. Also, the Property LOV in this report is further limited by the properties to which the user has the appropriate access granted.

Selection Criteria

Stay Date Range From Date/To Date. Will allow to select bookings that have at least one stay day within the selected from and to date. The program does not look at the booking arrival dates for this filter. However, please note that the total booking room nights and revenues are printed for bookings that fit the filter range, not only those values that are falling into the stay date range. Also, please note that Master Allocations are excluded from this report.

Business Block Status. Select one, multiple or all business block statuses to display on this report.

Sales Manager. Select one, multiple or all sales managers for which to filter this report by.

Change Date Status. Allows the selection of a specific status for which the date when the booking turned this status is printed onto the report. Most typically this report would be printed  for the Business Block Status ACT with Change Date Status DEF.

Rooms Only, Catering Only, All. Will allow to filter this report to print only for bookings without catering elements , only for bookings that do have catering elements booked, or for all bookings.

Sort By. There are multiple options by which this report can be sorted. The top sort order also serves as the grouping and the report will print a subtotal after each group. The options to sort this report by are: Sales Manager, Business Status, Arrival Date, Departure Date, and Catering Manager.

Currency. Select the currency in which the revenues on this report will display.

Report Data

The report prints in portrait format. For each booking the account name and booking name are printed as well as the booking ID, current booking status, selected change status and status change date, rooms owner and catering owner of the booking as well as  booking arrival and departure date and booking currency. The current room nights , revenue and average rate are printed in the top row of the revenue box. Actual picked-up room nights, revenue and average rate are printed underneath the current figures. The calculated difference prints as a third line underneath 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 booking 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 however are NET of taxes and packages. This needs to be kept in mind when comparing these values.