Micros Void report

[Micros888]

Hello and appreciate any thoughts as I show a void a out on the server check out but when I run a void report it doesn't show any , as I want to make sure that the server didn't void items or a check reducing her cash responsibility, the individual server check out indicates 3 voids at $429 but when I ran the void report from the back of the hoouse it show 0 for that server, it also indicates on the daily sales report as voids $429, how do I located these voids
Many thanks in advance

 

[pmegan]

What version of micros are you using? Some of the older ones would allow voids to go through without selecting a reason, but only display those with a reason on the detail report. I've also seen the void total include voided tenders/discounts/service charge, while the void report only shows menu items.

This should give you all the void/return details to find out what's missing.

select 
    TR.business_date
    ,CEMP.obj_num [chk_emp_num]
    ,CEMP.last_name || ', ' || CEMP.first_name [chk_emp_name]
    ,AEMP.obj_num [auth_emp_num]
    ,AEMP.last_name || ', ' || AEMP.first_name [auth_emp_name]
    ,CHK.chk_num
    ,DTL.dtl_name
    ,(case
        when DTL.ob_dtl05_void_flag = 'T' then 'void'
        when MD.ob_dtl04_rtn = 'T' then 'return'
        else 'other'
     end) [trans_type]
    ,DTL.rpt_ttl
    ,coalesce(RR."name", VR."name", 'no reason') [reason]
from 
    micros.chk_dtl [CHK]
    join micros.trans_dtl [TR]
        on CHK.chk_seq = TR.chk_seq
    join micros.dtl [DTL]
        on TR.trans_seq = DTL.trans_seq
    join micros.emp_def [CEMP]
        on CHK.emp_seq = CEMP.emp_seq
    left outer join micros.mi_dtl [MD]
        on DTL.trans_seq = MD.trans_seq
        and DTL.dtl_seq = MD.dtl_seq
    left outer join micros.reason_def [RR]
        on MD.return_dtl_id = RR.reason_seq
    left outer join micros.reason_def [VR]
        on DTL.reason_seq = VR.reason_seq
    left outer join micros.emp_def [AEMP]
        on DTL.auth_emp = AEMP.emp_seq
where
    TR.business_date = '2014-10-27'  [COLOR=#4E9A06]// change to whatever date you need[/color]
    and (
         DTL.ob_dtl05_void_flag = 'T'
         or MD.ob_dtl04_rtn = 'T'  [COLOR=#4E9A06]// comment this line out to show just voids[/color]
        )
order by
    CEMP.obj_num
    ,CHK.chk_num
    ,[trans_type]

 

[hosehead78]

I agree with pmegan, I've seen this with 9700 system as well. Let me know if you need any queries for 9700.

 

[Micros888]

hello using 3700
regards