Check Detail Read Error - Micros 3700

[Sarah27]

I cant close a table - it is frozen and i have no way to close it OR get into it. It says Check Detail Read Error, How do i close this?

 

[DrZogg]

Hi,

You need to have the check #.
1. On the server Start>Run>DBISQL>
2. sign in with custom\custom (username\password)
3. Run the stored procedure "Force check Closed" by typing
call micros.sp_forcechkclose (insert check seq here)

Done

 

[CathalMF]

One correction on the above solution.
You need to find the check sequence number before running the call micros.sp_forcechkclose() command.

To find the chk sequence number type in:

select chk_seq from micros.chk_dtl where chk_num = xxxx and chk_open = 't'

replace the xxxx with the check number.

This will return to you the check sequence number.
Then run call micros.sp_forcechkclose(xxxxxxx)
replace xxxxxxx with the check sequence.

 

[jd11111]

another thing to note on this issue...

if you force close a check, you still retain the sales/payments, etc. that were posted to that check. This means that if you had sales on the check and have to ring the items in again to charge the customer you then have inflated sales with no payment to match.

Micros usually suggests that you ring negative sales to balance this out.