HELP! Seeking Instructions to Create Report of POS Discounts Applied

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

Reply to
Mark Kalmus
Loading thread data ...

Hi Mark - try...

select * from [transaction]

You need the brackets as the word "transaction" is a reserved word in SQL-speak

I am not really familiar with the table structure > We really need to run ongoing reports to determine how many of our different

Reply to
convoluted

Mark, The table you want to use is TransactionEntry. It has a field called DiscountReasonCodeId.

The description of the discount is in ReasonCode table. This table hold reason codes for things other than discounts though. So you will need to filter by the ReasonCode.Type field. I believe type = 4 should be discount. But you can verify this by looking at your own database.

If you join the transaction, transactionEntry and ReasonCode tables you can create the necesary report. Let me know if this is helpful. Thanks

Reply to
relentless

So I can run the query

Select * from [ReasonCode]

which returns a Message "The query executed successfully." but does not display results of the query. I get the same Message with the query

Select * from [ReasonCode] where ReasonCode.Type > 0

but no results display.

Am I not performing the proper query just to view the table contents and Type field contents?

M Kalmus

Reply to
Mark Kalmus

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.