Skip to main content

Notifications

Microsoft Dynamics RMS forum

How does one activate all items in the RMS database?

Posted on by 80

Somehow, all of our items in our RMS database were 'activated'. How would someone activate all items in one full sweep (instead of 1 at a time)?

*This post is locked for comments

  • Verified answer
    Re: How does one activate all items in the RMS database?

    Hello GirlGeekInFL,

    Thank you for your questions.

    I understand that you would like to set all items to be active. The front end only allows for setting items active / inactive one at a time. If you would like to do them all at once, this must be done through an SQL Query:

    Backup Your Database Before Following These Steps

    1. Open Store Operations Administrator

    2. Click on File | Connect

    3. Enter your credentials. Click OK.

    4. Click on Query | New

    5. Enter this query:

    UPDATE Item SET Inactive = 0

    6. Press F5 to process the query.

    Let us know if that helps or if you have any other questions.

  • GirlGeekinFL Profile Picture
    GirlGeekinFL 80 on at
    Re: How does one activate all items in the RMS database?

    Yes, i do realize tha thtis could be done at the SQL level, but thanks for replying.  However,  these are Store Managers using Headquarters Manager that don't have any SQL knowledge.

  • Sad Profile Picture
    Sad 650 on at
    Re: How does one activate all items in the RMS database?

    Hi,

    It is easy for anynoe how knows about SQL statments,

    Note: that this guy needs the SQL server password to do such things.

    Good day

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

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans