How to configure tables to appear in different colors on the Recall Table dialog

The Recall Table dialog that displays when DiningHeaders=TRUE is present in the [Preferences] section of the Sales32c.INI file can be configured to display tables with a positive balance due in one color and tables with a zero or negative balance in another color. In order to use this functionality, you need to add the following settings to the [Interface] and [Preferences] sections of the Sales32c.INI file (in addition to DiningHeaders=TRUE in the [Preferences] section).

This functionality can also be applied when using the AutoRecall .INI setting if you want to color the buttons in the AutoRecall process as well, provided that AutoRecallButtons=TRUE is present in the [Preferences] section of the Sales32c.INI file for that salespoint. For this to work in the AutoRecall process, the balancedue field must be specified in the AutoRecall SQL query in the [Preferences] section of the Sales32c.INI file. Also, for the output to remain consistent, ORDER BY Sign(balancedue) DESC is also added to the AUTORECALL SQL query. This causes the Recall Table dialog to include the balance remaining on the orders to appear as well.

The following is an example of how to configure a salespoint in a table service restaurant to use this functionality:

Note: In this example, the TableRecallOrderBy setting has been added to further affect the display of tables on the Table Recall dialog. With these settings in place, the Recall Table dialog displays table buttons with a positive balance due first on the dialog in blue and ordered by table number ascending (first_name ASC), and then by split (last_name) and finally by original order date/time (orig_dt). The table buttons for tables with a positive balance due are followed by the table buttons for tables with a zero or negative balance displayed in light yellow and ordered by table number ascending (first_name ASC), and then by split (last_name) and finally by original order date/time (orig_dt).

The following is an example of how to configure a salespoint that uses AutoRecallButtons to use this functionality:

[Preferences]
AutoRecallButtons=TRUE
TableRecallSortActive=TRUE
AutoRecall="SELECT first_name,orig_dt,balancedue FROM sh_save
WHERE date_time > GETDATE() - 1 AND recall1 LIKE '<group>%' AND
recall2 LIKE '<subgroup>%' AND operator = '<operator>' AND salespoint = '<salespoint>' AND finalized = 0 AND reserv_no = 0 ORDER BY SIGN(balancedue) DESC"

Note: balancedue must be included in the SELECT portion of the AutoRecall SQL query for this to work correctly and that any valid ORDER BY query can be used here to order the buttons. However, using ORDER BY SIGN(balancedue) DESC maintains the display of colored buttons ordered in a manner similar to how they are ordered when DiningHeaders=TRUE, namely that buttons for sales with a positive balance due are displayed first in the list in blue and buttons for sales with a zero or negative balance are displayed last in the list in white.