Calculating Dining Area Statistics

When you calculate dining area statistics, the program archives all dining area plans, dining table history entries and dining table receipt entries for the selected time frame and calculates from this archived data the statistics for the dining area. It also closes any open dining reservation entries and associated attribute POS transaction entries.

Note: It is very important to calculate dining area statistics on a regular basis (up to once a day) to minimize the size of the database tables used in dining table management (Dining Table History Entry, Dining Table Receipt Entry, Dining Area Plan, Dining Reservation Entry ,and Attribute POS Trans. Entry).

You can also schedule the run of the Dining Areas - Calculate Statistics and Archive Data job once a day ,when the restaurant is not open.

To calculate the statistics for a dining area

  1. Click the icon, enter Calculate Dining Area Statistics, and select the relevant link.
  2. Select the desired dining area in the Dining Area ID field. If no dining area is selected, the program will calculate the statistics for all dining areas.
  3. Select the date up to which you want to calculate statistics for. The number of dining area plans and dining table history entries that will be archived is visible in the window.
  4. Click OK.

The program displays a progress bar while archiving and calculating. When the calculation is completed, the program displays the Dining Area Plan Statistics page showing the resulting statistics for the period in question.

The program archives the following tables that contain day-to-day information: 

The program stores the statistics in these tables:

Note: Even if you have not set up dining area plans in your company, the Calculate Dining Area Statistics function archives the dining table history entries and dining table receipt entries. We do recommend, however, that you set up dining area plan templates to create dining area plans. You can create dining area plans in the past just to get statistics on your dining areas from the first day you have dining table history entries.