Micros 9700 Clearing totals

[ttrain68]

Hello Micros folks,

I am having a tough time getting a 9700 system to clear totals. I have used the following SQL as well as the report writer option but it will not clear. I get the not responding message after a while but it just won't clear the system. Any ideas on what more I can do to get this cleared out.

USE MCRSPOS
TRUNCATE TABLE microsdb.TOTALS;
DELETE FROM microsdb.CHECK_DETAIL_ORDER_DEVICE;
DELETE FROM microsdb.CHECK_DETAIL_TAX;
DELETE FROM microsdb.SVC_CHG_ITMZR_SVC_CHG_DTL;
DELETE FROM microsdb.SERVICE_CHARGE_DETAIL;
DELETE FROM microsdb.MENU_ITEM_DETAIL_COURSE;
DELETE FROM microsdb.MENU_ITEM_DETAIL;
DELETE FROM microsdb.TENDER_MEDIA_DETAIL_TAX_EXEMPT;
DELETE FROM microsdb.TENDER_MEDIA_DETAIL;
DELETE FROM microsdb.GUEST_INFORMATION_DETAIL;
DELETE FROM microsdb.TEAM_DETAIL;
DELETE FROM microsdb.TEXT_DETAIL;
DELETE FROM microsdb.PMS_TOTAL_DETAIL;
DELETE FROM microsdb.SECURE_DETAIL;
DELETE FROM microsdb.DSCNT_ITMZR_DSCNT_DTL;
DELETE FROM microsdb.DISCOUNT_DETAIL;
DELETE FROM microsdb.CHECK_DETAIL;
DELETE FROM microsdb.CHECKS;
DELETE FROM microsdb.TIMECARD_DETAIL;
DELETE FROM microsdb.TIMECARD;
DELETE FROM microsdb.PERIOD_INSTANCE;
DELETE FROM microsdb.SUMMARY_TOTALS;
DELETE FROM microsdb.CARRIED_TOTALS;

 

[ttrain68]

This continues to be an issue, anyone have any input on why this may be occurring or how to address?

 

[Scacea]

You should have in your Micros\LES\POS\9700\bin CarryoverAutoReset.exe

You need to run that 2 days in a row and your totals should be cleared.

It is very important that there are no checks open in the system otherwise it will not work

 

[ttrain68]

Scacea,

Thank you for the response I will give that a try. I thought this was just for the phantom carried over checks issue so I didn't think to run it. I will let you know how I do. Thanks again!