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 gkittelson 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
8
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
220
bpcore
bpcore
kareem.akram
  • Locked
  • Question
Micros 3700 Emailer Program
Replies
0
Views
438
kareem.akram
kareem.akram
DatFatMan
  • Question
5.7.7 Micros 3700 - Forms Designer Help
Replies
4
Views
986
Wildbar
Wildbar
danaikotz
  • Locked
  • Question
micros 3700 isl - tcp interface issue with multiple workstations
Replies
2
Views
589
ExJoice
ExJoice
B
  • Locked
  • Question
MICROS RES 3700 - Desperate!
Replies
4
Views
1K
bdavidson024
B

Part and Inventory Search

Sponsor

Back
Top