Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

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

Posted on by 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

  • 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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans