ISO Production Report (REP_ISO_PRODUCTION.REP with REP_ISO_PRODUCTION.FMX)
The ISO Production report only displays when the OPS <version number> Sales & Catering license code is active. This report has been developed on specific request. It is a hybrid report of production and on-the books data, meaning that the records are selected through a production date range process, but the number of room nights, average rate and revenue are on-the-books and not as produced in the production date range. It additionally gives the option to be filtered and grouped by multiple regions of booking origin. Regions can be made up on-the-fly from configured country and state codes. The report will base the region filter on the profile country or state of the account that is linked as primary company to each booking.
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.
Stay Date. The stay date range that should be covered in this report. If the Stay Date From is 01 January 2004 and the arrival Stay Date To is 31 December 2004, if a booking exists that arrives on the 27 December 2003 and stays until the 15 January 2004, only those room nights and revenues that pertain to the stay dates of this booking in January 2004 (01st to 15th) will be included in this report.
Production Date. Defines the date range for which booking changes should be recorded. Each change that is done to a booking status, or booking room nights and revenue, is recorded in a specific production change log. The Production Date Range filter will scan the entries in this production change log to search for any booking changes that fall under the other criteria that have been selected on the filter form. By the nature of this date range filter, only dates in the past are valid entries, because there cannot be any entries in the booking change log after the current business date. To illustrate the above, a booking that gets created on status TEN in April 2003 with Stay Dates in October 2003 can turn to status DEF in June 2003. In the above scenario there would be two entries in the change log for this booking, one for the creation of the booking on status TEN in production period April 2003 and one for the status change to DEF in June 2003.
If the production period is left blank on this report, the figures would automatically print for everything that has ever been produced for the selected stay date period; which is concurrent with the on-the-books figures for group rooms and revenue at the selected statuses at the time or printing the report.
Note that for this report only record selection process depends on the production date range and the Change Date Status, the room night and revenue data are always shown as they are at the moment of printing the report (on-the-books), not as produced in the production date range.
Group By. Available options are: State, Country, Region, Account Name, Arrival Date, Block Status, Rooms Owner and Cancel Reason.
Sort Order. Available options are: State, Country, Region, Account Name, Arrival Date, Block Status, Rooms Owner and Cancel Reason.
Page Break. Select the check box to have a page break after each group.
Property. Available when OPS_MHT2 license is active. Choose the property for which the report should be printed.
Business Block. Can be ordered for specific business blocks only if required.
Business Block Status. Only bookings of the specified statuses will be included in the report if selected.
Change Date Status. This filter allows the definition of a status that bookings need to have turned into during the production date range, or that bookings were before the production period and had revenue changes done to them in the production period (typically this would be a DEFINITE status).
Status Changes. If this flag is checked, only bookings that turned into the defined Change Date Status during the production date range will be included. Bookings that were on this status before the production start date, but had revenue changes done to them in the production period would NOT qualify for inclusion if the flag is checked.
Source. Allows inclusion of only bookings with the specified source code.
Region 1-6. Allows the grouping of country codes and State codes into up to six on-the-fly regions. The regions can be composed from the configured country and state codes. At least one region needs to be specified for the report to run.
Currency. Select the currency in which the revenues on this report will display.
The report will list the bookings that fall under the filter criteria in the sort order as selected.
Please note that the region filter is ONLY applied to the attached contact profile (Acct/Company, Agent, Source). Bookings that do not have any contact profiles attached will not appear anywhere on the report, even if the attached account(s) falls within the region parameters that have been specified. If only a company contact is attached to the booking, or a company contact AND a travel agent contact or a company contact AND a source contact are attached, the booking will be classified to belong to the region that the company contact is linked to ONLY. If an agent contact and source contact are attached, the booking will be classified to belong to the region that the agent contact is linked to ONLY. If ONLY a travel agent contact is attached to the booking, or if ONLY a source contact is attached to the booking, the report will be for the region that the travel agent contact or source contact is linked to, respectively.
The following details will print per booking: Booking Property, Region, Booking id, Account Name, Booking Name, Agent Name, Contact Name, Arrival Date, Departure Date, Status, Average Rate, Room Nights, Room Revenue, Creation Date, Date turned to ‘Change Date Status’, Rooms Manager, Booking Source.
Revenue and average rate will print on this report as entered. No tax or packages that might be inclusive will be calculated out. Revenue and room nights are always reported as they are at the time of printing the report. They figures shown are NOT production figures.