You’re offline. This is a read only version of the page.
What is the SQL query to uncheck (or check) the option "Item is not discountable at the POS" for items that have specific sale date periods?
*This post is locked for comments
update item set itemnotdiscountable = 0 - sets all to false
update item set itemnotdiscountable = 1 - sets all to true
if you need only some items then you will require a where clause.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (