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 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.

The following Mandatory or Optional procedures are run during the End of Day sequence based on the configuration of your property. ( End of Day - Income Audit)

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 OPP MEM Membership license code is Active).
Generate Data-Export	Generate_Export_NA_Data	Optional	Export data. The procedure is not visible if the OPP EXP Export Files add-on license 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 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.