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
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:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required