Remove journal receipts


C

coupleofdogs

A while back it was suggested that I delete the journals in order to speed
things up/make more space. I have searched and can't seem to find any
information on how to do this. Do I need to run an sql or is there simply
something ro run on RMS?

Thanks for the help.

coupleofdogs
 
Ad

Advertisements

N

Nashat

Actually, journals cosume a big amount of space in the database, u can
schedule a job to delete journals older than 1 or 2 moths (based on what the
finance department will accept)

just create a new job, schedule it to run on daily basis to remove journals
older than a month, add the following statement in the only step in the job

*************************
DELETE Journal
WHERE Time < getdate() - 30
*************************
 
Ad

Advertisements

J

Jason

What about a simple way to archive them without an add-in? Any
possibilities?

How are they stored in the database?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Receipt not in journal 1
Journal Receipts 1
journal receipt 1
Receipts not journaling? 1
UK Wages Journal 0
Reprinting Receipts/Journal 2
Receipt Not posting to the Journal 8
Reviewing journaled receipts 4

Top