AnsweredAssumed Answered

Transact Product Promotion Reporting

Question asked by rs28427 on Jul 27, 2017

Does anyone know a way to generate a report that lists product sales and separates out promotions?  Basically, i have a scenario where we have Meal tickets for visiting students and parents allowing them to get a free meal at our dining commons. I am trying to set these as a promotion where the cost is zeroed out.  The transaction works fine but when it comes to reporting on the number of meal tickets received vs. lunches sold, i hit a snag where none of the report templates separate these out or even show how many promotions where given away.  I am looking at writing the SQL to pull this information but if someone knows another way, I would be interested.

Outcomes