Micros 3700 - Only Certain Items Appearing in Sales Report

[stagerman15]

I'm having a serious issue with certain items not appearing in the database when purchased. None of my beers are appearing in the report for today. This is the query that I'm using:

select m.obj_num, m.name_1, sum(t.price_1_sls_cnt) as count,
sum(t.price_1_sls_ttl) as total from micros.dly_sys_mi_ttl t, micros.mi_def
m where m.mi_seq = t.mi_seq and t.business_date = (select business_date
from micros.rest_status) GROUP BY obj_num, name_1

If anyone has an idea why some items appear but others do not, please let me know.

Thanks,

Todd

 

[MikeRose]

This query would would only capture items sold on level 1. Are you using multple menu levels in a happy hour, perhaps?

 

[pmegan]

Are your beers not showing up at all, or are they showing up with zeros for the count and sales amount?

 

[cvalentin]

select m.obj_num, m.name_1, sum(t.price_1_sls_cnt) as count,sum(t.price_1_sls_ttl) as total
from micros.mi_def m
left outer join micros.dly_sys_mi_ttl t
on m.mi_seq=t.mi_seq
where
t.business_date = (select business_datefrom micros.rest_status) GROUP BY obj_num, name_1

Left outer join gives you all of the menu items and not just the menu items sold.