Home Page link  

HOw can i delete old Quicsell 2000 Journals from RMS 2.0

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
HOw can i delete old Quicsell 2000 Journals from RMS 2.0 Robert 08-11-2008
Posted by Robert on August 11, 2008, 1:12 am
Please log in for more thread options

Some time ago (about a year) we upgraded from quicksell to RMS 2.0
In March 2008 WE HAVE DELETED all 07 data and journals but i just found
out my Quicksell journals are still there , how can i get rid of them /.
I can access the old journals from Utilities --> view old SQ2000 journals


Thanks
Robert


Posted by Michael on August 12, 2008, 4:43 pm
Please log in for more thread options

From Store Administrator do the following SQL query

Delete OldJournal

--
Disclaimer:

Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.

--

Regards
Michael
(Brisbane, Australia)


> Some time ago (about a year) we upgraded from quicksell to RMS 2.0
> In March 2008 WE HAVE DELETED all 07 data and journals but i just found
> out my Quicksell journals are still there , how can i get rid of them /.
> I can access the old journals from Utilities --> view old SQ2000 journals
>
>
> Thanks
> Robert
>



Posted by Robert on August 13, 2008, 3:29 pm
Please log in for more thread options


This works , the command d seems to be simple.
Do you by any chance have anything like a sqg command guide for RMS, is
there anything like that even available ?
Something in a form af a reference for the advaced users of RMS.



"Michael" wrote:

> From Store Administrator do the following SQL query
>
> Delete OldJournal
>
> --
> Disclaimer:
>
> Always test any queries that modify data on a test database prior to running
> on your live data to ensure the desired results.
>
> Always back-up prior to running any SQL delete queries on your live data.
>
> --
>
> Regards
> Michael
> (Brisbane, Australia)
>
>
> > Some time ago (about a year) we upgraded from quicksell to RMS 2.0
> > In March 2008 WE HAVE DELETED all 07 data and journals but i just found
> > out my Quicksell journals are still there , how can i get rid of them /.
> > I can access the old journals from Utilities --> view old SQ2000 journals
> >
> >
> > Thanks
> > Robert
> >
>
>
>

Similar ThreadsPosted
Delete old Register Journals April 11, 2008, 11:43 am
Old Journals July 20, 2005, 8:17 am
SQL Help with Journals Please October 12, 2007, 7:59 am
Help viewing journals July 7, 2005, 3:34 pm
RE: deleting journals June 27, 2007, 7:06 pm
Re: deleting journals June 27, 2007, 4:49 pm
deleting old journals October 8, 2007, 9:58 pm
shrinking journals January 14, 2008, 4:32 pm
Purge Old Sales and Journals August 8, 2006, 9:25 pm
deleting and shrinking journals January 6, 2008, 7:21 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap