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) / Making an item Inactiv...
Microsoft Dynamics RMS (Archived)

Making an item Inactive through a query

(0) ShareShare
ReportReport
Posted on by jdc03 900

So I am currently making a list of a couple thousand items that need to be marked as Inactive from one of our Vendors.  Instead of going through the this and bringing up each Item one by one, I was planning to use the QSCImport tool and give each Item a Note or Reorder Number of INACTIVE ... hoping that I would then be able to run a query to search for that Note or Reorder Number and make each result an Inactive item.

Make sense?  Is it possible??

*This post is locked for comments

I have the same question (0)
  • jdc03 Profile Picture
    jdc03 900 on at
    RE: Making an item Inactive through a query

    Sometimes the simplest answer is right there staring you in the face.   Thank you guys!!

  • Community Member Profile Picture
    Community Member on at
    RE: Making an item Inactive through a query

    Hi thanks for this question.

    The suggestion made by Sampurna sounds like just the solution you need as the functionality is there.

    If you have any questions additionally please let us know. Thanks

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Making an item Inactive through a query

    Yes, I recommend the built-in wizard(Wizard->Inventory Wizard) to do this. You can make items inactive in bulk by importing data from a Tab delimited or  a Comma delimited or a XML file.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Making an item Inactive through a query

    Yes, you could use a SQL query or the Import tool, but why not just use the RMS Wizard?

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