Seeking Instructions to Create Report of POS (NOT RMS) Discounts Applied

We need to run monthly 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 (e.g., buy one, get one free with coupon).

The built-in Discounted Sales report in POS 2.0 lists only the resulting Sale Price; we seek to have the report sorted by PresetDiscount type but the Advanced Report Filter dialog does not list Discount in the Field dropdown box and we can't locate the table in which transactions that have the Preset Discount are applied.

In the POS Query Tool, running the query "select * from [Transaction]" returns all the transactions since we opened our shop; however, there is no column listing discounts, discount IDs, or discount codes.

In the TransactionEntry table, all entries in the DiscountReasonCodeID field are 0. I can locate a transaction where a discount was applied, but no DiscountReasonCodeID is entered (only 0).

Running the query "select * from ReasonCode" returns only "The query executed successfully." I'm guessing the table is empty.

Running the query "select * from PresetDiscount" returns the discount categories we created.

So, in which table(s) are the records of all the transactions on which Preset Discounts have been applied?

We need to run monthly 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 (e.g., buy one, get one free with coupon).

The built-in Discounted Sales report in POS 2.0 lists only the resulting Sale Price; we seek to have the report sorted by PresetDiscount type but the Advanced Report Filter dialog does not list Discount in the Field dropdown box and we can't locate the table in which transactions that have the Preset Discount are applied.

In the POS Query Tool, running the query "select * from [Transaction]" returns all the transactions since we opened our shop; however, there is no column listing discounts, discount IDs, or discount codes.

In the TransactionEntry table, all entries in the DiscountReasonCodeID field are 0. I can locate a transaction where a discount was applied, but no DiscountReasonCodeID is entered (only 0).

Running the query "select * from ReasonCode" returns only "The query executed successfully." I'm guessing the table is empty.

Running the query "select * from PresetDiscount" returns the discount categories we created.

So, in which table(s) are the records of all the transactions on which Preset Discounts have been applied?

We need to run monthly 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 (e.g., buy one, get one free with coupon).

The built-in Discounted Sales report in POS 2.0 lists only the resulting Sale Price; we seek to have the report sorted by PresetDiscount type but the Advanced Report Filter dialog does not list Discount in the Field dropdown box and we can't locate the table in which transactions that have the Preset Discount are applied.

In the POS Query Tool, running the query "select * from [Transaction]" returns all the transactions since we opened our shop; however, there is no column listing discounts, discount IDs, or discount codes.

In the TransactionEntry table, all entries in the DiscountReasonCodeID field are 0. I can locate a transaction where a discount was applied, but no DiscountReasonCodeID is entered (only 0).

Running the query "select * from ReasonCode" returns only "The query executed successfully." I'm guessing the table is empty.

Running the query "select * from PresetDiscount" returns the discount categories we created.

So, in which table(s) are the records of all the transactions on which Preset Discounts have been applied?

Mark, I think the reason you aren't getting any answers is because the majority of us that frequent here are RMS users so we don't know anything about how the reports work in MSPOS. I would recommend you contact your partner that sold you POS or open a support incident with MS directly. I know this reply doesn't really help you but you might get your questions answered quicker and more accurately. Craig

Thanks, Craig

We do not have a Microsoft Partner (we were unable to find one willing to support the product --- it came preloaded on the Casio QT8000 POS system after being purchased from Best Buy For Business in Denver CO) and continue to have difficulty finding someone knowledgable on the product.

Even Microsoft, when queried, instructs us to consult with a Partner. When we explain our inability to find a Partner, we are advised to Google our issue or consult the Yellow Pages.

Brilliant, that's what that is.

HI mark,

I hlep you > Thanks, Craig

Mark,

Contact me at snipped-for-privacy@gmail.com if you would like to have ems support, I can support you remotly I'm sure we cash make you happy.