1. Home
  2. Point-Of-Sale Software
  3. No discount allowed

No discount allowed

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.
Reply to
Kris
Loading thread data ...

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"
Reply to
Jeff

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.