RMS 2.0 - Purging old transactions

Make a backup of the database first to use as an archive.

SO Administrator - Database - Delete Transactions...

You can also do this with a query: Delete e from [transaction] t join transactionentry e on t.storeid=e.storeid and e.transactionnumber=t.transactionnumber where time

Your other option is to use our Archive Tool that takes the old data out and stores it a different database. This archived database being an RMS database is still available in case you want to query some receipt or reports. Further, the archive will not inadvertently take out data that may leave orphan records. For example if some detailed data from two years ago is also in an opened Accounts Receivable it will leave that record there. When it finishes it compacts and shrinks the database. Contact me for prices and more detail.

Afshin Alikhani - snipped-for-privacy@rrdisti.com

Retail Realm Distribution

Matt:

If I do the complete purge and only care about current inventory counts, I assume the items that may still be on the shelf from that period would have lost counts?

Thanks!

"Matt Hurst" wrote:

EfectiveDate > 45 WorksheetHistory DELETE W from WorksheetHistory W JOIN Worksheet on