Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

RMS ITEM Data cleanup

Posted on by Microsoft Employee

Hi Folks 

RMS 2.X Single store

What is the best way to archive and/or delete items that we will no longer be ordering and that we no longer have on-hand. 

Any impacts to historical reports from doing this archiving and/or deleting process. 

Thanks

Danny

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,645 on at
    RE: RMS ITEM Data cleanup

    Hi Danny! As Todd mentioned, you never want to delete items from the database as it would effect historical data/reports that you may need in the future. Best option is to run a  SQL script in RMS Admin that will set selected items to "inactive".  Please contact your RMS Partner for assistance.

  • ToddB Profile Picture
    ToddB on at
    RE: RMS ITEM Data cleanup

    Hi Danny,

    There is not a built in archiving feature for RMS.

    Maybe one of the partners on this forum know of an archiving add-on that may do this.

    However, I could see issues with reporting if items were removed.

    _______________________________________________

    Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

    https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

    Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs
     
    pastedimage1618026289692v1.png

    This is around 3 months from now; and you can continue using RMS after this date but technical support will not be available.

    I would recommend checking with your partner in regard to what they may recommend as a replacement system after the extended support end date.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans