Micros pos 3700 check detail read error 1

[sturno55]

Hi all. I am having trouble opening some old checks and I just want to delete them at this point. I know it can be done in DBISQL but i forgot the exact code." Select * from micros.chk_dtl " is all I have. Can someone please help?

 

[pmegan]

If you haven't solve this yet, here's the code.

Replace xxxx with the check number you want to close in the query below.

Select * from micros.chk_detail
Where chk_num = 'xxxx'

The first field will be chk_seq. Make sure you have the correct check and write done the chk_seq number.

Now enter this, replacing chk_seq with the number you wrote down:

call micros.sp_ForceChkClose(chk_seq)

Repeat this for each check.