Mandatory and Optional End of Day Sequence Procedures
The End of Day Routine consists of a series of steps. Of the steps there is the sequence that processes procedures and reports during the End of Day Routine. You can print an unlimited number of reports. Furthermore, you can determine which procedures or reports are to be executed on which days. After you have selected the End of Day Sequence option, OPERA Cloud displays the current End of Day Mandatory Procedures that run at the property during the End of Day Routine. All procedures are displayed, but only the Optional Procedures are editable. End of Day Interim Procedures and Reports is enabled when Income Audit controls is Active.
Table 13-23 Mandatory or Optional Procedures
List Name | Procedure Name | Mandatory/Optional | Description |
---|---|---|---|
Reservation No Shows |
reservation.no_show |
Mandatory |
Processes no-shows. Reclassifies all reservations from Due Ins to No Shows when the reservation's expected day of arrival has passed. For example, if the business date has rolled from April 4 to April 5, 2018, all April 4 Due Ins will be reclassified as No Shows. |
Synchronizing Front Office Statuses | Synchronizing Front Office Statuses |
Mandatory |
Synchronizes (matches) the number of persons and room status (occupied/vacant) in the room table with the number of persons and room status from the reservations table. The reservations table is the controlling table. |
Updating Room Statuses | hkpkg.update_room_status_proc |
Mandatory |
The night audit procedure hkpgk.update_room_status_proc will update all No Show rooms to the room status selected here. If no status is selected, then the room status of the no show assigned rooms will not be changed. If a reservation with an assigned room number cancels on the expected day of arrival, the reservation too shall adhere to this set room status. |
Creating Guest ledger | refresh_fin_summary.refresh_resv_summary |
Mandatory |
Updates each guest's reservation balance. |
Generate Reservation Statistics |
update_statistics.update_statistics_main |
Mandatory |
Updates each guest's stay statistics, such as, number of rooms, number of guests, room revenue, and promotion code. |
Populating Trial Balance |
refresh_fin_summary.populate_trial_balance |
Mandatory |
Populates a summary table of the day's transactions for each transaction code for the Trial Balance report. |
Populate Folio Tax Summary |
refresh_fin_summary.populate_folio_tax |
Mandatory |
TBD |
Generating Reservation Statistics |
update_statistics.update_statistics_main |
Mandatory |
Updates each guest's stay statistics, such as, number of rooms, number of guests, room revenue, and promotion code. |
Calculating Historical Information |
pms_prform00.update_profile_resv_statistics |
Mandatory |
Update profile statistics. |
Purge |
Purge |
Mandatory |
This procedure searches and automatically deletes resolved maintenance requests which are greater than 60 day. |
Membership Trans & Points |
Membership_P.Create_daily_membership_tran |
Mandatory |
Creates daily membership transactions and calculate points (only when the General Export OPERA Control is Active). |
Generate Data-Export |
Generate_Export_NA_Data |
Optional |
Export data. The procedure is not visible if the General Export OPERA Control is Inactive. When an Export File has a status of EXPORT PENDING, it means that the file generation process was not completed or not even started. COMPLETED is displayed if the data export was created without any errors. If EXPORT PENDING is displayed, then the user typically goes back into the night audit, and the process to generate the export files is restarted before going to the next step. |
Populate Audit Box |
Refresh_Fin_Summary.Populate_audit_box |
Optional |
Populates Audit box |
Back Office Export |
bof_package.export_bof_data |
Optional |
Back Office export when using Back Office. |
Cancel Waitlist Reservations |
delete_waitlist |
Optional |
Cancels all waitlist reservations for the previous business date. |
Purge Resolved Room Maintenance Requests |
hk_maint.purge_room_maintenance |
Optional |
This procedure searches and automatically deletes resolved maintenance requests that are greater than 60 days. |
Populate the temporary store table for Processing Commissions |
insert_resv_commissions |
Optional |
Searches for reservations with travel agent commissions attached, and places all commissionable reservations into a temporary table, and calculates commissions. |
Process Awards Timeout Messages |
pms2crs_interactive_events.process_awds_timeout_messages |
Optional |
Processes awards timeout messages. |
Allotment Cutoff |
pms_grgrid.night_allotment_cutoff |
Optional |
Searches for all allotments whose cutoff date matches the previous business date. If an allotment's cutoff date matches the previous business date all unreserved rooms will be released back to general inventory. |
Delete Messages |
pr_b_del_msg_on_chkout |
Optional |
Deletes traces and messages for checked out guests. |
Execute Rate Strategies |
rate_strategy_pkg.set_rate_strategy |
Optional |
If rates strategies have been established, then this procedure will execute those rate strategies. |
A/R Aging |
update_invpurgedtl_bucket |
Optional |
If the property is running the OPERA Cloud AR function, then run this procedure to update the property's accounts receivable (A/R) amounts and related A/R aging information. |
Authorization Credit Card |
Night_Audit_Authorization |
Optional |
At check in, a property usually seeks credit card authorization for a certain dollar amount (estimate of the amount of charges to be settled upon check out) for each reservation. If stay charges approach the property's initial estimate, this procedure will attempt to authorize a higher credit limit. If the authorization is not given (for whatever reason) an exception report can be produced allowing the property to contact the guest the next day to rectify the situation. |
Past Arrival Waitlisted Reservations become turnaways |
Turnaway_waitlist |
Optional |
Cancels all waitlist reservations for the previous business date. |
Credit Card Offline Settlements Processed |
cc_offline_settlements |
Optional |
Similar to the night audit credit card authorization procedure, 3 attempts will be made and if these attempts are not successful, the procedure will show as FAILED and the night audit will continue as normal. But if less than 3 failures are received, then the procedure will show as COMPLETED and will continue as normal. |
Assign Tax Registration No to In House Reservations |
eod_misc.assign_tax_reg_no |
Mandatory |
Enabled when the Generate Tax Registration Number OPERA Control is active. A registration number is assigned to each Arrival reservation and appears in the Registration Number field in Reservation Stay Details panel. The registration number is sequentially assigned to arrivals. |
Parent topic: End of Day (Night Audit) Procedures