Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micros Guest check detail

Status
Not open for further replies.
azrobert

azrobert

Programmer
Apr 27, 2002
392
US
I am using this (from Pmegan)

select * from
micros.trans_dtl as tdtl join
micros.dtl as d on
tdtl.trans_seq = d.trans_seq join
micros.mi_dtl as mdtl on
d.trans_seq = mdtl.trans_seq and
d.dtl_seq = mdtl.dtl_seq join
micros.mi_def as mdef on
mdtl.mi_seq = mdef.mi_seq join
micros.chk_dtl as ckdtl on
tdtl.chk_seq = ckdtl.chk_seq
where ckdtl. chk_num = 8217

and getting menu items detail for guest checks.
I can find almost the same data in the view vta_base_baseDtl

I am seeing the original menu item and then 2 additional items for voided items.... how would I go about getting just the actual items that are currently on the check ?

Thanks in advance !!!!!
 
Sort by date Sort by votes
In digging around I noticed that the micros autoseq (employee menu item sales) shows voided items as a sale.
is it that hard to ferrit out the voided items ?

does anyone know of a sp or view that just shows actual items on check with a link to the guest check number ?
 
Upvote 0 Downvote
Hey.

Dont reinvent the wheel, go to autosequences & reports and view report #194 (Void & Reason Code) report?
 
Upvote 0 Downvote
He writes some advanced custom programs for managing Micros data. I saw his inventory program and it's pretty impressive. I'm pretty sure the query he's using is a menu item detail data extraction.

Robert, did you get this figured out or are you still looking for a solution?
 
Upvote 0 Downvote
No... Kind of put it on hold for a little (too many other projects) but Am still looking.....

 
Upvote 0 Downvote
I know how that goes. I'll try to play around with that query if I ever get some breathing room.
 
Upvote 0 Downvote
Thanks a lot.... I think I was just trying to find a way to
get a list of all items for a guest check, kind of a quick guest check anylizer, I can see where this could be useful in other places as well so it would be nice to figure it out.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CJ143
  • Locked
  • Question
Micros RES3700 : Guest Check Descriptor "Amount Due" Misaligned
Replies
0
Views
61
CJ143
CJ143
spankysportsbar
  • Locked
  • Question
Micros Cal133
Replies
3
Views
488
spankysportsbar
spankysportsbar
Phi_1.618
  • Question
Micros e7 BO reports
Replies
1
Views
79
Phi_1.618
Phi_1.618
R
  • Question
Micros database not starting
Replies
3
Views
355
Ronyad
R
vhp2023
  • Locked
  • Question
Micros Simphiny - Extension app - How to get items and payments of a check
Replies
3
Views
181
goodbody
goodbody

Part and Inventory Search

Sponsor

Back
Top