We really need to run ongoing reports to determine how many of our different Discounts are claimed/used and the proceeds not tendered. We have offered a number of discounts to customers and employees as incentives and cannot find a method to track how each discount is applied.
The built-in reports within POS (not RMS) are not nearly as robust as we wish/require (they're actually quite lame). Is there a query we can run on a transaction table to reveal the discounts applied to those transactions?
In the POS Query Tool, running the query "select * from Transaction" throws an error; however, the table Transaction exists. Can anyone please point us to a solution?
M Kalmus