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 / Microsoft Dynamics RMS (Archived) / How to clear store wor...
Microsoft Dynamics RMS (Archived)

How to clear store worksheet status in HQ

(0) ShareShare
ReportReport
Posted on by BryceA 165

Hi,

I am on Microsoft RMS 2.0 and want to delete the store status entries for all the worksheets that have been uploaded, processed etc.  I have over 40k entries for one store and that's about average for my 3 other stores.  The result of this bloated status app is delays in opening the page and retrieving the current status.  Worst of all it takes up space on the DB server(which is low on space) 

Is there a way to delete these entries?  Ideally from a certain ref/time number but I don't mind deleting all of them if it's easier. 

On a related topic I deleted some entries from the "Event Viewer".  It has a feature to delete plus filter on a time period.  Anyways, I did this and not that entries were truncated but disk space didn't increase much.  I deleted about 3 yrs worth of logs so I expected a significant reallocation of disk space.  Is there something else that needs to happen for the disk space to increase? 

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: How to clear store worksheet status in HQ

    Hello Mas,

    Thank you for your question.

    You may view the new Statement of Direction for RMS at the following link. It is updated as of 12/21/2011:

    mbs.microsoft.com/.../mdrsssod.htm

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS Support Engineer

  • Community Member Profile Picture
    Community Member on at
    Re: How to clear store worksheet status in HQ

    Did Microsoft release a new Statement of Direction for their RMS/POS products yet? If so can you give me a link?

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: How to clear store worksheet status in HQ

    What type of business?

    Be sure to read the new Statement of Direction that should be out in Nov before jumping ship. Big changes are coming.

    Handhelds can be expensive (~$1500+).  In addition, theft, drops, etc.  Again it depends on the environment and what is being sold.  Go into an Apple store and see what they do with their iPODs.  If a Microsoft store is nearby, some of them are using Motion tablets www.motioncomputing.com/  but they are using AX for Retail so its not quite the same as RMS.  We have a sample on the way to us to see how well it works with RMS.  

    Are you positive that the add-ons will not work with RMS 2.0?  I know you don't want to buy them again, but are you sure that someone else doesn't offer them?

  • BryceA Profile Picture
    BryceA 165 on at
    Re: How to clear store worksheet status in HQ

    It's a s long story,  but the short of it is we have about a dozen customizations and no vendor(original closed shop) to update them...amongst other things.

    We're purchasing completely new POS system during the first part of 2012.  Thinking handhelds...Any input?

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: How to clear store worksheet status in HQ

    If you have access, why are you still running 1.2?

  • BryceA Profile Picture
    BryceA 165 on at
    Re: How to clear store worksheet status in HQ

    I have access and that's what I am looking for.  thanks!

  • Verified answer
    Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: How to clear store worksheet status in HQ

    Must have access to CustomerSource

    http://tinyurl.com/3sezcr9

  • BryceA Profile Picture
    BryceA 165 on at
    Re: How to clear store worksheet status in HQ

    Oh that's a typo.  It should have originally read version 1.2.  Any other ways to purge?  third party tools? SQL ?

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: How to clear store worksheet status in HQ

    No, it does not exist on 1.2, but your first post said you were on 2.0.  A different poster?

  • BryceA Profile Picture
    BryceA 165 on at
    Re: How to clear store worksheet status in HQ

    I don't see the "delete completed worksheet option" for my HQ admin instance.  Are you sure that function existed in version 1.2?  

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,269 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans