Micros 3700 reset menu item availability at EOD

[bbrandon]

Does anyone know of a script that can be added into the end of day auto seq that would reset menu item availability? Typically when a menu item is set to limited or zero quantity it is only for the remainder of that business day and becomes available in full quantity the next day. Prime rib would be a great example as it is available every day "while supplies last".
Thanks - Brandon

 

[jlhardyman]

This is the script we use as an external program and is part of our end of day routine:
External Program:

User Interface: Windows
Run Style: Normal
Working Directory: D:\MICROS\RES\POS\Scripts
Command Line: D:\MICROS\RES\POS\Scripts\reset_mi-avail.bat


D:\MICROS\res\pos\scripts\reset_mi_avail.sql

update micros.mi_status
set ob_mi32_out_of_mi = 'F';
update micros.mi_status
set available_count = (NULL);
update micros.mi_def
set ob_mi31_chk_mi_avail = 'F';
commit;

D:\MICROS\RES\POS\Scripts\reset_mi_avail.bat

@echo off
rem RESET_MI_AVAIL..BAT
rem MLA 05/04
rem rrosales@micros.com
rem This file resets menu item availability back to currently available.
rem It is meant to be run from an aseq
dbisql -c "uid=custom;pwd=custom" read reset_mi_avail.sql


Please note it resets all items. If you track your wine bottles through MICROS, they will be reset each night with this script . . .

Hope this helps.