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!
-
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 9700 (SQL) Report Items Sold, Gross Revenue, Discounts - Including Split Checks.
Hi microsguy16, do you happen to know the different types of TTLTYPE in the TOTALS table? Or the Flags? Thank you so much!!!!- osorio82
- Post #4
- Forum: Point of sale systems
-
Micros 9700 (SQL) Report Items Sold, Gross Revenue, Discounts - Including Split Checks.
Ok. I'm looking at the TOTALS table, do you know what TTLTYPE should I use? Do you know what the codes mean? Thank you for all the help. I'll be waiting for those sql files.- osorio82
- Post #3
- Forum: Point of sale systems
-
Micros 9700 (SQL) Report Items Sold, Gross Revenue, Discounts - Including Split Checks.
Good morning, I'm fairly new to MicrosDB and trying to create a report out of the Oracle database (micros 9700 version). I need to report Total Items sold, Gross Sales and Discounts per Revenue Center. I'm having issues with the split checks. I'm not sure how to count the items or the revenue...- osorio82
- Thread
- Replies: 4
- Forum: Point of sale systems
-
Micros 9700 ver 3.xxx report help!!!
Good morning, I'm fairly new to MicrosDB and trying to create a report out of the Oracle database (micros 9700 version). I need to report Total Items sold, Gross Sales and Discounts per Revenue Center. I'm having issues with the split checks. I'm not sure how to count the items or the revenue...- osorio82
- Post #14
- Forum: Point of sale systems
