Convert Production Data

Note: This Utility is for use following upgrade from a pre- V2.5 Opera installation to V2.5 or later versions of Opera. As soon as possible following upgrade, you must run the Convert Production Data utility  found at Utilities>Data. This utility will split snapshot Gross Revenues into Net and Gross for better reporting granularity. This utility must be run as part of the whole upgrade scenario for both S&C and PMS sites, before the installer handling the upgrade leaves the site. If this utility is not run, the Rooms Blocked information on the main Business Block screen will display as zero.  Even though this is a display issue only, and the correct number of rooms is actually blocked and held in inventory, the erroneous display will confuse users.

This utility should only be run once for each property.

This utility must be run separately for each property in a multi-property environment. This means that the person running the update must log into the Utilities menu of each property and run the utility.

Database table Allotment_Changes is used to store block revenue: rooms, inclusive packages, and inclusive taxes are lumped in one revenue field. Starting with this release, a new table, Allotment_Changes_Net, is being introduced. This table will track block net revenue changes in terms of rooms, F&B, Non-Revenue, and Other. The information in this table is used for the new Backlog Report, and will have other uses in the future.

The production data conversion utility (Utilities>Data>Convert Production Data) converts pre-V 2.5 data into its component revenues to populate the new table. Going forward, Opera will automatically track revenues in both the Allotment_Changes table and the new Allotment_Changes_Net table.