web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / How can I block an ent...
Microsoft Dynamics RMS (Archived)

How can I block an entire category of items for a specific time and make them unavailable for sale?

(0) ShareShare
ReportReport
Posted on by Corey Hardersen 20

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

I have the same question (0)
  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at
    Re: How can I block an entire category of items for a specific time and make them unavailable for sale?

    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 :-)

  • Suggested answer
    TimB Profile Picture
    TimB 1,175 on at
    Re: How can I block an entire category of items for a specific time and make them unavailable for sale?

    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...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans