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) / Need Idiot proof instr...
Microsoft Dynamics RMS (Archived)

Need Idiot proof instructions for deleting old journal entries in RMS

(0) ShareShare
ReportReport
Posted on by kdbush64 90

 Help!  I am a simple shop keeper.   I am running RMS 1.2.   I would like to delete all old journal entries older than 3 weeks.  My problem is I do not know how to run SQL queries and commands.   Any help would be appreciated.

*This post is locked for comments

I have the same question (0)
  • RAFI Profile Picture
    RAFI 75 on at
    Re: Need Idiot proof instructions for deleting old journal entries in RMS

    RUN Sotre Operation Admistrator

    Click File -> Connect then you will get a window

    Enter ur Server name

    Enter ur user name and password of sql server (if ur using trusted connection then just select the windows authontication)

    Select ur database and click ok.

    After the successfull connection u can see the server name and database name on the status bar

    click the query -> new from menu then you will get the query window

    Copy and paste the following query to that window

    DELETE FROM Journal WHERE [Time] < CONVERT(DATETIME, '2008-11-29 16:39:40', 102)

    you can edit the  date but dont make any changes in query date format should be in yyyy-mm-dd

    finally you can press F5 or choose RUN from Query menu to run the query.

    All the best

     

  • kdbush64 Profile Picture
    kdbush64 90 on at
    Re: Re: Need Idiot proof instructions for deleting old journal entries in RMS

     Thanks for the help.  Just a quick question though.   Rhat does the 102 value after the timestamp represent?

  • LarryW Profile Picture
    LarryW 25 on at
    Re: Re: Re: Need Idiot proof instructions for deleting old journal entries in RMS
    102 is the Transact-SQL CONVERT statement style portion. Adding 100 to a style value gives a four place year that includes the century yyyy CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) for the complete refefrence http://technet.microsoft.com/en-us/library/ms187928(SQL.90).aspx

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