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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / RMS ITEM Data cleanup
Small and medium business | Business Central, N...
Unanswered

RMS ITEM Data cleanup

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • ToddB Profile Picture
    ToddB on at

    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.

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at

    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.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans