No discount allowed

Apr 13, 2006 1 Replies
K

Two questions:


  1. Is there any setting in RMS that will automatically not allow discounts on anything that is on sale (other than check the box for every item that is on sale)? It would be nice if this could automatically happen without having to take another step every time.
  2. Does anyone have a workaround for changing the price of an item in the POS screen when it has the "No Discounts Allowed" box checked? We may have an item at 20% off, but an employee gets 40% off, but we can't change the price.
Vote
Twitter Facebook LinkedIn
J

Kris,

  1. Nothing automatic that I know of. Here's a SQL script that can be run in Admin to solve the issue. Run it everytime and new sale is issued. Make a backup FIRST!!!

UPDATE Item SET ItemNotDiscountable = 1 WHERE SalePrice 0 AND CONVERT(datetime, CONVERT(nvarchar, SaleStartDate, 101), 101) CONVERT(datetime, CONVERT(nvarchar, GETDATE(), 101), 101)

UPDATE Item SET ItemNotDiscountable = 0 WHERE CONVERT(datetime, CONVERT(nvarchar, SaleStartDate, 101), 101) >

CONVERT(datetime, CONVERT(nvarchar, GETDATE(), 101), 101) OR CONVERT(datetime, CONVERT(nvarchar, SaleEndDate, 101), 101) < CONVERT(datetime, CONVERT(nvarchar, GETDATE(), 101), 101)

  1. Doubt it. You're telling the program not to allow any additional discounts and now you say "Except this time"
Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required