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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / How to kill old stores...
Microsoft Dynamics RMS (Archived)

How to kill old stores no longer being used

(0) ShareShare
ReportReport
Posted on by Community Member

We have several old stores that show up in HQ that are physically no longer in existence. Any tips on how to remove them? They show up on worksheets that get created and then the worksheets never complete. Many of them have inventory that affects reports, etc...

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: How to kill old stores no longer being used

    Hi Mike.

    On which version RMS are you? I think since the Feature Pack 2 the stores can be made Inactive, then RMS will exclude them from the list of Stores you work with. Inactive stores can be made Active again.

    Best regards, A.

  • Community Member Profile Picture
    Community Member on at
    RE: How to kill old stores no longer being used

    RMS Version 2.0 with FP1 w/ SP4 Refresh 2.0.0155 (DB ver 2.04)

  • Verified answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: How to kill old stores no longer being used

    Try creating test environment, restore a RMS HQ database backup there and update it to FP2 and you can try the options of Active/Inactive stores...

    Kind regards, A.

  • Community Member Profile Picture
    Community Member on at
    RE: How to kill old stores no longer being used

    I actually have a test environment that is at RMS Version 2.0 with CU5 2.0.2000 (DB Ver 2.06) and I see that option in there as well as the option to delete the store.

    I don't want to loose the history, so I did not delete it, but I did inactivate one store. Now I don't see that store in the worksheet list, and I don't see that store in the Store Quantity tab in HQ items anymore, and I don't see the on hand inventory when I run an item snapshot report.

    Since I don't have the latest version of RMS in my production environment and I can't "inactivate" the stores;  I zeroed out the HQ quantity using the 190 worksheet by exporting the list, editing it in Excel and importing it back. Then I found another forum entry that gave some code to zero out the snapshot quantity for an active store in the item dynamic table, so I ran that in my test environment and it worked to get rid of the on hands in the snapshot report.

    I guess now I have to decide if we want to upgrade the production environment! We'd have a lot of testing to do since we are integrated with nChannel and Oracle, and have not tested the integrations yet in our test environment!

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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