Micros 3700 items disappearing from open checks

[nick31]

Just ran into this problem.
Let's say server opens a new table, puts an order and sends it.
Kitchen receives the order - it prints in full.
Server reopens the check, but it is empty or some items are gone from the check.
Happened few times, different servers, different menu items.
Nothing suspicious in the reports, no voids, comps or deletes.

For now we just resend same items with DON'T MAKE so they would appear in the customers receipt.

I am at loss, what could it be?

 

[CathalMF]

If you know the check number and the business date when this happened then you can run the below SQL query on the database to see what the database actually contains for that check.
It will give you a number of columns which will help you see what is happening to the check. Replace the date and the check number with something which is relevant to you.
If you dont know how to run a query see my website which explains it.

http://micros-pos.blogspot.co.uk/2011/02/res-3700-understanding-dbisql-for.html

SELECT
CDTL.chk_seq,
TDTL.trans_seq,
CDTL.chk_num,
CDTL.chk_open,
DTL.dtl_type,
DTL.dtl_name,
DTL.rpt_cnt,
DTL.rpt_ttl,
ob_dtl05_void_flag,
ob_error_correct,
EDEF.first_name + ' ' + EDEF.last_name as TransactionEmployee
FROM micros.dtl DTL
JOIN micros.trans_dtl TDTL
on DTL.trans_Seq = TDTL.trans_seq
JOIN micros.chk_dtl CDTL
on TDTL.chk_seq = CDTL.chk_seq
JOIN micros.emp_def EDEF
on TDTL.trans_emp_seq = EDEF.emp_seq
WHERE
TDTL.business_date = '2014-08-21'
AND CDTL.chk_num = 1080
ORDER BY CDTL.chk_seq, TDTL.trans_seq, DTL.dtl_id asc



Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/