I see that if you go to Database, then schedules, one can create a schedule for a particular product to be unavailable for sale, that is not allow the product to be rung up in the POS program. For example: Liquor cannot be sold on sundays before 12PM, therefor when a employee attempts to scan liquor it blocks the item from going on the order. Is there a way I can select the entire category of Liquor and block all of the items in that category to a specific time? Currently I can go to each item in my database, and block it under the schedule I have created. But there has to be a better way than going item by item. Help?
*This post is locked for comments
Corey,
Tim is correct and his SQL Statement is sound and should work as advertised. If you are interested in creating something custom that you can use on a regular basis, please let me know and we can discuss what it would take to make happen.
Tim,
Thanks for the name drop :-)
RMS has no inbuilt capability of adding blocks by category. You could contact Ryan from RITE rsakry@rite.us for a custom program to do it or use the following SQL code if you feel comfortable doing it. Just edit the bold values to the values that match your config. You need to have created a schedule and put it's name in the bold Liquor field.
declare @CategoryID int
declare @ScheduleID int
set @CategoryID = (select id from category where name = 'Liquor')
set @ScheduleID = (select id from schedule where description = 'Sunday')
update item
set blocksalestype=2,
BlockSalesScheduleID=@ScheduleID
where categoryid = @categoryid
Hope this helps...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156