Has anybody here had to get a count of discounts when prorated or item discounts are being used? We've always looked at the number of items discounted, but now our OPS people want to see how many times each discount was used. It's a reasonable request, just tough to find, so I figured I'd ask before reinventing the wheel.
I've tried the old way, linking dtl to dsvc_dtl, but that give a count of one for each menu item
I then tried summing distinct trans_seq's for each dsvc_seq, but that doesn't work for voided discounts or if a touch discount is used more than once in a transaction.
Any ideas? It would be great to save a little time.
I've tried the old way, linking dtl to dsvc_dtl, but that give a count of one for each menu item
I then tried summing distinct trans_seq's for each dsvc_seq, but that doesn't work for voided discounts or if a touch discount is used more than once in a transaction.
Any ideas? It would be great to save a little time.