Micros 3700 Single Closed Check Not Purging

[cobbler9]

Running

select * from micros.chk_dtl
order by chk_open_date_time

shows a check from 2007-04-26 that has chk_open "F" but for some reason is not being purged through the nightly autosequence. The purge seems to be running correctly as the next check shown is from 2013-11-15.

How would I go about manually purging this check?

Thanks in advance!

-- Mike

 

[pmegan]

Since everything is purging around this check, micros just isn't recognizing it as something that needs to be purged.

The first thing to do is check the chk_clsd_date_time for that check. If the system time was changed while it was open that could keep it from purging.

If the closed date is ok, get the chk_seq for that check from chk_dtl, then see if there are any rows in the trans_dtl table for it. If there are look at the business date for them. It may be a check that was rung in on the demo date by mistake. That would stop it from purging at the transaction level instead of the check level.

 

[cobbler9]

Thanks, pmegan.

The chk_clsd_date_time was early the next morning, about 1:40am, which would be normal for a bar patron closing out their tab. The business date also seemed to be correct so not sure why the check was not being purged.

However, due to the overhaul of our menu, a need to re-write all of our tracking groups, corruptions of our database that were causing all attempts of database rebuilds to fail, and the fact that we keep historical totals elsewhere, we decided to clear all of our totals and that cleared the old check. It, unfortunately, did not solve our database rebuild failures, but that will be for another day.

Thanks!!