Archiving Dining Reservation History
In this article
To archive dining reserv. history entries
To archive dining reserv. history entries up to a specific date
To recall an archived dining reserv. history entry
Running the archiving in the job queue
In addition to calculating dining area statistics to reduce the amount of data being worked with on a daily basis, you also need to archive dining reservation history entries on a regular basis. These entries are created when the system closes the dining reservation entries:
- Guests have been seated at allocated tables and their orders have been completed or voided.
- Reservation is canceled.
- Reservation is marked as No-Show.
The program archives the entries in the Dining Reserv. History Entry table into Archived Dining Reserv. History Entry table. Comments are also moved between the tables.
To archive dining reserv. history entries
- Click the icon, enter Dining Areas, and select the relevant link.
- Select a dining area.
- In the Days Din. Res. History Entries Exist field in the Allocation and Reservation FastTab, enter the number of days you want to keep the history entries in the database.
- Click the Archive - Archive Din. Res. History Entries actions. If the number of entries is greater than 0, confirm the question.
Tip: If the number is very large, consider archiving up to a certain date in the past to minimize the time it takes to archive.
To archive dining reserv. history entries up to a specific date
- Click the Archive - Archive Din. Res. History Entries - Specific Date actions.
- Enter a date up to which you want to archive the entries. If the number of entries is greater than 0, confirm the question. If the number is very large, consider archiving up to an earlier date to minimize the time it takes to archive.
To recall an archived dining reserv. history entry
- In the Dining Area Card, click the Dining Reservations Entries - Arch. Dining Reserv. History Entries. The page shows the entries that have been archived.
- Select an entry in the list.
- Click the Recall Archived Entry action, and confirm the question.
- Close the page.
- View the recalled entry by clicking the Dining Reservations - Dining Reserv. History Entries actions.
Running the archiving in the job queue
You can also schedule the run of the Archive Dining Reserv. History Data job regularly, when the restaurant is not open. This job archives entries for dining areas with the value in the Days Din. Res. History Entries Exist field set as greater than zero.