prevent discount below a specific profit percetage

i understand that the lower band helps prevents the sale of an item under a certain price by giving an indication to the cashier but what i would like to know is how can i input a lower bound for all my items using a % of the sale price? i have over 3000 item and would like to do it in a way where anything sold can only be sold at 10% discount at most or you get an indication.

thanks

Reply to
gs parmar
Loading thread data ...

hi,

you can go to SO Administrator program, then click on File >Connect> Enter the Servername, user id and password and also select the database and then connect.

Click on Query > click New and then run the following below clause in query pane

Update Item set PriceLowerBound=Price*.9 -- Update the Lower Bound Price to

90% of Sales Price and automatically 10% will be discount allow for the cashiers.

Rate this my dear.

Akber

"gs parmar" wrote:

Reply to
Akber Alwani

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.