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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine discounts per item using SQL with Micros 3700

Status
Not open for further replies.
OracleSucks

OracleSucks

Programmer
Sep 25, 2015
7
CA
Hi!

I'm trying to figure out if it's at all possible to determine actual revenue for a menu item taking discounts into account. For example, if I sell 10 item Xs @ $1 each through out the day, but 2 get 100% discounts applied to them I'd like to see actual revenue as $8 instead of $10 as shown in the Menu Item Sales Detail report. Is this possible, and if so which combination of tables would I have to join?

Thanks!
 
Status
Not open for further replies.

Similar threads

bpcore
  • Locked
  • Question
create itemizer, for discounts micros res 3700?
Replies
0
Views
154
bpcore
bpcore
kareem.akram
  • Question
Micros 3700 Emailer Program
Replies
0
Views
166
kareem.akram
kareem.akram
B
  • Locked
  • Question
MICROS RES 3700 - Desperate!
Replies
4
Views
889
bdavidson024
B
GeminiBoy
  • Locked
  • Question
Micros 3700 Automatic Email Report
Replies
3
Views
402
GeminiBoy
GeminiBoy
B
  • Locked
  • Question
Micros 3700 customer tip prompt
Replies
3
Views
408
marry833
M

Part and Inventory Search

Sponsor

Back
Top