OracleSucks
Programmer
Hi!
I posted this a month or 2 ago and asked specifically for a SQL solution, but now I'm desperate to find any solution that will work (standard report, Transaction Analyzer, etc).
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 at all?
Thanks!
I posted this a month or 2 ago and asked specifically for a SQL solution, but now I'm desperate to find any solution that will work (standard report, Transaction Analyzer, etc).
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 at all?
Thanks!