Micros KDS

[pelikan123]

Hi All

I would like to ask a support from this forum about the Micros KDS.As per the operational needs we have to monitor the time in KDS.

In detail: As per the configuration now our KDS chit(Printer Ticket from Expo Done ) is giving only the time when we bump from the KDS,its not have any details about the ringing time (Server push the order from the POS).

Eg : Suppose a server punch the order at 1 pm in POS station and the kitchen finish preparation at 1.20 pm,Once we bump from the expo line the expo ticket only showing the time of 1.20.In this i just want to add the time of Ringing so we can compare the time of punching and the time food prepared

Regards

 

[Netvoid]

If you are adept at SQL/Crystal Reports ... Here is some sample SQL to help out.

This gives you the check number, menu item number, sales count/qty, and the date time it was put on the check.

If you use the future order feature you should join in sale_dtl also, which will omit the duplication that may occur in that situation.

This is just a sample to get you in the correct direction, a stored procedure should be built that incorporates the KDS detail with this in the manner you need.

(I just wrote this into this message may need some minor debug/tweaks)

<CODE>
SELECT
chkDtl.chk_num as checkNumber,
dtlDtl.rpt_cnt as salesCount,
dtlDtl.date_time as dateTimeRungUp,
miDef.obj_num as miNumber
FROM
micros.dtl dtlDtl
JOIN micros.mi_dtl miDtl
ON miDtl.trans_seq = dtlDtl.trans_seq
AND miDtl.dtl_seq = dtlDtl.dtl_seq
JOIN micros.trans_dtl transDtl
ON transDtl.trans_seq = miDtl.trans_seq
JOIN micros.mi_def miDef
ON miDef.mi_seq = miDtl.mi_seq
JOIN micros.chk_dtl chkDtl
ON chkDtl.chk_seq = transDtl.chk_seq
WHERE
transDtl.business_date = '2013/08/07'
</CODE>

 

[Netvoid]

After a bit more review, I think you can do this with some relatively simply math functions against bump time and prep time. Look into using DATEDIFF/DATEADD a bit with the values already available, maybe.... I admit I'm not a KDS expert.