Is there a way to make No Discount allowed on an item

I know through item properitiies you can selection the option tab and then select no disocunt allowed, but is there a way to not allow a discount on a whole category of items?

Thanks.

Reply to
Rea
Loading thread data ...

Hi Rea - this is another reason the inventory wizard needs improvement - ie, assigning the "no discount" flag to a group of items, or a discount scheme, or a schedule discount, etc. Hopefully version 3 has addressed this....

In the meantime, you can use a sql update query if you want all items in a certain category be flagged as "do not allow discounts" - BACKUP YOUR DATABASE FIRST AND RUN AFTER HOURS IF POSSIBLE

Connect to your database with SO administrator and open up a new query - First run a couple select queries

select * from category (confirm and jot down the id of the category you want to set to "do not discount)

-- lets say your category id is 3

then run... select itemlookupcode, description, price, quantity from item where categoryid = 3 (this will show you all the items in your category)

If all the items you see should be set to "do not discount" then you are ready for your update query - REMEMBER TO BACKUP YOUR DATABASE FIRST -

Your update query is update item set itemnotdiscountable = 1 where categoryid = 3

If after runn> I know through item properitiies you can selection the option tab and then

Reply to
convoluted

Reply to
Rea

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.