Discount Prices

I think you are out of luck with this one. I do not believe there is a way to prevent sales of items with prices lower than costs per se. Here are a couple of suggestions:

- Create an HTML status bar that provides a very conspicuous warning if an item price is lower than cost at the POS. (I haven't actually tried this, but think it can be done). This will add to the Lower Bound feature's effectiveness.

- Run a SQL query periodically to identify negative or low profit items. Maybe do this after each PO receipt.

SELECT * from Item where Cost < Price or to get things with profit margin under a certain percentage (this example is 15%): SELECT * from Item where Price / 1.15 < Cost

These won't actually prevent sales under cost, and depending on permissions, your cashier may give a discount that results in negative profit...

Now you can provide warnings when you try to sell below a given cost using the Upper Bound feature. To set the lower bound price equal to cost via SQL, use this (BACKUP!!!):

UPDATE Item SET LowerBound = Cost

or, if you want to enfore a particular profit margin (15% shown below):

UPDATE Item SET LowerBound = Cost / (1/1.15)

Do this any time your costs change and you should be covered. Again, it is not 100% prevention, but will provide a warning.

"khemikahardkore" wrote in message news: snipped-for-privacy@microsoft.com...

We have an add-on "Store Utility" that controls this and more. Contact me for more info.

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = "khemikahardkore" wrote in message news: snipped-for-privacy@microsoft.com...